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

PRO+

Content

Find more PRO+ content and other member only offers, here.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

-ADS BY GOOGLE

SearchManufacturingERP

SearchOracle

SearchDataManagement

SearchAWS

SearchBusinessAnalytics

SearchCRM

SearchContentManagement

SearchFinancialApplications

Close