‎2008 Nov 18 8:32 AM
Moderator message: please use a meaningful subject in future. Thank-you.
i wanted to know how do we get to know which tables are getting updated when we enter values in a transaction..for example..in mm01 we enter various fields such as material number(matnr),material type (mtart) and so on..these values are getting updated in different tables..so how do we know in a transaction when we enter values which tables are getting updated??
Edited by: Matt on Nov 18, 2008 11:01 AM
‎2008 Nov 18 10:34 AM
Hello Asha,
Standard Transcation codes will be created with lot of joins using lot of tables.
To know which table is getting populated you should know the relationships of each and every table that are used in the Transcation code.
Also, to know which table is getting populated, you first need to
Open the SE93 Transcation code
Enter the T-code that you wish to have a look at.
Click on Display.
It will display the program that has been used for that T code.
Copy the program and go to Se80
Give the program name and at the left hand side you can have a look at the tables
that has been used in that Tcode.
After you get the tables please go through the link below to understand the relationships:
http://www.sap-img.com/general/sap-r3-tables.htm
So that you can understand how the data is flowing and where it will be saved.
Regards,
Kittu
‎2008 Nov 18 8:49 AM
‎2008 Nov 18 9:12 AM
Hello asha h
Go to se80 enter the transaktion -> go to the Report an surch for Update / Modify
For example Fuba MATERIAL_UPDATE_ALL
hope it helps
regards
Chris
‎2008 Nov 18 10:34 AM
Hello Asha,
Standard Transcation codes will be created with lot of joins using lot of tables.
To know which table is getting populated you should know the relationships of each and every table that are used in the Transcation code.
Also, to know which table is getting populated, you first need to
Open the SE93 Transcation code
Enter the T-code that you wish to have a look at.
Click on Display.
It will display the program that has been used for that T code.
Copy the program and go to Se80
Give the program name and at the left hand side you can have a look at the tables
that has been used in that Tcode.
After you get the tables please go through the link below to understand the relationships:
http://www.sap-img.com/general/sap-r3-tables.htm
So that you can understand how the data is flowing and where it will be saved.
Regards,
Kittu