REPORT  Z09_005.

DATA: TAB_SPFLI   TYPE ztabletype,
      WA LIKE LINE OF TAB_SPFLI.

SELECT CARRID CONNID
INTO   CORRESPONDING FIELDS OF TABLE TAB_SPFLI
FROM   SPFLI  WHERE  CITYFROM  = 'NEW YORK'.

LOOP AT TAB_SPFLI INTO WA.
  AT NEW CONNID.      WRITE: / WA-CARRID, WA-CONNID.    ENDAT.
  WRITE: / WA-FLDATE.
ENDLOOP.