Ansicht
Dokumentation
ABENHIERARCHY_ATTRIBUTE_TABLE - HIERARCHY ATTRIBUTE TABLE
BAL Application Log Documentation BAL Application Log DocumentationThis documentation is copyright by SAP AG.
Name | Data Type | Meaning |
HIERARCHY_RANK | INT8 | Sequential number granted as a unique hierarchy node ID when a hierarchy is created. |
HIERARCHY_TREE_SIZE | INT8 | Number of descendant nodes of the hierarchy node, including the hierarchy node itself. |
HIERARCHY_PARENT_RANK | INT8 | 0 for root nodes, otherwise the HIERARCHY_RANK ID of the parent node. |
HIERARCHY_LEVEL | INT4 | Hierarchy level of the hierarchy node. Always 1 for root nodes. For their descendant nodes, the distance from the root node plus one. |
HIERARCHY_IS_CYCLE | INT1 | Flag indicating whether the hierarchy node is part of (1) or is not part of (0) a node cycle. |
HIERARCHY_IS_ORPHAN | INT1 | Flag indicating whether the hierarchy node is (1) or is not (0) an orphan node. |
NODE_ID | SSTRING, length 1333 | Internal character-like key of the hierarchy node that concatenates the values of all association target fields of the associated hierarchy association specified in the ON conditions. If there is only one comparison in the ON condition, no concatenation is required, and the data type is the data type of the specified field of the association target. |
PARENT_ID | SSTRING, length 1333 | Internal character-like key of the hierarchy node that concatenates the values of all association source fields of the associated hierarchy association specified in the ON conditions. If there is only one comparison in the ON condition, no concatenation is required, and the data type is the data type of the specified field of the association source. |
VALID_FROM, VALID_UNTIL \lbr | DATS, TIMESTAMP, TIMESTAMPL | These attributes exist only for temporal SQL hierarchies. They contain the limits of the validity interval of the current hierarchy node of a temporal SQL hierarchy. |