REPORT  Z04_012

DATA: name_tab TYPE TABLE OF scarr-carrname,

           name LIKE LINE OF name_tab.

SELECT  carrname

           INTO  TABLE name_tab

           FROM  scarr

           WHERE EXISTS ( select  *

                                FROM  spfli

                                WHERE carrid   =  scarr~carrid AND

                                          cityfrom = ‘SEOUL‘        ).

LOOP AT name_tab INTO name.

           WRITE: / name.

ENDLOOP.