In SAP how to find a Table behind a Transaction Code

 Introduction

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.