How to find which database table the source of a certain field in an ABAP structure comes from

A friend in my WeChat group asks:

How to find a field in an ABAP structure, and from which database table field is the value at runtime written?

Taking ABAP structure BAPIAD1VL as an example, suppose we need to find the source of the field DISTRCT_NO.

In fact, there is no way too good or precise. I am here to provide a way.

Select DISTRCT_NO, click the Where used list icon on the SE11 toolbar:

There are 4 results, one by one manually viewed. If the number of results is large, this method is very inefficient.

In the third record, it was found that the CITYP_CODE field of the ADDR1_VAL structure was written into the BAPIAD1VL-DISTRCT_NO field of the target structure we were looking for.

This ADDR1_VAL is still an ABAP structure, so we have two choices here.

One is our goal, to find where the field CITYP_CODE of the structure ADDR1_VAL comes from. You can recursively use SE11's where used list to search for the field CITYP_CODE, until the search results find the real database table to end the exploration.

The second option is to use SE80's Repository information system.

Open SE80, expand Fields->Table Fields on the left, and enter CITYP_CODE on the right:

In the search results, we found that the CITYP_CODE field of the two tables ADRCITYPRT and ADRSTREET is most likely the field we are looking for.

At this time, manually go to SE16 to check the fields of these two tables to confirm.

In addition, this friend in the group also asked about check table. This concept is often confused with another value table.

check table

It is just a table containing all valid entries for a specific foreign key table field. Used for field-level validation (it restricts field values).

value table

The value table is maintained at the domain level, also known as domain-level authentication.

The difference between the two

• The check table will check the input value of the table field entered in any application, and the value table will provide the value for the table field on the F4 help.
• check table defines foreign keys and is part of the table definition. The value table is part of the domain definition.
• The check table is field-level verification, and the value table is field-level verification, which is used to provide F4 help for all fields referencing the domain.

More original articles by Jerry, all in: "Wang Zixi":