HRRP_NODE_N

Transparent Table Application Table
82 Fields 72 CDS Views

Hierarchy Node (New Design)

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

CDS Views using this table (72)

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
FIN_SEL_HIER_NODE view from
FIN_SEL_HIER_NODE_TEXT view inner
I_BillingDocTypeHierNode view_entity from BASIC Billing Document Type Hierarchy Node
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_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_CountryHierarchyNode view_entity from BASIC Country/Region Hierarchy Node
I_CustomerGroupHierarchyNode view_entity from BASIC Customer Group 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_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_FundedProgramHierarchyText view inner BASIC Funded Program Hierarch - Text
I_FundHierarchyNode view from BASIC Fund Hierarchy Node
I_FundHierarchyText view inner BASIC Fund Hierarchy - Text
I_FundsCenter2HierarchyNode view_entity from BASIC Funds Center 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_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
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
P_CnsldtnSegmentElimNodeT view_entity inner BASIC
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_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 (82)

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
kokrs KOKRS CO Area
ktopl KTOPL Chart of Accts
itclg FC_ITCLG Cons. COA
sityp FC_SITYP Subitem Category
scen_id VEC_SCEN_ID Scenario
fikrs FIKRS FM Area
fma_fisyear FMIS_FMA_FISCAL_YEAR FMA Fiscal Year
saknr SAKNR G/L Account
kostl KOSTL Cost Center
prctr PRCTR Profit Center
stagr STAGR Stat. key fig.
lstar LSTAR Activity Type
posid PS_POSID WBS Element
fkber FKBER Functional Area
bukrs BUKRS Company Code
segment FB_SEGMENT Segment
cbttype FINS_CUSTBTTYPE Bus. Trans. Type
aufnr AUFNR Order
fincode BP_GEBER Fund
grant_nbr GM_GRANT_NBR Grant
budget_pd FM_BUDGET_PERIOD Budget Period
sponsored_class GM_SPONSORED_CLASS Sponsored Class
fictr FISTL Funds Center
sponsored_prog GM_SPONSORED_PROG Sponsored Program
measure FM_MEASURE Funded Program
partner BU_PARTNER Busn. Partner
acc_id FCLM_BAM_ACC_ID Technical ID
lqpos FLQPOS Liquidity Item
gsber GSBER Business Area
trtyp RMVCT Transact. Type
kunnr KUNNR Customer
lifnr LIFNR Supplier
pspid PS_PSPID Project def.
matnr MATNR Material
kdgrp KDGRP Customer Group
land1 LAND1 Country/Reg.
item FINCS_FSI_ITEM FS Item
bunit FC_BUNIT Cons. Unit
sitem FC_SITEM Subitem
docty FC_DOCTY Document Type
rcomp RCOMP_D Company
matkl MATKL Material Group
rule_num VEC_RULE_NUM Rule ID
bzirk BZIRK Sales District
fkart FKART Billing Type
spart SPART Division
vkorg VKORG Sales Org.
vtweg VTWEG Distr. Channel
werks WERKS_D Plant
brsch BRSCH Industry
fipex FM_FIPEX Commitment Item
plevl FINCS_POSTINGLEVEL Posting Level
fs_product_group FFS_PRODUCT_GROUP Product Group (FS)
ischecklevel FINS_ATTR_CHKLVL AVC Check Level
isribcheck FINS_ATTR_RIBCHK RIB Check Level
pricingrelevant PRFRE Price determin.
balind BALIND Balance
sign FSV_SIGN Sign Flip
contra_item HRRP_CONTRAITEM Contra Node
banksplit FINS_BANKSPLIT Bank Account Grouping
regrouping FINS_INCRMNT Increment
ignore_rec FINS_NORECLS Ignore Recls.
fs_leafitem HRRP_FSITM FS Leaf Item
fs_nodetype FI_FSV_NODTYP Node Type
hrynodeext FI_FSV_NODEEXT Node for Extraction

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]
    KOKRS,             -- CO Area [KOKRS]
    KTOPL,             -- Chart of Accts [KTOPL]
    ITCLG,             -- Cons. COA [FC_ITCLG]
    SITYP,             -- Subitem Category [FC_SITYP]
    SCEN_ID,           -- Scenario [VEC_SCEN_ID]
    FIKRS,             -- FM Area [FIKRS]
    FMA_FISYEAR,       -- FMA Fiscal Year [FMIS_FMA_FISCAL_YEAR]
    SAKNR,             -- G/L Account [SAKNR]
    KOSTL,             -- Cost Center [KOSTL]
    PRCTR,             -- Profit Center [PRCTR]
    STAGR,             -- Stat. key fig. [STAGR]
    LSTAR,             -- Activity Type [LSTAR]
    POSID,             -- WBS Element [PS_POSID]
    FKBER,             -- Functional Area [FKBER]
    BUKRS,             -- Company Code [BUKRS]
    SEGMENT,           -- Segment [FB_SEGMENT]
    CBTTYPE,           -- Bus. Trans. Type [FINS_CUSTBTTYPE]
    AUFNR,             -- Order [AUFNR]
    FINCODE,           -- Fund [BP_GEBER]
    GRANT_NBR,         -- Grant [GM_GRANT_NBR]
    BUDGET_PD,         -- Budget Period [FM_BUDGET_PERIOD]
    SPONSORED_CLASS,   -- Sponsored Class [GM_SPONSORED_CLASS]
    FICTR,             -- Funds Center [FISTL]
    SPONSORED_PROG,    -- Sponsored Program [GM_SPONSORED_PROG]
    MEASURE,           -- Funded Program [FM_MEASURE]
    PARTNER,           -- Busn. Partner [BU_PARTNER]
    ACC_ID,            -- Technical ID [FCLM_BAM_ACC_ID]
    LQPOS,             -- Liquidity Item [FLQPOS]
    GSBER,             -- Business Area [GSBER]
    TRTYP,             -- Transact. Type [RMVCT]
    KUNNR,             -- Customer [KUNNR]
    LIFNR,             -- Supplier [LIFNR]
    PSPID,             -- Project def. [PS_PSPID]
    MATNR,             -- Material [MATNR]
    KDGRP,             -- Customer Group [KDGRP]
    LAND1,             -- Country/Reg. [LAND1]
    ITEM,              -- FS Item [FINCS_FSI_ITEM]
    BUNIT,             -- Cons. Unit [FC_BUNIT]
    SITEM,             -- Subitem [FC_SITEM]
    DOCTY,             -- Document Type [FC_DOCTY]
    RCOMP,             -- Company [RCOMP_D]
    MATKL,             -- Material Group [MATKL]
    RULE_NUM,          -- Rule ID [VEC_RULE_NUM]
    BZIRK,             -- Sales District [BZIRK]
    FKART,             -- Billing Type [FKART]
    SPART,             -- Division [SPART]
    VKORG,             -- Sales Org. [VKORG]
    VTWEG,             -- Distr. Channel [VTWEG]
    WERKS,             -- Plant [WERKS_D]
    BRSCH,             -- Industry [BRSCH]
    FIPEX,             -- Commitment Item [FM_FIPEX]
    PLEVL,             -- Posting Level [FINCS_POSTINGLEVEL]
    FS_PRODUCT_GROUP,  -- Product Group (FS) [FFS_PRODUCT_GROUP]
    ISCHECKLEVEL,      -- AVC Check Level [FINS_ATTR_CHKLVL]
    ISRIBCHECK,        -- RIB Check Level [FINS_ATTR_RIBCHK]
    PRICINGRELEVANT,   -- Price determin. [PRFRE]
    BALIND,            -- Balance [BALIND]
    SIGN,              -- Sign Flip [FSV_SIGN]
    CONTRA_ITEM,       -- Contra Node [HRRP_CONTRAITEM]
    BANKSPLIT,         -- Bank Account Grouping [FINS_BANKSPLIT]
    REGROUPING,        -- Increment [FINS_INCRMNT]
    IGNORE_REC,        -- Ignore Recls. [FINS_NORECLS]
    FS_LEAFITEM,       -- FS Leaf Item [HRRP_FSITM]
    FS_NODETYPE,       -- Node Type [FI_FSV_NODTYP]
    HRYNODEEXT,        -- Node for Extraction [FI_FSV_NODEEXT]
    PRIMARY KEY (MANDT, HRYTYP, HRYID, HRYNODE, PARNODE, HRYVALTO, NODECLS)
);

Learn More