Replacing for all entries constructwith Ranges

In this recipe, we will see how we can replace for all entries within a select statement with ranges in the where clause. The ranges maybe used to improve performance. This two-table example is just for illustrative purpose and comparison. You may apply the concepts to other tables and fields. You may or may not further refine this based on your requirement.

Getting ready...

We will create a simple program that uses the for all entries addition in the select statement for the two tables cobk and coep. We declare two internal tables t_header and t_line_items. The t_header table contains one field for the belnr document number, whereas the items table t_line_items has three fields belnr, period (period), and amount wtgbtr (amount).

We first select up to 35,000 numbers from table cobk into the internal table t_header based on the code kokrs equal to 1000. Next, the table coep is read for kokrs 1000 and for all document numbers contained in table t_header...