December 2012
Intermediate to advanced
316 pages
6h 51m
English
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.
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), ...
Read now
Unlock full access