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

Other versions: 7.31 | 7.40 | 7.54


... hierarchy_node_navigator 
  | hierarchy_agg_navigator ...


Specifies a hierarchy navigator as a data source data_source in a ABAP SQL query.

A hierarchy navigator accesses a hierarchy and evaluates it. There are different kinds of hierarchy navigators:

The tabular result contains the hierarchy nodes selected by the hierarchy navigator. The columns of the tabular result include the additional hierarchy columns of the hierarchy specified after SOURCE, plus further hierarchy columns specific to the hierarchy navigators where applicable.

The same applies to the additional hierarchy columns as when accessing a hierarchy hierarchy:

  • If * or ...~* is specified in the SELECT list, they are not read and are not part of a structure or internal table created using an inline declaration @DATA(...) in the INTO clause.
  • They can, however, be specified explicitly in the SELECT list and, like any column in the results set, can be used for columns colname specified in the other clauses of the query.

A hierarchy navigator publishes all associations of the hierarchy used implicitly and leaves its target data source unchanged.


  • Hierarchy navigators do not create any hierarchies:

  • They cannot be specified as a source in hierarchy navigators.

  • On SAP HANA databases, the results sets of the hierarchy navigators are based on the use of the identically named hierarchy navigation functions. More information can be found in the documentation.


SELECT - FROM hierarchy_node_navigator

SELECT - FROM hierarchy_aggregate_navigator