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 to find the table from which data is fetched in SAP.

Method 1: Using F1 Help and Technical Information

This is the most straightforward method to identify the source table for any field displayed in SAP ?

1. First, point the cursor on the field for which you want to get the data
2. Press F1 for help. This will open a dialog with heading "Performance assistant"
3. Click on the "Technical information" button. This will open up another dialog box
4. You will be able to find "Table name" and "Field name"

Generally, this will tell you the table in the database from which the field data is retrieved.

Method 2: Using SQL Trace (ST05)

If you are not able to get the required information using the F1 method, run a trace using ST05. In SAP system, SQL trace (ST05) is used by the developers to analyze database Select statements and track which tables are being accessed.

Below you can see T-code ST05 main screen ?

Activating SQL Trace

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

• User Name
• Transaction Name
• Program Name

After setting up the appropriate filters, execute the transaction you want to analyze. Then deactivate the trace and analyze the results to see which database tables were accessed during the transaction execution.

Conclusion

These two methods provide effective ways to identify source tables in SAP - the F1 technical information method for quick field-level identification, and the ST05 SQL trace for comprehensive database access analysis during transaction execution.