Video Lesson 5.7: For All Entries in ABAP

This lesson will teach you about the FOR ALL ENTRIES ABAP statement that is used to extract information from one table using the information of another table.

• The 'FOR ALL ENTRIES' statement allows you to build an internal table and then restrict the database select to only get entries contained in it.
• In order to avoid nested select statements using the JOIN statement, we can go  for "FOR ALL ENTRIES".

1. Duplicate rows are automatically removed

2. If the internal table used in the clause is empty , all the rows in
the source table will be selected . In that case, always check if it is not empty before executing the statement.

3. The fields use in the FOR ALL ENTRIES must match the types of the fields of the database tables.