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
Syntax
... hierarchy_node_navigator
| hierarchy_agg_navigator ...
Effect
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:
- Hierarchy node
navigators
hierarchy_node_navigatorselect certain hierarchy nodes and their properties.
- Hierarchy aggregate
navigators
hierarchy_agg_navigatorselect certain hierarchy nodes and apply additional aggregate functions to them.
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 theSELECTlist, they are not read and are not part of a structure or internal table created using an inline declaration@DATA(...)in theINTOclause.
- They can, however, be specified explicitly in the
SELECTlist and, like any column in the results set, can be used for columnscolnamespecified 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.
Notes
- Hierarchy navigators do not create any hierarchies:
- They cannot be specified as a source in hierarchy navigators.
- They cannot be published as a CTE hierarchy.
- 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.