SELECT with WHERE Condition

BeginnerOpen SQL⏱ 10 min

Fetch only materials from MARA where material type (MTART) is FERT.

Write Your ABAP Code

📥 Sample Input & Output

MATNR   MTART
A100    FERT
A200    HALB
A300    FERT

Fetched: A100, A300

💡 Hint

Use a WHERE clause inside the SELECT statement.

✅ View Reference Solution

SELECT *
  FROM mara
  INTO TABLE it_mara
  WHERE mtart = 'FERT'.