Simple JOIN

IntermediateOpen SQL⏱ 15 min

Read material and plant data by performing an INNER JOIN between two database tables.

Write Your ABAP Code

📥 Sample Input & Output

MARA + MARC
Input MATNR: A100
Output: A100 – Plant 1000

💡 Hint

Use SELECT ... FROM a INNER JOIN b ON

✅ View Reference Solution

SELECT a~matnr, b~werks
  FROM mara AS a
  INNER JOIN marc AS b
    ON a~matnr = b~matnr
  INTO TABLE @DATA(lt_data).