Daten auslesen und verarbeiten * Select

Code: Alles auswählen.

PARAMETERS: p_cityfr TYPE spfli-cityfrom, 
            p_cityto TYPE spfli-cityto. 

DATA: BEGIN OF wa, 
         fldate TYPE sflight-fldate, 
         carrname TYPE scarr-carrname, 
         connid   TYPE spfli-connid, 
       END OF wa. 

DATA itab LIKE SORTED TABLE OF wa 
               WITH UNIQUE KEY fldate carrname connid. 

SELECT c~carrname p~connid f~fldate 
       INTO CORRESPONDING FIELDS OF TABLE itab 
       FROM ( ( scarr AS c 
         INNER JOIN spfli AS p ON p~carrid   = c~carrid 
                              AND p~cityfrom = p_cityfr 
                              AND p~cityto   = p_cityto ) 
         INNER JOIN sflight AS f ON f~carrid = p~carrid 
                                AND f~connid = p~connid ). 

LOOP AT itab INTO wa. 
  WRITE: / wa-fldate, wa-carrname, wa-connid. 
ENDLOOP. 

Code: Alles auswählen.

SELECT c~felda p~feldb f~feldc 
       INTO CORRESPONDING FIELDS OF TABLE itab 
       FROM ( ( z902f AS c 
         INNER JOIN z902b AS p ON p~abtei  = c~abtei 
                              AND p~waogr = c~waogr 
                              AND p~gjahr  = c~gjahr ) 
         INNER JOIN z9dbr AS f ON f~abtei = c~abtei 
                                AND f~waogr = c~waogr).