Analyzing SQL Statements

Prerequisites

You have traced your ABAP program either Tracing an ABAP Program or by Scheduling a Trace.
The trace option Enable SQL trace is switched on for relevant trace. More on this: Setting Trace Preferences.

Context

When you create an SQL trace file, you can see exactly how the system handles database requests.

To display the SQL trace events for a trace:

Procedure

Open the ABAP Traces view.
In the view, expand the relevant project tree and double-click the trace entry to open the trace overview.

The Overview page appears for the selected trace.
On the section Analysis Tools, open the link for SQL Trace.

Results

The system displays the Trace List in the SAP GUI window.

You can then analyze:

The SQL statements executed by your application
The values that the system uses for particular database accesses and changes
How the system converts ABAP Open SQL statements (such as SELECT) into Standard SQL statements
Where your application executes COMMITs
Where your application repeats the same database access
The database accesses and changes that occur in the update part of your application.