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

PRO+

Content

Find more PRO+ content and other member only offers, here.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

-ADS BY GOOGLE

SearchManufacturingERP

SearchOracle

SearchDataManagement

SearchAWS

SearchBusinessAnalytics

SearchCRM

SearchContentManagement

SearchFinancialApplications

Close