For project reasons I need to find all tables whose fields have used a given table say COMM_PRODUCT as check table.

The only information I know is that such kind of table metadata is stored in table with name prefix DD*. Unfortunately there are huge number of table starting with DD:

How to efficiently find the exact one by yourself?

(1) Make the check table field selected, and press F1:

In popup dialog, click this icon to display technical information:

Unfortunately, the found DD03P_D is a structure, so it is not possible to view it via tcode SE16. Nevertheless let’s write down the field name CHECKTABLE.

(2) Go to SE80 -> Repository information system, double check ABAP Dictionary -> Fields -> Table fields, type field name as CHECKTABLE and search

The DD08L seems to be the table I am looking for.

Double confirm in SE16:

Confirmed