HRRP_NODE_N

Transparent Table Application Table
17 Fields 58 CDS Views

Hierarchy Node (New Design)

HRRP_NODE_N is an SAP database table in S/4HANA. Hierarchy Node (New Design). It contains 17 fields. 58 CDS views read from this table.

CDS Views using this table (58)

ViewTypeJoinVDMDescription
fac_cds_fh_node view from Flexible Hierarchy Node
FAC_CDS_SH_ACTIVE_FSV view inner Active Financial Statement Versions
FAC_CDS_UH_REUSE_FH_NODE_CC view from Flexible Cost Center Hierarchy Node
FAC_CDS_UH_REUSE_FH_NODE_COCD view from Flexible Company Code Hierarchy Node
FAC_CDS_UH_REUSE_FH_NODE_PC view from Flexible Profit Center Hierarchy Node
FAC_CostCenterHierNode view from Cost Center Hierarchy Node
FAC_DART_Z3_FSV_Node view from Financial Statement Hierarchy Node
FAC_DART_Z3_FSV_Node view left_outer Financial Statement Hierarchy Node
FAC_GLACCOUNTHIERNODE view from GL Account Hierarchy Node
FIN_SEL_HIER_LEAF_NODE view from
FIN_SEL_HIER_NODE view from
FIN_SEL_HIER_NODE_TEXT view inner
I_BudgetPeriodHierarchyNode view from BASIC Budget Period Hierarchy Node
I_BusinessAreaHierNode view from BASIC BusinessArea Hier Node
I_BusTransacTypeHierNode view from BASIC Business Transaction Type Hier Node
I_CnsldtnNodeForElimRptgDEX view_entity from BASIC Cnsldtn Node For Elim Reporting DEX
I_CnsldtnProfitCenterElimNode view from BASIC Cnsldtn Profit Center Elimination Node
I_CnsldtnProfitCenterElimNodeT view inner BASIC Cnsldtn Profit Center Elim Node - Text
I_CommitmentItemHierarchyNode view from BASIC Commitment Item Hierarchy Node
I_CompanyCodeHierNode view from BASIC Company Code Hierarchy Node
I_CompanyCodeHierSubtree view from BASIC Company Code Hierarchy Subtree
I_CostCenterHierarchyNode view from
I_CostCenterHierSubTree view from BASIC Cost Center Hierarchy Sub Tree
I_CostCtrActivityTypeHierNode view from BASIC Cost Center Activity Type Hierarchy Node
I_FinStmntItmHier view from BASIC Financial Statement Item - HierarchyNode
I_FinStmntItmHierT view inner BASIC Financial Statement Item HierNode - Text
I_FndsMgmtFctArHierNode view from BASIC Fnds Mgmt Functional Area Hierarchy Node
I_FunctionalAreaHierNode view from BASIC Functional Area Hierarchy Node
I_FundedProgramHierarchyNode view from BASIC Funded Program Hierarchy Node
I_FundHierarchyNode view from BASIC Fund Hierarchy Node
I_FundsCenterHierarchyNode view from BASIC Funds Center Hierarchy Node
I_GLAccountHierarchyNode view from BASIC G/L Account Hierarchy Node
I_GLAccountHierSubTree view from BASIC GL Account Hierarchy Sub Tree
I_GlobalCompanyHierNode view_entity from BASIC Global Company Hierarchy Node
I_GR_GLAccountHierarchyNode view_entity from BASIC Greece G/L Account Hierachy Node
I_GrantHierarchyNode view from BASIC Grant Hierarchy Node
I_GroupReportingFSItemHierNode view from BASIC Financial Statement Item - HierarchyNode
I_OrderHierarchyNode view from BASIC Order Hierarchy Node
I_ProfitCenterHierarchyNode view from
I_ProfitCenterHierSubTree view from BASIC Profit Center Hierarchy Sub Tree
I_SegmentHierNode view from BASIC Segment Hierarchy Node
I_StstclKeyFigureHierNode view from BASIC Statistical Key Figure Hierarchy Node
P_CnsldtnUnivHierNode_3 view from BASIC Cnsldtn Universal Hierarchy - Hier Node
P_CnsldtnUnivHierNodeElim_2 view from BASIC
P_CnsldtnUnivHierNodeText_3 view inner BASIC Cnsldtn Universal Hierarchy Node - Text
P_FinancialStatementHierNode view from BASIC
P_FinancialStatementHierNode view union_all BASIC
P_GLAccountHierNodeBySemTag_1 view from BASIC
P_GLAccountHierNodeBySemTag_2 view from BASIC
P_GLAccountHierNodeBySemTag_3 view from BASIC
P_SemTagFAGL2HRRP view inner BASIC Transform original mapping to replicated hierarchy
P_SemTagNode view inner BASIC
R_FinWBSElementHierarchyNode view_entity from BASIC Hierarchy Node of WBS Element
R_HierRuntimeRprstnDplLeafNode view_entity from BASIC Hierarchy Duplicated Leaf Values
R_HierRuntimeRprstnNode view from BASIC Hierarchy Node
SHSM_CompanyCodeHierarchyNVH view from Company Code Hierarchy Node Value Help
SHSM_CostCenterHierarchyNVH view from Cost Center Hierarchy Node Value Help
SHSM_ProfitCenterHierarchyNVH view from Profit Center Hierarchy Node Value Help

Fields (17)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY hrytyp hrytype Hierarchy Type
KEY hryid hryid_40 Hierarchy ID
KEY hrynode hrynode Node
KEY parnode parnode Par. Node
KEY hryvalto datbi Valid To
KEY nodecls nodecls Node Class
hryvalfrom datab Valid From
nodetype nodetyp Node Type
nodevalue nodevalue Value
leafvalue leafvalue Leaf Value
hryseqnbr hryseqnbr Sequence Number
hrylevel hrylevel Hierarchy Level
uhnodeid nodid Node ID
bety_name bnnam Business Entity
node_typelem nodetypelem Node Type Element
hryid_42 hryid Hierarchy ID

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 (New Design)
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE HRRP_NODE_N (
    MANDT,         -- Client [mandt]
    HRYTYP,        -- Hierarchy Type [hrytype]
    HRYID,         -- Hierarchy ID [hryid_40]
    HRYNODE,       -- Node [hrynode]
    PARNODE,       -- Par. Node [parnode]
    HRYVALTO,      -- Valid To [datbi]
    NODECLS,       -- Node Class [nodecls]
    HRYVALFROM,    -- Valid From [datab]
    NODETYPE,      -- Node Type [nodetyp]
    NODEVALUE,     -- Value [nodevalue]
    LEAFVALUE,     -- Leaf Value [leafvalue]
    HRYSEQNBR,     -- Sequence Number [hryseqnbr]
    HRYLEVEL,      -- Hierarchy Level [hrylevel]
    UHNODEID,      -- Node ID [nodid]
    BETY_NAME,     -- Business Entity [bnnam]
    NODE_TYPELEM,  -- Node Type Element [nodetypelem]
    HRYID_42,      -- Hierarchy ID [hryid]
    PRIMARY KEY (MANDT, HRYTYP, HRYID, HRYNODE, PARNODE, HRYVALTO, NODECLS)
);

Learn More