Register Login

How to Find Table For Transaction Code in SAP

ST05 SQL tracing tool is used to find the tables that have been accessed by a transaction code.

Goto T.Code ST05 -> Activate trace -> Open the specific transaction for which you want to find the table -> Deactivate trace -> Display trace

The Object Name column should provide for the tables that have been accessed by the T.Code

Steps to find a table behind any SAP T.Code

In this example, we are finding a table behind a Sales Order.

Step1: Enter the T.Code ST05 in the command box to activate the Trace.

Step2: In the ST05 Performance Trace screen, select the Activate Trace button.

Step3: Now start a new Session:

System-> New GUI Window

Step4: On SAP Easy Access Goto T.Code VA03 to display Sales Order.

Step5: In the Display Sales Documents screen, select the sales order number for which you want to show the table.

Order: 14

Press the Continue button.

Step6: Now the Display Standard Order 14: Overview screen appears:

Step7: Goto ST05 Performance Trace window and select the Deactivate Trace on All Instances button.

Then Goto More->Display Trace.

Step8: In the ST05 Filter Conditions for Trace Records screen press the execute button.

Step9: In the Performance Analysis: Trace Display(Main Records) screen press the Find button.

In the Find window type the sale order number for which you want to find the table:

Search Term:14

Check the radio button Display Number of Hits:

Press the tick button.

Step10: In the Performance Analysis: Trace Display(Main Records) screen you can see the major header table VBAK for sales order is displayed.

By the same method, we can also find tables that store all the fields of the standard table EKKO.

Step1: Goto T.Code ST05.

Step2: Activate the Trace.

Step3: Open a new session and Goto T.Code SE11.

Step4: In the ABAP Dictionary: Initial Screen type the name of the standard table for which you want to find the information.

Database table: EKKO

Step5: Dictionary: Display Tables screen shows all the fields of the EKKO table.

Step6: In the ST05 Performance Trace window press the Deactivate Trace on All Instances

More -> Display Trace

Step6: In the Performance Analysis: Trace Display(Main Records) screen, press the find button and type the table name.

Search Term: EKKO

Check the radio button Display Number of Hits and press the tick button.

Step7: In the Performance Analysis: Trace Display(Main Records) screen, you can find the table that has all the field names for Table EKKO.


Comments

  • 14 Nov 2009 6:54 pm Guest
    SE16 will display all the table names in SAP
  • 17 Nov 2009 12:46 pm Guest
    First get the Package name for the Tcode, then goto se11 there without any value press F4, then provide package name over there ... with that you will be getting all the tables to the Tcode.
    Or
    Go to ST05 and trace on, then display the tcode data. Once done with the display Tcode, then put off the trace in st05. and finally display the trace...you will be getting all the tables in side the ST05 analysis.
    Hope understood
  • 17 Oct 2013 9:39 pm Guest
    please define briefly st05 processes.
    Because i do not want to remember table name cat. is it possible i can search table name by t code.
    Thanks
    NK VERMA