Stehe gerade bei meinem Select auf der Leitung ...

Code: Alles auswählen.

START-OF-SELECTION.
*##################

* GUI-Titel anlegen

  SET TITLEBAR 'T_SOHA'.

  SELECT zdlkz bezeichnung
  FROM zdlkz_t INTO CORRESPONDING FIELDS OF TABLE itab_zdlkz_t
  WHERE zdlkz IN so_dlkz.

  IF sy-subrc <> 0.
    MESSAGE i003(/sapdmc/lsmw_glo_030).
*   Bitte tragen Sie einen gültigen Wert ein.
    EXIT.
  ENDIF.


 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 b~hkont
                       INTO CORRESPONDING FIELDS OF TABLE itab_sumla
                             FROM ( lfa1 AS a
                                      INNER JOIN bsak AS b
                                      ON a~lifnr = b~lifnr )
                                      WHERE bukrs IN ('1001')
                                      AND blart IN ('A1', 'A2', 'A3')
                                      AND land1 IN so_land
                                      AND gjahr IN range
                                      AND zuonr IN so_dlkz
                                      AND 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 b~hkont
                     APPENDING CORRESPONDING FIELDS OF TABLE itab_sumla
                            FROM ( lfa1 AS a
                                     INNER JOIN bsik AS b
                                     ON a~lifnr = b~lifnr )
                                     WHERE bukrs IN ('1001')
                                     AND blart IN ('A1', 'A2', 'A3')
                                     AND land1 IN so_land
                                     AND gjahr IN range
                                     AND zuonr IN so_dlkz
                                     AND monat IN so_perio.

 SELECT bukrs hkont zuonr gjahr belnr blart monat bschl shkzg wrbtr
 APPENDING CORRESPONDING FIELDS OF TABLE itab_sumla
 FROM bsas
 WHERE bukrs IN ('1001')
 AND blart IN ('A1', 'A2', 'A3')
 AND gjahr IN range
 AND zuonr IN so_dlkz
 AND monat IN so_perio.

 SELECT bukrs hkont zuonr gjahr belnr blart monat bschl shkzg wrbtr
 APPENDING CORRESPONDING FIELDS OF TABLE itab_sumla
 FROM bsis
 WHERE bukrs IN ('1001')
 AND blart IN ('A1', 'A2', 'A3')
 AND gjahr IN range
 AND zuonr IN so_dlkz
 AND monat IN so_perio.

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 b~hkont
                         INTO CORRESPONDING FIELDS OF TABLE itab_sumla
                               FROM ( lfa1 AS a
                                        INNER JOIN bsak AS b
                                        ON a~lifnr = b~lifnr )
                                        WHERE bukrs IN ('1001')
                                        AND blart IN ('A1', 'A2', 'A3')
                                        AND land1 IN so_land
                                        AND gjahr IN range
                                        AND zuonr IN so_dlkz
                                        AND 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 b~hkont
                     APPENDING CORRESPONDING FIELDS OF TABLE itab_sumla
                              FROM ( lfa1 AS a
                                       INNER JOIN bsik AS b
                                       ON a~lifnr = b~lifnr )
                                       WHERE bukrs IN ('1001')
                                       AND blart IN ('A1', 'A2', 'A3')
                                       AND land1 IN so_land
                                       AND gjahr IN range
                                       AND zuonr IN so_dlkz
                                       AND monat IN so_perio.

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

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