_HIERARCHYNODE

17 Fields

_HIERARCHYNODE is an SAP database table in S/4HANA. It contains 17 fields.

Fields (17)

KeyField CDS FieldsUsed in Views
KEY ConsolidationChartOfAccounts ConsolidationChartOfAccounts 1
KEY ControllingArea ControllingArea 1
KEY HierarchyNode HierarchyNode 19
KEY UniversalHierHierarchyID AdditionalMasterDataHierarchy,ConsolidationSupplierHierarchy 3
KEY ValidityEndDate ValidityEndDate 20
CITClassificationCodeDesc CITClassificationCodeDesc 1
CnsldtnFinancialStatementItem CnsldtnFinancialStatementItem 1
CostCenter CostCenter 1
HierarchyNodeLevel HierarchyNodeLevel 19
HierarchyNodeSequence HierarchyNodeSequence 19
HierarchyType HierarchyType 1
HierarchyVersion HierarchyVersion 14
LastChangeDateTime LastChangeDateTime,LastChangeTime 1
NodeType NodeType 21
ParentNode ParentNode 19
SignIsInverted SignIsInverted 1
ValidityStartDate ValidityStartDate 20

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 _HIERARCHYNODE (
    CONSOLIDATIONCHARTOFACCOUNTS,
    CONTROLLINGAREA,
    HIERARCHYNODE,
    UNIVERSALHIERHIERARCHYID,
    VALIDITYENDDATE,
    CITCLASSIFICATIONCODEDESC,
    CNSLDTNFINANCIALSTATEMENTITEM,
    COSTCENTER,
    HIERARCHYNODELEVEL,
    HIERARCHYNODESEQUENCE,
    HIERARCHYTYPE,
    HIERARCHYVERSION,
    LASTCHANGEDATETIME,
    NODETYPE,
    PARENTNODE,
    SIGNISINVERTED,
    VALIDITYSTARTDATE,
    PRIMARY KEY (CONSOLIDATIONCHARTOFACCOUNTS, CONTROLLINGAREA, HIERARCHYNODE, UNIVERSALHIERHIERARCHYID, VALIDITYENDDATE)
);

Learn More