SQL Trace Analysis (ST05)

AdvancedPerformance Tuning⏱ 15 min

Task

Identify inefficient database access patterns that would appear in ST05 SQL Trace and refactor the logic to minimize database calls.

Write Your ABAP Code

📥 Sample Input & Output

Multiple SELECT SINGLE calls inside LOOP
ST05 shows repeated SELECT executions

💡 Hint

Avoid SELECT SINGLE inside loops. Fetch data once usingFOR ALL ENTRIES or joins.

✅ View Reference Solution

SELECT matnr
  FROM mara
  INTO TABLE @DATA(lt_mara).

LOOP AT it_data INTO DATA(ls_row).
  READ TABLE lt_mara WITH KEY matnr = ls_row-matnr TRANSPORTING NO FIELDS.
ENDLOOP.