NODE

25 Fields

NODE is an SAP database table in S/4HANA. It contains 25 fields.

Fields (25)

KeyField CDS FieldsUsed in Views
KEY FinancialStatementItem FinancialStatementItem 1
KEY FinancialStatementVariant FinancialStatementVariant 1
KEY FinStmntFormStruc FinStmntFormStruc 1
KEY FinStmntFormStrucLineNmbr FinStmntFormStrucLineNmbr 1
KEY node_id NodeID 2
KEY nodecls nodecls 1
KEY nodevalue ProductHierarchyNode 1
FinStmntFormStrucItemFactor FinStmntFormStrucItemFactor 1
FinStmntFormStrucItemSign FinStmntFormStrucItemSign 1
HierarchyID hierarchy 2
HierarchyNode node 2
HierarchyNodeClass ChartOfAccounts 1
HierarchyNodeLevel NodeLevel 2
HierarchyNodeVal glaccount,GLAccountExternal,NodeValue 4
HierarchyVersion hryver 2
hryid BudgetAccountHierarchy,CostCenterHierarchy,FunctionalAreaHierarchy,FundHierarchy,WBSElementHierarchy 5
hrylevel HierarchyNodeLevel 5
hrynode BudgetAccountHierarchyNode,CostCenterHierarchyNode,FunctionalAreaHierarchyNode,FundHierarchyNode,WBSElementHierarchyNode 5
node_name_raw SAPObjectType 1
nodetype NodeType 5
object_type_code ObjectTypeCode 1
ParentNode ParentNode 1
parnode BudgetAccountParentNode,CostCenterParentNode,FunctionalAreaParentNode,FundParentNode,WBSElementParentNode 5
ValidityEndDate EndDate 1
ValidityStartDate StartDate 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 NODE (
    FINANCIALSTATEMENTITEM,
    FINANCIALSTATEMENTVARIANT,
    FINSTMNTFORMSTRUC,
    FINSTMNTFORMSTRUCLINENMBR,
    NODE_ID,
    NODECLS,
    NODEVALUE,
    FINSTMNTFORMSTRUCITEMFACTOR,
    FINSTMNTFORMSTRUCITEMSIGN,
    HIERARCHYID,
    HIERARCHYNODE,
    HIERARCHYNODECLASS,
    HIERARCHYNODELEVEL,
    HIERARCHYNODEVAL,
    HIERARCHYVERSION,
    HRYID,
    HRYLEVEL,
    HRYNODE,
    NODE_NAME_RAW,
    NODETYPE,
    OBJECT_TYPE_CODE,
    PARENTNODE,
    PARNODE,
    VALIDITYENDDATE,
    VALIDITYSTARTDATE,
    PRIMARY KEY (FINANCIALSTATEMENTITEM, FINANCIALSTATEMENTVARIANT, FINSTMNTFORMSTRUC, FINSTMNTFORMSTRUCLINENMBR, NODE_ID, NODECLS, NODEVALUE)
);

Learn More