Ansicht
Dokumentation

ABENSELECT_CDS_HIERARCHY - SELECT CDS HIERARCHY

SELECT, FROM cds_hierarchy

... cds_hierarchy$[sql_para$] ...

Effect

Specifies a CDS hierarchy cds_hierarchy as an SQL hierarchy hierarchy in an query. The CDS hierarchy is specified using its name cds_hierarchy defined after DEFINE HIERARCHY. If the CDS hierarchy has input parameters, actual parameters must be assigned to these in a parenthesized list sql_para.

The rows of the tabular result set of a CDS hierarchy specified as a data source are the hierarchy nodes of the SQL hierarchy and their columns are composed of the elements of the CDS hierarchy and the additional hierarchy columns that can be used to access the hierarchy attributes of the data source of the CDS hierarchy.

Note

When a CDS hierarchy is accessed, the hierarchy columns are read regardless of whether hierarchy attributes are listed in the element list. If a hierarchy attribute is defined as an explicit element of the CDS hierarchy, it is possible to access both the element and the additional hierarchy column in .

Example

Specifies a CDS hierarchy DEMO_CDS_SIMPLE_TREE as a data source of a SELECT statement in the program DEMO_HIERARCHY_TREE with parameter passing and explicit access to the hierarchy columns.