How To Use "For All Entries In Itab"
How To Use "For All Entries In Itab"
- Usually use for Sql Select Statement,it is for search condition in a list or a internal table.
For Instance:
-Internal Table: ITAB_A
Carrid Connid
LH 2415
SQ 0026
LH 0400
-Sql Section
Select * from sfligh into wa-sfligh
For All Entries In ITAB_A
where Carrid = ITAB_A-Carrid
and Connid = ITAB_A-Connid
and Fldate = '20010228'
.....
EndSelect.
-The Statement has the same effect as:
Select Distinct * from sflight into wa-sfligh
where Carrid = 'LH'
And Connid ='2415'
And fldate = '20010228' or
( Carrid = 'SQ'
And Connid ='0026'
And fldate = '20010228') Or
(Carrid = 'LH'
And Connid ='0400'
And fldate = '20010228')
...
EndSelect.