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

How can we send data to external programs?

608


What is the meaning of abap/4 editor integrated with abap/4 data dictionary?

623


How do you document ABAP programs? Do you use program documentation menu option?

634


What are data classes? What are the various data classes available for selection? : abap data dictionary

542


What are the types of search helps? : sap abap data dictionary

630






What is an interactive report?

610


Name a few data dictionary objects?

633


I need the coding for BDC program to upload Purchase orders of known vendor (ME21) in Material Management

1749


How to find Kernal badi ?

1146


What are logical databases? What are the advantages of logical databases?

508


What is table attribute? : abap data dictionary

560


Where are you used type casting?

897


Is sap xi intended to replace ale?

568


What are the differences between macro and subroutine?

608


In select-options, how to get the default values as current month first date and last date by default?

619