Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Data Dictionay

Former Member
0 Likes
648

While creating a material how i come to know the name of tables which are effected.

7 REPLIES 7
Read only

Former Member
0 Likes
615

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

Read only

Former Member
0 Likes
615

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

Read only

Former Member
0 Likes
615

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

Read only

Former Member
0 Likes
615

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,

Read only

Former Member
0 Likes
615

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

Read only

0 Likes
615

Hello

Subhasish

Well actually this helps in checking the flow of data.

Read only

0 Likes
615

also u can do the recording during material creation and than in recording output u check which tables are updated .....