DATA:
        lt_ekpo     TYPE TABLE OF ekpo,
        lt_t001w    TYPE TABLE OF t001w.


  SELECT ebeln ebelp matnr werks FROM ekpo
    INTO CORRESPONDING FIELDS OF TABLE lt_ekpo.


  IF lt_ekpo IS NOT INITIAL.
    SELECT werks name1 FROM t001w
      INTO CORRESPONDING FIELDS OF TABLE lt_t001w
        FOR ALL ENTRIES IN lt_ekpo
          WHERE werks = lt_ekpo-werks.
  ENDIF.