HIERARCHYSUBTREE

10 Fields

HIERARCHYSUBTREE is an SAP database table in S/4HANA. It contains 10 fields.

Fields (10)

KeyField CDS FieldsUsed in Views
KEY FinancialStatementHierarchy FinancialStatementHierarchy 1
KEY HierarchyNode HierarchyNode 1
KEY ValidityEndDate ValidityEndDate 1
FinancialStatementNodeType FinancialStatementNodeType 1
GLAcctHierarchyNodeCategory GLAcctHierarchyNodeCategory 1
HierarchyLevel HierarchyLevel 1
HierarchyNodeSequence HierarchyNodeSequence 1
HierarchyNodeText HierarchyNodeText 1
NodeType NodeType 1
ParentNode ParentNode 1

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 HIERARCHYSUBTREE (
    FINANCIALSTATEMENTHIERARCHY,
    HIERARCHYNODE,
    VALIDITYENDDATE,
    FINANCIALSTATEMENTNODETYPE,
    GLACCTHIERARCHYNODECATEGORY,
    HIERARCHYLEVEL,
    HIERARCHYNODESEQUENCE,
    HIERARCHYNODETEXT,
    NODETYPE,
    PARENTNODE,
    PRIMARY KEY (FINANCIALSTATEMENTHIERARCHY, HIERARCHYNODE, VALIDITYENDDATE)
);

Learn More