Skip to content
FAST SAP SOLUTIONS®Discuss a project

START HERE · NO PRIOR TOPIC KNOWLEDGE NEEDED

What it is. Why it matters.

SQL is the language used to request database data. ST05 records database activity for a selected action so a developer can examine the queries and their cost.

Completely new to SAP?

Manufacturers use SAP to connect work such as buying components, recording inventory, planning production, shipping equipment and accounting for costs. SAP S/4HANA is an enterprise resource planning system: it connects these activities through shared business data.

ABAP is SAP’s programming language for business applications. A program reads data, applies rules and produces a result. Start with the objects involved before investigating code.

A transaction code, or t-code, is a shortcut to a task in classic SAP GUI. Fiori apps provide another way to work. Names and screens depend on the product and release; you do not need a live system to learn the concepts in this guide.

Original editorial vector illustration for SAP ST05 SQL trace: Find repeated database work before rewriting the query
Original FSS editorial vector illustration. Conceptual artwork, not an SAP interface or customer-system evidence.
Scope and source-review notes

Scope and evidence

Source review by FAST SAP SOLUTIONS® editorial. This badge describes our editorial review; it does not represent SAP certification or independent endorsement.

Classic ST05 SQL analysis and related documented ADT SQL-trace concepts; available controls and scope depend on backend and deployment.

Primary documentation reviewed on 14 November 2026 using official indexed excerpts. Documentation review only; authored examples were not compiled or executed in an SAP system.

A MANUFACTURING EXAMPLE

Investigate a slow component purchasing list

Trace the defined workload

Action: Open one filtered report. Trace scope: Relevant user and interval. Finding: Many repeated reads. Next review: Query and call pattern
What to notice: The trace should explain the measured action. It is not evidence for unrelated users or time periods.Original annotated example with illustrative values. This is not an SAP screen or a result from a customer system.
Read the example values
Action
Open one filtered report
Trace scope
Relevant user and interval
Finding
Many repeated reads
Next review
Query and call pattern
Words you’ll meet in this guide
Program
A set of instructions executed by a computer.
Class
A reusable unit that groups data with operations called methods.
Database
Organized information kept beyond one program execution.
Internal table
A list of rows held temporarily in an ABAP program’s memory.
Key
One or more fields used to identify or find a record.
ABAP
SAP’s programming language for business applications.
CDS
Core Data Services: reusable definitions of business data and relationships.
BTP
SAP Business Technology Platform: cloud services for applications, data and integration.
SQL
A language used to read and work with database data.
ADT
ABAP Development Tools: SAP tools for ABAP development in Eclipse and, on supported systems, Visual Studio Code.
Preview the practical steps

SEE THE CONNECTION

See it in a simple example.

A small example to make the idea concrete.

Measured user action → SQL trace → Database evidence. Conceptual diagram for SAP ST05 SQL trace: Find repeated database work before rewriting the query.
Apply the idea: A manufacturer finds its purchasing worklist slow and needs to know whether repeated reads or expensive individual access dominates.An illustrative example, not a live SAP screen. The connections show how to think about the topic; they are not instructions to change a system.
  1. Investigate a slow component purchasing list

    A manufacturer finds its purchasing worklist slow and needs to know whether repeated reads or expensive individual access dominates.

  2. Use the SQL trace to distinguish repeated work from one expensive request

    ST05 SQL trace helps explain the database activity generated by a defined ABAP action.

  3. Scope and prerequisites

    Use ST05 where it is documented and available in the classic ABAP landscape.

  4. Understand the SQL boundary and its limits

    The SQL trace records database requests rather than a complete ABAP source-level runtime breakdown.

Reading map · FSS editorial. The sections below explain each part in detail.

Found this useful?

Share this guide with your network, or leave a like.

LinkedIn WhatsApp

Your like is saved in this browser.

Explore Knowledge Hub

Discuss Your SAP Project

Your enquiry is sent through this website and used only to respond to your request.