HRRP_NODE_N

Transparent Table Application Table
20 Fields 66 CDS Views

Hierarchy Node (New Design)

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

CDS Views using this table (66)

ViewTypeJoinVDMDescription
fac_cds_fh_node view from Flexible Hierarchy Node
fac_cds_hrrp_hiercatg_sdm view_entity left_outer SDM CDS for HRRP Hierarchy Category
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 Selection Hierarchy Leaf Node
FIN_SEL_HIER_NODE view from Selection Hierarchy Node
FIN_SEL_HIER_NODE_TEXT view inner Selection Hierarchy Node Text
I_BillingDocTypeHierNode view_entity from BASIC Billing Document Type 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_CompanyCodeHierNode view from BASIC Company Code Hierarchy Node
I_CompanyCodeHierSubtree view_entity from BASIC Company Code Hierarchy Subtree
I_CostCenterHierarchyNode view from Cost Center Hierarchy Node
I_CostCenterHierSubTree view from BASIC Cost Center Hierarchy Sub Tree
I_CostComponentHierarchyNode view_entity from BASIC Cost Breakdown Hierarchy Node
I_CostCtrActivityTypeHierNode view from BASIC Cost Center Activity Type Hierarchy Node
I_CountryHierarchyNode view_entity from BASIC Country/Region Hierarchy Node
I_CustomerGroupHierarchyNode view_entity from BASIC Customer Group Hierarchy Node
I_CustUnivHierarchyNode_2 view_entity from BASIC Customer Universal Hierarchy Node
I_DistrChannelHierarchyNode view_entity from BASIC Distribution Channel Hierarchy Node
I_DivisionHierarchyNode view_entity from BASIC Division Hierarchy Node
I_FinStmntItmHier view from BASIC Financial Statement Item - HierarchyNode
I_FinStmntItmHierT view inner BASIC Financial Statement Item HierNode - Text
I_FunctionalAreaHierNode view from BASIC Functional Area 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_GroupReportingFSItemHierNode view from BASIC Financial Statement Item - HierarchyNode
I_HierRuntimeRprstnNode view from BASIC Hierarchy Node
I_IndustryHierarchyNode view_entity from BASIC Industry Hierarchy Node
I_OrderHierarchyNode view from BASIC Order Hierarchy Node
I_PlantHierarchyNode view_entity from BASIC Plant Hierarchy Node
I_ProductGroupHierarchyNode view_entity from BASIC Product Group Hierarchy Node
I_ProfitCenterHierarchyNode view from Profit Center Hierarchy Node
I_ProfitCenterHierSubTree view from BASIC Profit Center Hierarchy Sub Tree
I_SalesDistrictHierarchyNode view_entity from BASIC Sales District Hierarchy Node
I_SegmentHierNode view from BASIC Segment Hierarchy Node
I_SlsOrgHierarchyNode view_entity from BASIC Sales Organization Hierarchy Node
I_StstclKeyFigureHierNode view from BASIC Statistical Key Figure Hierarchy Node
ICA_GL_ACCOUNT_HIER_NODE view_entity from Example: GL Account Hierarchy Node
P_CnsldtnProfitCenterElimNodeT view_entity inner BASIC Cnsldtn Profit Center Elim Node - Text
P_CnsldtnSegmentElimNodeT view_entity inner BASIC Cnsldtn Segment Elimination Node - Text
P_CnsldtnUnivHierNode_3 view from BASIC Cnsldtn Universal Hierarchy - Hier Node
P_CnsldtnUnivHierNodeElim_2 view from BASIC Consolidation Universal Hierarchy Node
P_CnsldtnUnivHierNodeText_3 view inner BASIC Cnsldtn Universal Hierarchy Node - Text
P_FinancialStatementHierNode view from BASIC Financial Statement Hierarchy Node
P_FinancialStatementHierNode view union_all BASIC Financial Statement Hierarchy Node
P_GLAccountHierNodeBySemTag_1 view from BASIC G/L Account Hierarchy Node By Semantic Tag
P_GLAccountHierNodeBySemTag_2 view from BASIC G/L Account Hierarchy Node By Semantic Tag
P_GLAccountHierNodeBySemTag_3 view from BASIC G/L Account Hierarchy Node By Semantic Tag
P_SemTagFAGL2HRRP view inner BASIC Transform original mapping to replicated hierarchy
P_SemTagNode view inner BASIC Semantic Tag Node
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 (20)

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
hier_catg cakey Type
node_timedep node_timedep
par_uhnodeid npnid Node Parent 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]
    HIER_CATG,     -- Type [cakey]
    NODE_TIMEDEP,  -- node_timedep
    PAR_UHNODEID,  -- Node Parent ID [npnid]
    PRIMARY KEY (MANDT, HRYTYP, HRYID, HRYNODE, PARNODE, HRYVALTO, NODECLS)
);

Learn More