Ansicht
Dokumentation

ABENSELECT_CTE_HIERARCHY - SELECT CTE HIERARCHY

SUBST_MERGE_LIST - merge external lists to one complete list with #if... logic for R3up   ABAP Short Reference  
This documentation is copyright by SAP AG.

SELECT, FROM cte_hierarchy

... +cte_hierarchy

Effect

Specifies a CTE hierarchy +cte_hierarchy as a an SQL hierarchy hierarchy in an query of a WITH statement. A CTE hierarchy is a common table expression defined as an SQL hierarchy using the addition WITH HIERARCHY.

The rows of the tabular result set of a CTE hierarchy are the hierarchy nodes of the SQL hierarchy accessed in its subquery, including their hierarchy columns.

Note

More specifically, a CTE hierarchy can be specified as a source of the hierarchy navigators.

Example

Specification of a CTE hierarchy as a data source of a SELECT statement in the program DEMO_HIERARCHY_TREE with explicit access to the hierarchy columns. The data source of the subquery of the CTE hierarchy is a CDS hierarchy.

Example

See also the example under WITH - hierarchy.

CL_GUI_FRONTEND_SERVICES - Frontend Services   PERFORM Short Reference  
This documentation is copyright by SAP AG.

Length: 1704 Date: 20240420 Time: 123410     sap01-206 ( 24 ms )