SELECT mara~matnr makt~maktx
INTO CORRESPONDING FIELDS OF TABLE lt_makt
FROM mara
INNER 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
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' .