SAP Table relations

[Former Member]

Hello, I am in a process of learning Generic Extractors, now i get really confused on the relations between different table and fields while creating data source in ECC, I really appreciate if anyone have documents which explains in an easy way to understand the relations between all tables and files

Thanks

Ram

[markus_doehr2]

A SAP ERP system has some ten thousand tables, there may more or fewer of them depending on the support package level and on activate business functions. Therefore it's impossible to have an ER diagram about relations.

On top comes the fact, that in an ERP system the data is (historically) not really normalized so you may find the same data in different tables depending on how the system is configured/customized.

If you want to find out where certain data is stored/read, start an SQL trace in transaction ST05, then start the transaction displaying the data, go back to ST05 and evaluate the SQL statement generated.

Markus