bodsexpert
bodsexpert

How to find the table name of a structure field

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

During SAP data migration we come across some of the structure tables. Structure tables cannot be used to extract the data from. As its name suggests the structure table holds only structure of the table, data resides on any other table. In this post, I will try to explain how can we retrieve table name which holds data of the structure table by Data Element.


Step 1

Take F1 help. Double click on Data Element


Step 2

Click on Where-used button.

Find Table 2

Step 3

Select Table fields only

Find Table 3

Step 4

You have successfully searched the table name – /SCMB/D_BPTMGEN

Find Table 4

Step 5

You can brows the table now

Find Table 5

Conclusion

You have successfully searched the table which holds the data of a structure table. if you need more help on this or any other topic related to data migration, do connect with me.