SAP SELECT HIERARCHY ABEXA

Get Example source ABAP code based on a different SAP table

SELECT, Hierarchy Generator, BULK vs. INCREMENTAL
This example demonstrates how the addition LOAD INCREMENTAL can speed up the generation of a hierarchy.

ABAP_SOURCE_CODE
DEMO CL_DEMO_HRRCHY_BULK_INCREMENT

ABAP_DESCRIPTION
The table DEMO_GUID_HIERA serves as data source for a hierarchy. The user can enter how many rows in total are inserted, and how many of them are part of the hierarchy. Then, the table is filled with GUIDs and the rows that build a hierarchy tree are chosen randomly.
Based on this table, a hierarchy is generated, once with the addition LOAD BULK and once with LOAD INCREMENTAL. The time of hierarchy generation, which is done in DO-loops with 10 repetitions, is measured and compared.
When using the default values for the formal parameters, LOAD INCREMENTAL is many times faster than LOAD BULK. This positive effect is minimized when the total number of rows is decreased and the number of rows that are part of the hierarchy is increased.