SAP Tables

[Former Member]

Hi,

I need to find a document where it says for each transaction code these are the tables that get updated. It should have a clear link with the transaction screen. That means the screen field should be linked to the actual field in the table that get updated. There are few diagrams in the web for SD, FC, MM, PP module indicating the tables but this is not enough. It does not cover the entire screen fields. From where could I get such a document. Will SAP have it?

Thanks,

Kishan

[Former Member]

USE SQL trace ST05 to trace which tables are getting updated if you saving any transaction.

before going to the transaction first goto ST05 , select TRACE On. then go to ur transaction either MM01,VA01 etc.. & enter your input values & save. once you get data is saved message again go back to ST05 select TRACE OFF.

& then say DISPLAY TRACE.

here you will what tables are getting updated with the above transaction.

regards

srikanth

Message was edited by: Srikanth Kidambi

[Former Member]

Hi,

Good answer, but why cant we find a document from SAP that will give us the links. This would make life easy for programmers.

Thanks,

Kishan

[Former Member]

Hi kishan,

Your idea of remembering the tables which are getting updated if we save a transaction is good. but my concern is how many transactions you will remember & how many tables you will put it in your mind ?

for example : if you are creating a material, based on the views you select in the first screen of MM01, number of tables getting updated will be determined.if you create a material with MRP view then only MARC table will have 1 entry for that material.else it wont have.

like that many tables will get updated based on the user requirement.

My suggestion is try to remember the master tables names & transaction codes. once you get the actual object with couple of requirements, you will become familiar with other tables.

for table names ,you can search in SAPGENIE.COM, sappoint.com etc.. sites.

regards,

srikanth

[rahulkavuri]

Please send me a mail to rahulkavuri@gmail.com , I will forward the related material for it

[Former Member]

Hi,

check this link..

http://www.sapgenie.com/abap/tables.htm

Regards

vijay

[Former Member]

Hi Vijay,

I have this info, but I'am trying to reach SAP. Do U know how I could contact SAP for such document. A email address would be fine, also we running SAP AFS 5.0 version which is industry specific.

Thanks,

Kishan

[Former Member]

Hello,

personally i disbelieve that such a document is existing . The link to sapgenie is quite good, but there are only the main tables of the modules.

The main problem is the complexity: a sales order may have a relation to a costing element, but if there is such a relation and to which kind of costing element is a question of customizing..

A helpful thing could be transaction could be SD11 - Data modeller -but that oriented on business objects ( not on transactions)

Regards Wolfgang