topic Re: Data Dictionay in Application Development and Automation Discussions

Data Dictionay

Former Member — Mon, 03 Jul 2006 06:49:28 GMT

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

Re: Data Dictionay

Former Member — Mon, 03 Jul 2006 06:52:34 GMT

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

Re: Data Dictionay

Former Member — Mon, 03 Jul 2006 06:53:43 GMT

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

Re: Data Dictionay

Former Member — Mon, 03 Jul 2006 06:55:22 GMT

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

Re: Data Dictionay

Former Member — Mon, 03 Jul 2006 06:55:30 GMT

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,

Re: Data Dictionay

Former Member — Mon, 03 Jul 2006 06:55:49 GMT

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

Re: Data Dictionay

Former Member — Mon, 03 Jul 2006 07:00:13 GMT

Hello

Subhasish

Well actually this helps in checking the flow of data.

Re: Data Dictionay

Former Member — Mon, 03 Jul 2006 07:03:14 GMT

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