JOIN

Code: Alles auswählen.

SELECT a~lifnr a~land1 b~diekz b~belnr b~zuonr b~blart b~bukrs b~monat
b~gjahr b~shkzg b~bschl b~dmbtr b~wrbtr c~hkont c~belnr c~zuonr c~blart
  c~bukrs c~monat c~gjahr c~shkzg c~bschl c~wrbtr
                         INTO CORRESPONDING FIELDS OF TABLE itab_sumla
                                FROM ( ( lfa1 AS a
                                       INNER JOIN bsak AS b
                                       ON a~lifnr = b~lifnr )
                                       INNER JOIN bsas AS c
                                       ON b~hkont = c~hkont AND
                                       b~belnr = c~belnr AND
                                       b~zuonr = c~zuonr AND
                                       b~blart = c~blart AND
                                       b~bukrs = c~bukrs AND
                                       b~monat = c~monat AND
                                       b~gjahr = c~gjahr AND
                                       b~shkzg = c~shkzg AND
                                       b~wrbtr = c~wrbtr )
                                       WHERE c~bukrs IN ('1001')
                                       AND c~blart IN ('A1', 'A2', 'A3')
                                       AND land1 IN so_land
                                       AND c~gjahr IN range
                                       AND c~zuonr IN so_dlkz
                                       AND c~monat IN so_perio.

 SELECT a~lifnr a~land1 b~diekz b~belnr b~zuonr b~blart b~bukrs b~monat
b~gjahr b~shkzg b~bschl b~dmbtr b~wrbtr c~hkont c~belnr c~zuonr c~blart
  c~bukrs c~monat c~gjahr c~shkzg c~wrbtr
                     APPENDING CORRESPONDING FIELDS OF TABLE itab_sumla
                               FROM ( ( lfa1 AS a
                                      INNER JOIN bsik AS b
                                      ON a~lifnr = b~lifnr )
                                      INNER JOIN bsis AS c
                                      ON b~hkont = c~hkont AND
                                      b~belnr = c~belnr AND
                                      b~zuonr = c~zuonr AND
                                      b~blart = c~blart AND
                                      b~bukrs = c~bukrs AND
                                      b~monat = c~monat AND
                                      b~gjahr = c~gjahr AND
                                      b~shkzg = c~shkzg AND
                                      b~wrbtr = c~wrbtr )
                                      WHERE c~bukrs IN ('1001')
                                      AND c~blart IN ('A1', 'A2', 'A3')
                                      AND land1 IN so_land
                                      AND c~gjahr IN range
                                      AND c~zuonr IN so_dlkz
                                      AND c~monat IN so_perio.