Question { Patni, 58935 }

In ABAP What is the Use of "FOR ALL ENTRIES" Clause & when
it is being used. And what it really does?

Answer

In order to avoid nested select statements we can go
for "FOR ALL ENTRIES".First fetch values from database
table to internal table and only for the values in the
internal table we can fetch values from other database
table based on conditions in the where clause.

it is mandetory that we have to declare allthe primary keys
in either select Stmt or in where condition. orelse
duplicate records will not get selected.