Skip to Content

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

/wp-content/uploads/2016/09/clipboard1_1045340.png

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:

/wp-content/uploads/2016/09/clipboard2_1045341.png

How to efficiently find the exact one by yourself?

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

/wp-content/uploads/2016/09/clipboard3_1045342.png

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

/wp-content/uploads/2016/09/clipboard4_1045343.png

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.

/wp-content/uploads/2016/09/clipboard5_1045344.png

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

/wp-content/uploads/2016/09/clipboard6_1045346.png

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

/wp-content/uploads/2016/09/clipboard7_1045347.png

Double confirm in SE16:

/wp-content/uploads/2016/09/clipboard8_1045348.png

Confirmed 🙂

/wp-content/uploads/2016/09/clipboard9_1045349.png

To report this post you need to login first.

3 Comments

You must be Logged on to comment or reply to a post.

Leave a Reply