
SELECT mara~matnr makt~maktxINTO CORRESPONDING FIELDS OF TABLE lt_maktFROM maraINNER JOIN makt ON mara~matnr = makt~matnrWHERE mara~matnr = '000000000000000001' .
SELECT mara~matnr makt~maktx
INTO CORRESPONDING FIELDS OF TABLE lt_makt
FROM mara
LEFT JOIN makt ON mara~matnr = makt~matnr
WHERE mara~matnr = '000000000000000001' .
SELECT mara~matnr makt~maktx
INTO CORRESPONDING FIELDS OF TABLE lt_makt
FROM mara
RIGHT JOIN makt ON mara~matnr = makt~matnr
WHERE mara~matnr = '000000000000000001' .
