Skip to Content
Technical Articles
Author's profile photo arghadip kar

In SAP how to find a Table behind a Transaction Code

Introduction.

After working with SAP for more than 15 years and travelling across the Globe for SAP Projects one issue I always use to have how can I keep track of all the SAP Transaction Code associated with different Modules. If you are working as a SAP ABAP Consultant you need to keep the name of transaction Codes  in your Fingertips. Sometimes this you know from other Experts and sometimes you have to dig it out. After exploring I found a very easy way to dig out the SAP Transaction Code associated with a Business Process Area. Just check this blog and conquer the SAP world.

This is very fundamental but very important. Everyone who is working  as a Consultant will use it all the time. This Tutorial will help them to find the SAP Tables behind any SAP Transaction Codes whether it is SAP ECC and SAP S/4 HANA.

 

Solution.

Step by Step instruction

Go to Transaction Code ST05 and activate Trace for your SAP User Id.

Now suppose the requirement is to get the Table that stores the Field of all Standard Tables. In this example I want to Find the Table that stores EKKO Table field as a matter of fact any table fields.

Below is the EKKO Table Field

Deactivate the Trace from ST05

Now Display Trace

Execute on the below Option

Now we got the Result

 

Now hit the Find button as shown in Blue

Now Search with Keyword EKKO

I think below is the table that has all the field names for Table EKKO

Let us verify by going to SE16 and enter table name DD03L

Now we enter TABNAME as EKKO shown below

WALA we got our Result

We can use the above concept to get any table behind a Transaction Code.

Please check below link for Video option.

 

Conclusion

Now you can use the above concept to know Transaction Codes for anything and everything

Assigned tags

      16 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Matthew Billingham
      Matthew Billingham

      So effectively - use SQL trace to find out what tables are hit by a transaction. How would you then find, for example, from exactly where a field within a transaction is stored?

      Author's profile photo arghadip kar
      arghadip kar
      Blog Post Author

      if it has reference with another relationship without the Key field you have to explore more but the chances are very high to find the tables name from this solution.

      Author's profile photo Subhash Nikam
      Subhash Nikam

      Great, it really is good way find the tables.

      Author's profile photo Manuel Robalinho
      Manuel Robalinho

      I liked..  good.

      Author's profile photo Hanifa Aziz
      Hanifa Aziz

      Thanks for sharing the information.

      Author's profile photo Michelle Crapo
      Michelle Crapo

      You did an excellent job of driving company here from Linkedin.   I love it.

      I honestly think there are 100 different ways of doing things.   There are a lot of programs written to do this in GITHUB.  I also have been looking for CDS lately instead of a table.  CDS when you are looking them up are simply views in the data dictionary.  (They are of course more that that.)  A different blog?

      Author's profile photo MAHAVIR PATIL
      MAHAVIR PATIL

      Excellent note, thanks for sharing.

      Author's profile photo Mahendra Tadeapalli
      Mahendra Tadeapalli

      Fantastic excellent job that was really helpful to us Thank you.

      Author's profile photo Omar Saad
      Omar Saad

      its a dream appreciated

      Author's profile photo arghadip kar
      arghadip kar
      Blog Post Author

      Thanks a Lot for Kind Remarks

      Author's profile photo Steve Nipps
      Steve Nipps

      Really neat! Thanks for sharing!

      Author's profile photo arghadip kar
      arghadip kar
      Blog Post Author

      Thanks a Lot for Kind Remarks

      Author's profile photo Ravi Kiran
      Ravi Kiran

      i couldnt find t-code in screen shot..can you help?  and if i knwo a tcode and how to know the table behind it? ex: iw59 is there. i want to know where the data is being stored. can we find it?

      Author's profile photo arghadip kar
      arghadip kar
      Blog Post Author

      St05. Please check the Video also.

      Author's profile photo ilknur Asgerov
      ilknur Asgerov

      Thank you Sir. Its great

      Author's profile photo Cigil R
      Cigil R

      Thanks for sharing the information