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

Answer Posted / raghunath

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.

Is This Answer Correct ?    78 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the different message types available in the abap/4 ?

555


Can we call reports and transactions from interactive reporting lists?

628


How many main windows are allowed in sapscript?

582


Difference between sy-tabix and sy-index? Where it is used? Can you check sy-subarc after perform?

593


What is the difference between ABAP and HR ABAP

2989






Difference between transparent tables and pooled tables? : abap hr

557


What is tmg?

693


Polymorphism real time scenario

1048


What are the requirements a dialog program must fulfill?

639


Did you create primary index?

546


What are the types of windows in sap script?

609


Explain the Inportance of pa40? : abap hr

582


What is the Difference between At Line selection and At user-command?

650


What is view? Different types of view.

588


How can you manipulate the presentation and attributes of interactive lists?

617