Ansicht
Dokumentation

ABENHIER_DESC_AGG_ABEXA - HIER DESC AGG ABEXA

SELECT, Hierarchy Navigator HIERARCHY_DESCENDANTS_AGGREGATE

This example demonstrates the hierarchy navigator HIERARCHY_DESCENDANTS_AGGREGATE with the addition JOIN.

Source Code

Execute

Description

Calls of the hierarchy navigator HIERARCHY_DESCENDANTS_AGGREGATE where the CDS hierarchy DEMO_CDS_PARENT_CHILD specified as a source is joined with a DDIC database table DEMO_CHILD_NUM and an internal table @itab using the addition JOIN. The aggregate functions evaluate the column NUM of the joined data sources. The results of the join expressions used are also displayed.

• In the first part, the table DEMO_CHILD_NUM is filled to produce a 1:1 relationship between the rows of the hierarchy and its own rows. The result of the hierarchy navigator is the same as in the executable example DEMO_HIERARCHY_AGGREGATE, but here the number values are taken from the joined table.

• In the second part, the internal table @itab contains the rows of the DDIC database table DEMO_CHILD_NUM and further rows that also match the criteria for descendant nodes for nodes of the hierarchy. This example shows how these additional rows, produced in the result set of the join, are evaluated in the aggregate functions.

The statement ASSERT shows that the use of the hierarchy generator HIERARCHY and a semantically identical CDS hierarchy as the source of the hierarchy navigator produces the same results.