REPORT  Z15_003  LINE-SIZE 40."       NO STANDARD PAGE HEADING  .
DATA: WA_SPFLI TYPE SPFLI,
      WA_SFLIGHT TYPE SFLIGHT.

SELECT-OPTIONS: SEL_CARR FOR WA_SPFLI-CARRID.

SELECT CARRID CONNID CITYFROM CITYTO
       FROM SPFLI
       INTO CORRESPONDING FIELDS OF WA_SPFLI
       WHERE CARRID IN SEL_CARR.

  WRITE: / WA_SPFLI-CARRID,
           WA_SPFLI-CONNID,
           WA_SPFLI-CITYFROM,
           WA_SPFLI-CITYTO.

  SELECT FLDATE
         FROM SFLIGHT
         INTO CORRESPONDING FIELDS OF WA_SFLIGHT
         WHERE CARRID = WA_SPFLI-CARRID
           AND CONNID = WA_SPFLI-CONNID.

    WRITE: / WA_SFLIGHT-FLDATE.

  ENDSELECT.

ENDSELECT.