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.
Not recommended
Select * from zcntry where cntry like
�IN%�.
Select single * from zflight where
cntry = zcntry-cntry and airln = �LF�.
Endselect.
Recommended
Select * from zcnfl where cntry like
�IN%� and airln = �LF�.
