REPORT  Z04_011

DATA: carr_id TYPE spfli-carrid VALUE 'AA',

           conn_id TYPE spfli-connid VALUE '0400'.

SELECT SINGLE carrid connid

           INTO (carr_id , conn_id)

           FROM  sflight

           WHERE carrid IN ( SELECT  carrid

                                FROM  spfli

                                WHERE carrid = carr_id

AND        connid = conn_id      ).