REPORT  Z04_014.

DATA t_spfli type table of spfli.

DATA t_sflight type table of sflight.

DATA sflight_wa type sflight.

SELECT * FROM spfli

INTO TABLE t_spfli.

SELECT * FROM sflight AS f

           INTO CORRESPONDING FIELDS OF

                     TABLE t_sflight

           FOR ALL ENTRIES IN t_spfli

           WHERE carrid = t_spfli-carrid

           AND connid = t_spfli-connid.

LOOP AT t_sflight INTO sflight_wa.

           WRITE / sflight_wa-carrid.

ENDLOOP.