Problem solve Get help with specific problems with your technologies, process and projects.

Select with 'FOR ALL ENTRIES IN' (FAEI)

Beware when using 'FOR ALL ENTRIES' in select statement.

Beware when using 'FOR ALL ENTRIES' in select statement. Although this addition to the select statement is an efficient...

way to fetch distinct records from DB table, follow the below steps to ensure data consistency and efficiency.

1. Sort the Internal table used in the 'FOR ALL ENTRIES IN' clause.
2. make sure they do not contain duplicates.
3. last and most importantly include a primary key field(Unique entry) 
in the select list. The reason, the system gets unique field records based
on the where condition. It summarizes the data based on the Data type and
field list in the target internal table.

This was last published in April 2002

Dig Deeper on SAP ABAP

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchERP

SearchOracle

SearchDataManagement

SearchAWS

SearchBusinessAnalytics

SearchCRM

SearchContentManagement

SearchHRSoftware

Close