*&---------------------------------------------------------------------*
*& Report  Z01_021                                                     *
*&                                                                     *
*&---------------------------------------------------------------------*
*&                                                                     *
*&                                                                     *
*&---------------------------------------------------------------------*

REPORT  z01_021                                                     .
TYPES: city       TYPE spfli-cityfrom,
       spfli_type TYPE STANDARD TABLE OF spfli WITH DEFAULT KEY.

DATA: wa_city  TYPE city,
      ta_spfli TYPE spfli_type,
      wa_spfli LIKE spfli.


SELECT * FROM spfli
INTO CORRESPONDING FIELDS OF TABLE ta_spfli
WHERE carrid = 'LH'.

LOOP AT ta_spfli INTO wa_spfli.

  WRITE : / wa_spfli-connid.

  wa_city = wa_spfli-cityfrom.
  WRITE : / wa_city.
ENDLOOP.