image.png

    1. SELECT mara~matnr makt~maktx
    2. INTO CORRESPONDING FIELDS OF TABLE lt_makt
    3. FROM mara
    4. INNER JOIN makt ON mara~matnr = makt~matnr
    5. 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' .