How ro find related tables of a structure?

[former_member806437]

Hi,

In vbdkr, there are many vbeln fields. How to find which vbeln field is related to which table.

Eg: vbeln, vbeln_vl, vbeln_vauf, vbeln_vag are in vbdkr and vbeln fields are available in these tables (vbrk, vbak, lips, likp). Likewise in vbdpr.

Please help me in finding the solution.

Thanks.

[venkateswaran_k]

Hi

The naming convention and domain settings are very clean and proper in SAP. Using the domain related to that data element you can identify the primary table related to that.

There are no direct ways to see it at one shot.

• By seeing the domain related to that you can get the table.
• Or in SE11 put that data element and execute where used tables and find it.
• Or open that table - point to that column in question - go to the check

Regards,

Venkat

[former_member806437]

Hi,

Thank you so much for your reply.

The domain is same for all those data component types (vbeln, vbeln_vl, vbeln_vauf, vbeln_vag). Could you please explain how to find tables based on domains?

Thanks.

[venkateswaran_k]

Hi kunimbedu30

There are no direct ways to select the table from the column name. Please note that SAP has defined the data element name as per the functional document. ( as shown below ) So based on the data element name ( sorry last update I mentioned as domain ).

Based on the data element name - you will know what is the functional document. From there you can search for that table.

For example - please refer to this pic.

So

• VBELN_VL - Delivery - so Delivery header table ( LIKP - Primary key VBELN but data element is VBELN_VL)
• VBELN_VA - Sales document - So Sales order table - ( VBAK - Primary key VBELN but data element is VBELN_VA)

By this you can identify.

Regards,

Venkat

[raymond_giuseppi]

Either

• Analyze or trace some code/transaction that use those fields (start with a where-used search on the structure)
• Perform a where-used search on data element in table/structure (and sometimes go to domain value table)