R_HIERRUNTIMERPRSTNNODE

CDS View
13 Fields 7 CDS Views

Hierarchy Node

R_HIERRUNTIMERPRSTNNODE is a CDS View in S/4HANA. Hierarchy Node. It contains 13 fields. 7 CDS views read from this table.

CDS Views using this table (7)

ViewTypeJoinVDMDescription
I_FinSrvcsProdGrpHierNode view_entity from COMPOSITE Fin Srvcs Product Group Hierarchy Node
I_FinStmntExpandedHierNode view left_outer COMPOSITE Financial Statement Expanded Hier Node
P_CN_FinancialStatementItem view from CONSUMPTION Items in Financial Statement Version
P_CN_FsvHierInCoa view from CONSUMPTION FSV based on chart of accounts
P_CN_FsvHierInCoa view inner CONSUMPTION FSV based on chart of accounts
R_HierRuntimeRprstnInnerNode view_entity from BASIC Hierarchy Inner Node
SHIDCN_FinStmntHierarchyQT view from Statement Items Text in Structure

Fields (13)

KeyField CDS FieldsUsed in Views
KEY HierarchyID FinancialStatementHierarchy,FINANCIALSTATEMENTVARIANT 3
KEY HierarchyNode HierarchyNode,hrynode 3
KEY HierarchyVersion HierarchyVersion 1
KEY ParentNode ParentNode,parnode 3
KEY ValidityEndDate ValidityEndDate 4
DebitCreditCode DebitCreditCode 1
FinancialServicesProductGroup FinancialServicesProductGroup 1
HierarchyNodeClass ChartOfAccounts,HierarchyNodeClass 2
HierarchyNodeLevel HierarchyNodeLevel 2
HierarchyNodeVal FinStatementHierarchyNodeValue,HierarchyNodeVal 3
NodeType NodeType 3
SequenceNumber HierarchyNodeSequence,SequenceNumber 2
ValidityStartDate ValidityStartDate 4

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.

-- Hierarchy Node
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE R_HIERRUNTIMERPRSTNNODE (
    HIERARCHYID,
    HIERARCHYNODE,
    HIERARCHYVERSION,
    PARENTNODE,
    VALIDITYENDDATE,
    DEBITCREDITCODE,
    FINANCIALSERVICESPRODUCTGROUP,
    HIERARCHYNODECLASS,
    HIERARCHYNODELEVEL,
    HIERARCHYNODEVAL,
    NODETYPE,
    SEQUENCENUMBER,
    VALIDITYSTARTDATE,
    PRIMARY KEY (HIERARCHYID, HIERARCHYNODE, HIERARCHYVERSION, PARENTNODE, VALIDITYENDDATE)
);

Learn More