Ansicht
Dokumentation
ABENSELECT_HIERARCHY_NAVIGATORS - SELECT HIERARCHY NAVIGATORS
ABAP Short Reference BAL_S_LOG - Application Log: Log header dataThis documentation is copyright by SAP AG.
SELECT, FROM hierarchy_navigator
... hierarchy_node_navigator
$| hierarchy_agg_navigator ...
Effect
Specifies a hierarchy navigator as a data source data_source in an query.
A hierarchy navigator accesses a SQL hierarchy and evaluates it. There are different kinds of hierarchy navigators:
- Hierarchy node navigators hierarchy_node_navigator select certain hierarchy nodes and their properties.
- Hierarchy aggregate navigators hierarchy_agg_navigator select 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 SQL hierarchy specified after SOURCE, as well as any other hierarchy columns that are specific to the hierarchy navigators where applicable.
The same applies to the additional hierarchy columns as when accessing a SQL 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$|@FINAL(...) in the INTO clause.
- They can, however, be listed explicitly in the SELECT list and, like any column in the result set, can be used for columns colname specified in the other clauses of the query.
A hierarchy navigator exposes all associations of the SQL hierarchy used implicitly and leaves its association target unchanged.
Notes
- Hierarchy navigators do not create any SQL hierarchies:
- They cannot be specified as a source in hierarchy navigators.
- They cannot be exposed as a CTE hierarchy.
- On SAP HANA databases, the result sets of the hierarchy navigators are based on the use of the identically named hierarchy navigation functions. For more information, see the SAP HANA documentation.
- Since hierarchies generated from the START WHERE condition are buffered on the database, it is advisable to use hierarchy navigators to evaluate a SQL hierarchy. For example, finding the descendant nodes of a node with the hierarchy node navigator HIERARCHY_DESCENDANTS is more efficient than generating a new SQL hierarchy with this node as a root node. Furthermore, the hierarchy navigators add hierarchy columns that are not readily available otherwise.
CPI1466 during Backup SUBST_MERGE_LIST - merge external lists to one complete list with #if... logic for R3up
This documentation is copyright by SAP AG.
Length: 4726 Date: 20240329 Time: 131942 sap01-206 ( 88 ms )