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), ...
Get SAP ABAP Advanced Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.