Question { Wipro, 27077 }
what is the use of FOR ALL ENTRIES in an internal table?
Answer
Actually It is used instead of inner join because when we want to join morn than 3 tables using inner join it will put a heavy load on the database server. instead of taking heavy load on DB server we will use for all entries ...
USED to retrieve the matched Records from the Different DB Tables..
Syntax :
select * from DBTABLE1 into table ITAB1
if itab1 is not initial
select * from DBTABLE2 into table itab2
where condition.