REPORT  Z04_005                                                     .
DATA: TAB_SPFLI   TYPE TABLE OF SPFLI,        TAB_SFLIGHT TYPE SORTED
TABLE OF SFLIGHT                         WITH UNIQUE KEY TABLE LINE,
    WA LIKE LINE OF TAB_SFLIGHT.
SELECT CARRID CONNID  INTO   CORRESPONDING FIELDS OF TABLE TAB_SPFLI
FROM   SPFLI  WHERE  CITYFROM  = 'NEW YORK'.
SELECT CARRID CONNID FLDATE  INTO   CORRESPONDING FIELDS OF TABLE
TAB_SFLIGHT  FROM   SFLIGHT  FOR ALL ENTRIES IN TAB_SPFLI  WHERE  CARRID
= TAB_SPFLI-CARRID AND         CONNID = TAB_SPFLI-CONNID.
LOOP AT TAB_SFLIGHT INTO WA.
  AT NEW CONNID.      WRITE: / WA-CARRID, WA-CONNID.    ENDAT.
  WRITE: / WA-FLDATE.
ENDLOOP.