HRRP_NODE

Transparent Table Application Table
16 Fields 57 CDS Views

Hierarchy node

HRRP_NODE is an SAP database table in S/4HANA. Hierarchy node. It contains 16 fields. 57 CDS views read from this table.

CDS Views using this table (57)

ViewTypeJoinVDMDescription
FCLM_BAM_HIER_RTNODE_UH view from BAM Universal Hierarchy Runtime Node
FINCS_GENERICHIERSUBTREE view from Resolving of hierarchy nodes
FISVD_HRRP_NODE_DEX view from Extraction view for HRRP_NODE
I_BankAccountUniversalHierNode view from BASIC Node of Bank Account Universal Hierarchy
I_BudgetAccountHierarchy view inner BASIC Budget Account Hierarchy
I_BudgetAccountHierarchyNode view from BASIC Budget Account Hierarchy Node
I_CnsldtnDocTypeHierNode_2 view from BASIC Cnsldtn Document Type - Hierarchy Node
I_CnsldtnDocTypeHierNodeT_2 view inner BASIC Cnsldtn Document Type Hier Node - Text
I_CnsldtnDocumentTypeHierNode view from BASIC Document Type - Hierarchy Node
I_CnsldtnProjectHierarchy view from BASIC Consolidation Project Hierarchy Node
I_CnsldtnRptgItmHierNodeT view inner BASIC Consolidation Reporting Item HierNode - Text
I_CnsldtnSalesOrgHierNodeEnhcd view from BASIC Cnsldtn Sales Organization - Hier Node
I_CnsldtnSubitemHierNode view from BASIC Consolidation Subitem - HierarchyNode
I_CnsldtnUnitForElimHierNode_2 view from BASIC Cnsldtn Unit for Elimination - Hier Node
I_CnsldtnUnitHierForElimEnhcd view from BASIC Consolidation Unit Hierarchy For Elimination
I_CnsldtnUnitHierNodeEnhcd_2 view from BASIC Consolidation Unit Hierarchy Enhanced 2
I_CnsldtnUnitHierNodeForElim view from BASIC Csnldtn Unit for Mgmt Elim - Hier Node
I_CommitmentItemHierarchyText view inner BASIC Commitment Item Hierarchy - Text
I_CorporateIncomeTaxHierNode view from BASIC CIT Hierarchy Node
I_CustUnivHierarchyNodeBase view from BASIC Customer Hierarchy Node
I_FSItemBySemanticTag view inner BASIC Fetch Financial Statement Item By Semantic Tag
I_FuncnlAreaGlobAcctgHier view from BASIC Global Accnt Hierarchy Functional Area
I_FundGlobAcctgHier view from BASIC Global Accounting Hierarchy for Fund
I_FundsCenterHierarchyText view inner BASIC Funds Center Hierarchy - Text
I_GrantGlobAcctgHier view from BASIC Global Accounting Hierarchy for Grant
I_ProdUnivHierarchyNodeBasic view from BASIC Product Hierarchy Node
I_ProdUnivHierNodeWthVersID view from BASIC Product Hierarchy Node
I_SponsoredClassHierarchy view inner BASIC Hierarchy of Sponsored Class
I_SponsoredClassHierarchyNode view from BASIC Sponsored Class Hierarchy Node
I_SponsoredProgHierarchyNode view from BASIC Sponsored Prog Hierarchy Node
I_SponsoredProgramHierarchy view inner BASIC Sponsored Program Hierarchy
I_WBSElementHierarchyNode view from BASIC WBS Element Hierarchy Node
P_CnsldtnHierNode view from BASIC
P_CnsldtnUnitElimNodeText view_entity inner BASIC
P_CnsldtnUnivHierNode view from BASIC
P_CnsldtnUnivHierNode_2 view from BASIC
P_CnsldtnUnivHierNodeElim view from BASIC
P_CnsldtnUnivHierNodeElimT view inner BASIC
P_CnsldtnUnivHierNodeText view inner BASIC Consolidation Universal Hier Node - Text
P_CnsldtnUnivHierNodeText_2 view inner BASIC
P_FSTMT_Hry_leaf view inner BASIC
P_FSTMT_Hry_leaf view from BASIC
P_FSTMT_HRY_NODE view union BASIC
P_FSTMT_HRY_NODE view inner BASIC
P_FSTMT_HRY_NODE view from BASIC
P_hrrp_node view from BASIC
P_HrrpNodeLiqItmHier view from BASIC
P_Matrix_Hier_Leaf view from COMPOSITE
PSM_AVC_BUDGET_ACCOUNT_BASIC view left_outer Basic Budget Account View for Hierarchy
PSM_AVC_BUDGET_PERIOD_BASIC view left_outer Basic Budget Period View for Hierarchy
PSM_AVC_COST_CENTER_BASIC view left_outer Basic Cost Center View for Hierarchy
PSM_AVC_FUNCTIONAL_AREA_BASIC view left_outer Basic Functional Area View for Hierarchy
PSM_AVC_FUND_BASIC view left_outer Basic Fund View for Hierarchy
PSM_AVC_GRANT_BASIC view left_outer Basic Grant View for Hierarchy
PSM_AVC_SPONSORED_CLASS_BASIC view left_outer Basic Sponsored Class View for Hierarchy
PSM_AVC_SPONSORED_PROG_BASIC view left_outer Basic Sponsored Prog. View for Hierarchy
PSM_AVC_WBS_ELEMENT_BASIC view left_outer Basic WBS Element View for Hierarchy

Fields (16)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY hryid HRYID Hierarchy ID
KEY hryver HRYVERSN Version
KEY nodecls NODECLS Node Class
KEY hrynode HRYNODE Node
KEY parnode PARNODE Par. Node
KEY hryvalto DATBI Valid To
hryvalfrom DATAB Valid From
balind BALIND Balance
nodetype NODETYP Node Type
nodevalue NODEVALUE Value
hryseqnbr HRYSEQNBR Sequence Number
hrylevel HRYLEVEL Hierarchy Level
hrytype HRYTYPE Hierarchy Type
leafvalue LEAFVALUE Leaf Value
uhnodeid NODID Node 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
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE HRRP_NODE (
    MANDT,       -- Client [MANDT]
    HRYID,       -- Hierarchy ID [HRYID]
    HRYVER,      -- Version [HRYVERSN]
    NODECLS,     -- Node Class [NODECLS]
    HRYNODE,     -- Node [HRYNODE]
    PARNODE,     -- Par. Node [PARNODE]
    HRYVALTO,    -- Valid To [DATBI]
    HRYVALFROM,  -- Valid From [DATAB]
    BALIND,      -- Balance [BALIND]
    NODETYPE,    -- Node Type [NODETYP]
    NODEVALUE,   -- Value [NODEVALUE]
    HRYSEQNBR,   -- Sequence Number [HRYSEQNBR]
    HRYLEVEL,    -- Hierarchy Level [HRYLEVEL]
    HRYTYPE,     -- Hierarchy Type [HRYTYPE]
    LEAFVALUE,   -- Leaf Value [LEAFVALUE]
    UHNODEID,    -- Node ID [NODID]
    PRIMARY KEY (MANDT, HRYID, HRYVER, NODECLS, HRYNODE, PARNODE, HRYVALTO)
);

Learn More