Often we would like to know which transparent tables a SAP transaction is using. With the transaction ST05 this is easy to achieve.

Follow the steps below to learn how to find all those tables in an easy way.

In this case we would like to find out where the material master is stored.

 

First we start the transaction MM03 (Display Material).

Then we start the transaction ST05

 

In ST05 we click on [Activate Trace]

 

After activating the trace we go back to the transaction we would like to trace, in this case MM03. Now we should perform the actions that would involve the tables to be traced.

 

Finally we go back to ST05 and deactivates the tracing and clicks on [Display Trace].

 

We just accept the default values.

 

Now we are able to see which tables the transaction has been accessing. Under Obj. name we can see the table names and on the right the statements the transaction has been running. In this case we can see that MM03 has been accessing the tables MARA, MARD, MEAN and others. We can also see that the transaction has been queering for the material 000000000000300009.