Skip to content

ABAP Keyword Documentation →  ABAP − Reference →  Processing External Data →  ABAP Database Access →  ABAP SQL →  ABAP SQL - Reads →  SELECT clauses →  SELECT - FROM →  SELECT - FROM data_source →  SELECT - FROM hierarchy_data →  SELECT - FROM hierarchy_navigator 

SELECT - FROM hierarchy_aggregate_navigator

Other versions: 7.31 | 7.40 | 7.54

Syntax


... HIERARCHY_DESCENDANTS_AGGREGATE( ... ) 
  | HIERARCHY_ANCESTORS_AGGREGATE( ... ) ...

Effect

Specifies a hierarchy aggregate navigator as a data source data_source in a ABAP SQL query. A hierarchy aggregate navigator accesses a hierarchy and uses aggregate functions to evaluate it. The following hierarchy aggregate navigators are available:

Continue

SELECT - FROM HIERARCHY_DESCENDANTS_AGGREGATE

SELECT - FROM HIERARCHY_ANCESTORS_AGGREGATE