Finding the table from which data is fetched in SAP

You can get the data if it is displayed in a transaction. Here are the steps you need to follow.

a) First point the cursor on the field for which you want to get the data.

b) Press F1 for help. This will open a dialog with heading “Performance assistant”

c) Click on the “Technical information” button. This will open up another dialog box

d) You will be able to find “Table name” and “Field name”

Generally, this will tell you the table in the database .

If you are not able to get the required information, run a trace using ST05. In SAP system, SQL trace (ST05) is used by the developers to analyze database Select statements.

Below you can see T-code ST05 main screen −

To activate trace, you can select Activate Trace with Filter option. You can select different filters like −

• User Name
• Transaction Name
• Program Name

Giri Raju

Updated on 13-Feb-2020 12:49:48

• Related Questions & Answers
• Accessing table data from SAP system
• Retrieving data from a table in SAP ABAP
• Table type while importing data from flat file in SAP HANA
• Inserting data in table in SAP HANA
• How can I transfer data from SAP HANA to virtual table?
• Table mapping while data replication from flat file in SAP HANA database
• Searching data from the different system in SAP.
• Inserting data in a table in SAP HANA
• Update the records in a table with a specific year fetched from date format like '10/12/2010'?
• Decoding SAP text from STXL.CLUSTD table
• Deleting from temporary table in SAP HANA
• Update data in one table from data in another table in MySQL?
• Converting the data back to table using SAP FM RFC_READ_TABLE
• Which PHP functions are used in the PHP script to fetch data from an existing MySQL table?
• Viewing data in a table in SAP HANA database