‎2006 Jul 03 7:49 AM
While creating a material how i come to know the name of tables which are effected.
‎2006 Jul 03 7:52 AM
Hi,
You can use trx ST05 - sql trace to check the tables name.
1. go to ST05.
2. activate the trace for your user id.
3. create material.
4. again go to ST05.
5. deactivate the trace.
6. display the trace.
Regards,
Shashank
‎2006 Jul 03 7:53 AM
There is no direct of way of finding out the same. the following are some of the material master tables
MARA, MAKT, MARC, MARD ETC
Regards,
Ravi
Note : Please mark the helpful answers
‎2006 Jul 03 7:55 AM
Hi,
Run TCode ST05 -> Press SQL TRACE ON.
Now create the material.
Now again run Tcode ST05 -> SQL TRACE OFF.
Press Display the trace...
This will give the list of tables updated.
Thanks and Regards,
Bharat Kumar Reddy.V
‎2006 Jul 03 7:55 AM
Hi,
To understand the tables that are involved in creating a material thro MM01 transaction, you can run the trace on in ST05 transaction and create the material, once you come out of MM01, switch off the trace, and check the trace analysis, this would give the tables that are affected in this transaction,
Rgds,
‎2006 Jul 03 7:55 AM
When you giving data by using MM01 transaction then for each step you can check by pressing F1 and then can see where this data goes.
But I want to know why do you want to check that your data has been goes to what table?
Regards,
Subhasish
‎2006 Jul 03 8:00 AM
Hello
Subhasish
Well actually this helps in checking the flow of data.
‎2006 Jul 03 8:03 AM
also u can do the recording during material creation and than in recording output u check which tables are updated .....