_HIERNODE

8 Fields

_HIERNODE is an SAP database table in S/4HANA. It contains 8 fields.

Fields (8)

KeyField CDS FieldsUsed in Views
KEY HierarchyNode HierarchyNode 2
KEY ValidityEndDate ValidityEndDate 2
HierarchyNodeLevel HierarchyNodeLevel 2
HierarchyNodeSequence HierarchyNodeSequence 2
HierarchyVersion HierarchyVersion 1
NodeType NodeType 2
ParentNode ParentNode 2
ValidityStartDate ValidityStartDate 2

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE _HIERNODE (
    HIERARCHYNODE,
    VALIDITYENDDATE,
    HIERARCHYNODELEVEL,
    HIERARCHYNODESEQUENCE,
    HIERARCHYVERSION,
    NODETYPE,
    PARENTNODE,
    VALIDITYSTARTDATE,
    PRIMARY KEY (HIERARCHYNODE, VALIDITYENDDATE)
);

Learn More