Many times ABAP programmers deal with base tables
and nested selects. Instead it is always advisable to see whether there is any
view provided by SAP on those base tables, so that the data can be filtered out
directly, rather than specially coding for it.
Select * from zcntry where cntry like
Select single * from zflight where
cntry = zcntry-cntry and airln = ‘LF’.
Select * from zcnfl where cntry like
‘IN%’ and airln = ‘LF’.