Ansicht
Dokumentation

ABENSELECT_HIERARCHY_DATA - SELECT HIERARCHY DATA

ROGBILLS - Synchronize billing plans   RFUMSV00 - Advance Return for Tax on Sales/Purchases  
This documentation is copyright by SAP AG.

SELECT, FROM hierarchy_data

... hierarchy
  $| hierarchy_navigator ...

Effect

Specifies hierarchy data as a data source data_source in an query. Possible hierarchy data is:

• An SQL hierarchy hierarchy

• A hierarchy navigator hierarchy_navigator that accesses an SQL hierarchy.

Access to hierarchy data is not supported by all databases.

Notes

• Hierarchy data sources are handled like any other data source. They can have alias names defined using AS and can be used in join expressions. There are no restrictions on which queries they can be used in.

• In an ABAP program, it is possible to use the method USE_FEATURES of the class CL_ABAP_DBFEATURES to check whether the current database system or a database system accessed using a secondary connection supports access to hierarchy data. This requires the constant HIERARCHIES of this class to be passed to the method in an internal table.

• Accessing hierarchy data enforces the strict mode from Release .

Example

Access to the hierarchy navigator HIERARCHY_SIBLINGS as the data source of a query. The hierarchy navigator uses a CDS hierarchy as a source.

PERFORM Short Reference   Vendor Master (General Section)  
This documentation is copyright by SAP AG.

Length: 2581 Date: 20240426 Time: 045344     sap01-206 ( 35 ms )