Search This Blog

Wednesday, March 23, 2005

For all entries

When using for all entries in a select statement with an empty internal table, not only does it get all entries for the selected where clause for the desired field in the for all entries table, it IGNORES the rest of the WHERE clause, meaning it will retrieve every single entry in the SELECT FROM table. Usually, this is not encountered because you should always check for an empty table prior to doing a FOR ALL ENTRIES select, but if you wanted to use the other conditions in the where clause you will not be able to. Pretty stupid on SAP's part.

No comments: