Selection-Screens mit Daten aus vielen vers. Tabellen

Code: Alles auswählen.

SELECTION-SCREEN: BEGIN OF BLOCK param WITH FRAME TITLE text-001.
  SELECT-OPTIONS: s_ekorg FOR ekko-ekorg,         " Einkaufsorganisation
                  s_werks FOR ekpo-werks.         " Werk
  SELECTION-SCREEN SKIP.
  SELECT-OPTIONS: s_bedat FOR ekko-bedat,         " Belegdatum
                  s_bsart FOR ekko-bsart,         " Belegart
                  s_ebeln FOR ekpo-ebeln.         " Einkaufsbeleg
  SELECTION-SCREEN SKIP.
  SELECT-OPTIONS: s_vbeln FOR vbak-vbeln,         " Vertriebsbeleg
                  s_bednr FOR ekpo-bednr.         " Bedarfsnummer
  SELECTION-SCREEN SKIP.
  SELECT-OPTIONS: s_lifnr FOR ekko-lifnr,         " Lieferant
                  s_idnlf FOR ekpo-idnlf,         " Lieferanten-Materialnummer
                  s_lbeln FOR likp-vbeln,         " Lieferungsnummer
                  s_wadat FOR likp-wadat.         " Planwarenausgang (Lieferdatum)
  SELECTION-SCREEN SKIP.
  SELECT-OPTIONS: s_matnr FOR ekpo-matnr,         " Material
                  s_matkl FOR ekpo-matkl.         " Warengruppe
  SELECTION-SCREEN: END OF BLOCK param.

Code: Alles auswählen.

SELECT b~ebeln b~ebelp b~elikz b~loekz b~wepos b~aedat b~menge b~matnr b~txz01 b~werks b~zzkommission b~bednr b~banfn b~bnfpo b~ean11 b~ntgew b~brgew b~volum
    INTO CORRESPONDING FIELDS OF TABLE gt_outtab
    FROM ekko AS a
    INNER JOIN ekpo AS b ON b~ebeln = a~ebeln
  WHERE a~lifnr IN s_lifnr
    AND b~idnlf IN s_idnlf
    AND a~ekorg IN s_ekorg
    AND b~werks IN s_werks
    AND a~bedat IN s_bedat
    AND a~bsart IN s_bsart
    AND b~ebeln IN s_ebeln
    AND b~bednr IN s_bednr
    AND b~matnr IN s_matnr
    AND b~matkl IN s_matkl
  ORDER BY b~ebeln b~ebelp b~matnr b~werks b~zzkommission b~bednr b~banfn b~bnfpo.