3030306.关联内表读取数据库表数据

关联内表读取数据库表数据
TYPES: BEGIN OF lty_marc_key ,
          werks TYPE marc-werks,
          matnr TYPE marc-matnr,
       END OF lty_marc_key.
DATA: lt_marc_key TYPE TABLE OF lty_marc_key,
      ls_marc_key TYPE lty_marc_key.
ls_marc_key-werks = '1000'.
ls_marc_key-matnr = '000000000000000001'.
APPEND ls_marc_key TO  lt_marc_key.
IF lt_marc_key[] IS NOT INITIAL.
  SELECT mara~matnr makt~maktx
    INTO CORRESPONDING FIELDS OF TABLE lt_makt
    FROM mara
   INNER JOIN makt ON mara~matnr = makt~matnr
    FOR ALL ENTRIES IN lt_marc_key
   WHERE mara~matnr = lt_marc_key-matnr.
  LOOP AT lt_makt INTO ls_makt.
    WRITE ls_makt.
  ENDLOOP.
ENDIF.