In SAP how to find a Table behind a Transaction Code
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.
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.
Now you can use the above concept to know Transaction Codes for anything and everything
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?
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.
Great, it really is good way find the tables.
I liked.. good.
Thanks for sharing the information.
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?
Excellent note, thanks for sharing.
Fantastic excellent job that was really helpful to us Thank you.
its a dream appreciated
Thanks a Lot for Kind Remarks
Really neat! Thanks for sharing!
Thanks a Lot for Kind Remarks
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?
St05. Please check the Video also.
Thank you Sir. Its great
Thanks for sharing the information
Hello ive a trouble with IW32 messege "field is read-only"
"cant change status"