SAP SELECT HIERARCHY AGG NAVIS

Get Example source ABAP code based on a different SAP table

SELECT, FROM hierarchy_aggregate_navigator

ABAP_SYNTAX
... HIERARCHY_DESCENDANTS_AGGREGATE( ... )
$| HIERARCHY_ANCESTORS_AGGREGATE( ... ) ...

What does it do?
Specifies a hierarchy aggregate navigator as a data source data_source in an AB_SQL query. A hierarchy aggregate navigator accesses an SQL hierarchy and uses aggregate functions to evaluate it. The following hierarchy aggregate navigators are available:

HIERARCHY_DESCENDANTS_AGGREGATE

HIERARCHY_ANCESTORS_AGGREGATE