Avoid SELECT in LOOP

IntermediatePerformance Optimization⏱ 20 min

Refactor inefficient database access by removing SELECT statements inside loops and fetching data efficiently.

Write Your ABAP Code

📥 Sample Input & Output

Before:
LOOP → SELECT SINGLE

After:
Single SELECT → LOOP

💡 Hint

Fetch required data once into an internal table before looping.

✅ View Reference Solution

SELECT matnr werks
  FROM mara
  INTO TABLE @DATA(it_mara).

LOOP AT it_mara INTO DATA(ls_mara).
  " Process data
ENDLOOP.