How to Find the Table Name of a Structure Field

By Imran, Mohammad on January 25, 2022 under SAP ECC/S4HANA

During SAP data migration, we often encounter structure tables. Structure tables cannot be used to extract data, as their purpose is to define the structure of a table rather than store the actual data. The data associated with these structures resides in a separate table.

In this post, I will explain how to retrieve the table name that holds the data for a structure table by using the Data Element.

Step 1

Access the F1 help and double-click on the Data Element link.

Step 2

Click on the Where-used button.

Step 3

Select Table fields only.

Step 4

You have successfully searched for the table name: /SCMB/D_BPTMGEN.

Step 5

You can now browse the table.

Conclusion

You have successfully identified the table that holds the data for a structure table. If you need further assistance on this or any other topic related to data migration, feel free to connect with me.