Tables in a transaction code

[Former Member]

Hi All,

Is there any way to findout the tables used in a particular transaction? Like in mm01 transaction we come across many tables to store the data. How to find all the tables used in a particular transaction.

Rgds,

Sri

[Former Member · Accepted solution]

You can use the transaction ST05 (Trace Request):

- Open two session

- In the first session, run ST05: push Trace on (check the filter is setted with your user name, pushbutton Trace on with filter);

- On the second one, run your transaction (for example mm01);

- When your transaction has finished to work, push Trace off (in ST05) and then push Trace list: you can see all tables which are used by your transaction;

[Former Member · Accepted solution]

One of the best way is answered by Max.

In case if ur R/3 is 4.6c

then u can use Tcode SE49 to find the tables used in particular tcode.

Another way go to se93 & find the mail program name

Then go to se38 & enter the program name

Press F9 or from menu Utilities->cross-reference (R/3 4.6c)

menu Utilities->internal program environment (R/3 Enterprise)

then uncheck subroutines and check all the database operation(SELECT, UPDATE, MODIFY, DELETE) and execute

regards

gv