Problem solve Get help with specific problems with your technologies, process and projects.

Quick SQL tracing

Here's a quick way to trace the SQL generated by Username, ABAP program, ProcessId or Transaction code and determine the execution plan.

Here is a quick way to trace the SQL generated by Username, ABAP program, ProcessId or Transaction code and determine the execution plan.
1. Run transaction ST05
2. Under select-trace, check ALL boxes.
3. Under select-trace-function, select the activate-trace-with-filter.
4. You can now trace by username, transaction, program-name or process-id.
5. Select ok and the trace will be turned ON.
6. After you have executed the program or transaction, go back to ST05.
7. Select the deactivate-trace button.
8. Select diaplay-trace button and - VOILA! - you have all the juicy information you need.
This was last published in April 2003

Dig Deeper on SAP Java and J2EE

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchERP

SearchOracle

SearchDataManagement

SearchAWS

SearchBusinessAnalytics

SearchCRM

SearchContentManagement

SearchHRSoftware

Close