SELECT a~matnr a~ersda a~mbrsh a~mtart a~meins a~matkl a~bismt a~zeinr a~mfrpn
b~ekgrp b~dismm b~mtvfp b~bwtty
c~werks c~lgort
d~maktx
INTO CORRESPONDING FIELDS OF TABLE itab1
FROM mara AS a
JOIN marc AS b
ON a~matnr = b~matnr
JOIN mard AS c
ON a~matnr = c~matnr
JOIN makt AS d
ON a~matnr = d~matnr
WHERE a~matnr IN s_matnr.
VS
SELECT matnr ersda mbrsh mtart meins matkl bismt zeinr
FROM mara INTO TABLE itab_mara
WHERE matnr IN s_matnr.
SELECT matnr ekgrp dismm mtvfp bwtty
FROM marc INTO TABLE itab_marc
FOR ALL ENTRIES IN itab_mara
WHERE matnr = itab_mara-matnr.
SELECT matnr werks lgort
FROM mard INTO TABLE itab_mard
FOR ALL ENTRIES IN itab_mara
WHERE matnr = itab_mara-matnr.
SELECT matnr maktx
FROM makt INTO TABLE itab_makt
FOR ALL ENTRIES IN itab_mara
WHERE matnr = itab_mara-matnr.