HRRP_DIR_N

Transparent Table Application Table
43 Fields 64 CDS Views

Hierarchy Directory (New Design)

HRRP_DIR_N is an SAP database table in S/4HANA. Hierarchy Directory (New Design). It contains 43 fields. 64 CDS views read from this table.

CDS Views using this table (64)

ViewTypeJoinVDMDescription
fac_cds_fh view from Flexible Hierarchy
fac_cds_hrrp_convert_sdm view left_outer SDM CDS for HRRP new design convert
FAC_CDS_UH_REUSE_FH_CC view inner Flexible Cost Center Hierarchy
FAC_CDS_UH_REUSE_FH_PC view inner Flexible Cost Center Hierarchy
FAC_DART_Z3_FSV_Header view from Financial Statement Version Header
FIN_SEL_HIER view from
fiscds_fin_stmnt_versn01 view from Fin Statement Variant with filled Chart Of Account
I_BillingDocumentTypeHier view_entity from BASIC Billing Document Type Hierarchy
I_BudgetPeriodHierarchy view from BASIC Budget Period Hierarchy
I_BudgetPeriodHierarchyStdVH view from BASIC Budget Period Hierarchy
I_BusinessAreaHierarchy view from BASIC BusinessArea Hierarchy
I_BusTransacTypeHier view from BASIC Business Transaction Type Hierarchy
I_BusTransacTypeHierVH view_entity from BASIC Business Transaction Type Hierarchy
I_CommitmentItemHierarchy_2 view from BASIC Commitment It Hierarchy for Global Acct
I_CommitmentItemHierarchyStdVH view from BASIC Commitment Item Hierarchy
I_CompanyCodeHierarchy view from BASIC Company Code Hierarchy
I_CompanyCodeHierarchyVH view from BASIC Company Code Hierarchy Value Help
I_CostCenterHierarchy view from BASIC Cost Center Hierarchy
I_CostCenterHierarchyVH view from BASIC Cost Center Hierarchy
I_CostCtrActivityTypeHierarchy view from BASIC Cost Center Activity Type Hierarchy
I_CountryHierarchy view_entity from BASIC Country/Region Hierarchy
I_CustomerGroupHierarchy view_entity from BASIC Customer Group Hierarchy
I_DistrChannelHierarchy view_entity from BASIC Distribution Channel Hierarchy
I_DivisionHierarchy view_entity from BASIC Division Hierarchy
I_FinancialStatementHier view from BASIC Financial Statement Hierarchy
I_FinancialStatementHierarchy view from BASIC Financial Statement Hierarchy
I_FinStmntItmHierDir view from BASIC FSItem Hierarchy Directory
I_FinSubstnValdtnHierVersion view_entity from BASIC Universal Hierarchy Versions
I_FunctionalAreaHierarchy view from BASIC Functional Area Hierarchy
I_FundedProgramHierarchy view from BASIC Funded Program Hierarchy
I_FundedProgramHierarchyStdVH view from BASIC Funded Program Hierarchy
I_FundHierarchy view from BASIC Fund Hierarchy
I_FundHierarchyStdVH view from BASIC Fund Hierarchy
I_FundsCenterHierarchy view from BASIC Funds Center Hierarchy
I_FundsCenterHierarchyStdVH view from BASIC Funds Center Hierarchy
I_GLAccountHierarchy view from BASIC General Ledger Account Hierarchy
I_GlobalCompanyHierarchy view_entity from BASIC Global Company Hierarchy
I_GR_GLAccountHierarchy view_entity from BASIC Greece G/L Account Hierachy
I_GrantHierarchy view from BASIC Grant Hierarchy
I_GrantHierarchyStdVH view from BASIC Grant Hierarchy
I_HierRuntimeRepresentation view from BASIC Hierarchy Directory
I_IndustryHierarchy view_entity from BASIC Industry Hierarchy
I_OrderHierarchy view from BASIC Order Hierarchy
I_PlantHierarchy view_entity from BASIC Plant Hierarchy
I_ProductGroupHierarchy view_entity from BASIC Product Group Hierarchy
I_ProfitCenterHierarchy view from BASIC Profit Center Hierarchy
I_ProfitCenterHierarchyVH view from BASIC Profit Center Hierarchy Value Help
I_SalesDistrictHierarchy view_entity from BASIC Sales District Hierarchy
I_SalesOrganizationHierarchy view_entity from BASIC Sales Organization Hierarchy
I_SegmentHierarchy view from BASIC Segment Hierarchy
I_StstclKeyFigureHierarchy view from BASIC Statistical Key Figure Hierarchy
P_CnsldtnUnivHierarchy_3 view from BASIC
P_CnsldtnUnivHierarchyText_3 view inner BASIC Consolidation Universal Hierarchy - Text
P_GLAccountHierNodeBySemTag_1 view inner BASIC
R_FinWBSElementHierarchy view from BASIC Hierarchy of WBS Element
R_HierRuntimeRepresentation view from BASIC Hierarchy Directory
SHSM_CompanyCodeHierarchyVH view from Company Code Hierarchy Value Help
SHSM_CompanyCodeHierarchyVH_42 view_entity from Company Code Hierarchy Value Help
SHSM_CostCenterHierarchyVH view from Cost Center Hierarchy Value Help
SHSM_CostCenterHierarchyVH_42 view_entity from Cost Center Hierarchy Value Help
SHSM_GLACCOUNTHIERARCHYVH view from GL Account Hierarchy Value Help
SHSM_GLACCOUNTHIERARCHYVH_42 view_entity from GL Account Hierarchy Value Help
SHSM_ProfitCenterHierarchyVH view from Profit Center Hierarchy Value Help
SHSM_ProfitCenterHierarchyVH42 view_entity from Profit Center Hierarchy Value Help

Fields (43)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY hrytyp HRYTYPE Hierarchy Type
KEY hryid HRYID_40 Hierarchy ID
KEY hryvalto DATBI Valid To
hryvalfrom DATAB Valid From
hrycls HRYCLS Hierarchy Class
hrysid VHRID Hierarchy ID
hrysource HRYSOURCE Source
updtime HRYUPDTIME Updated At
upduser UPNAM Changed By
cretime HRYCRETIME Created At
creuser CREATEBY Created by
uhverid VRSID Version ID
legacy_usage CULETCODE Use By Legacy TCode
hier_catg CAKEY Type
rollname ROLLNAME Data Element
setdtel SETDTEL_D Repr. Data Elem
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
salesorganization VKORG Sales Org.
distributionchannel VTWEG Distr. Channel
division SPART Division
dspra SPRAS Language
xergs XERGS_011 Group Account Number
aktva AKTVA_011 Assets
pssva PSSVA_011 Liabilities
ergak ERGAK_011 Net Loss
ergpa ERGPA_011 Net Profit/Year
erggv ERGGV_011 P+L Profit
zuord DZUORD_011 Not Assignable
anhng ANHNG_011 Fin.Stmt Notes
aging HRRP_AGING Aging
contraitempermit HRRP_CONTRA Contra Node
funareaassigned HRRP_FUNAREA Functional Area
banksplitassigned HRRP_BANKSPLIT Bank Acct Grouping
semtagassigned HRRP_SEMTAG Sem. Tag Assigned
dupglacc FINS_DUPGLACC FSV has duplicate G/L accounts.

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 Directory (New Design)
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE HRRP_DIR_N (
    MANDT,                -- Client [MANDT]
    HRYTYP,               -- Hierarchy Type [HRYTYPE]
    HRYID,                -- Hierarchy ID [HRYID_40]
    HRYVALTO,             -- Valid To [DATBI]
    HRYVALFROM,           -- Valid From [DATAB]
    HRYCLS,               -- Hierarchy Class [HRYCLS]
    HRYSID,               -- Hierarchy ID [VHRID]
    HRYSOURCE,            -- Source [HRYSOURCE]
    UPDTIME,              -- Updated At [HRYUPDTIME]
    UPDUSER,              -- Changed By [UPNAM]
    CRETIME,              -- Created At [HRYCRETIME]
    CREUSER,              -- Created by [CREATEBY]
    UHVERID,              -- Version ID [VRSID]
    LEGACY_USAGE,         -- Use By Legacy TCode [CULETCODE]
    HIER_CATG,            -- Type [CAKEY]
    ROLLNAME,             -- Data Element [ROLLNAME]
    SETDTEL,              -- Repr. Data Elem [SETDTEL_D]
    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]
    SALESORGANIZATION,    -- Sales Org. [VKORG]
    DISTRIBUTIONCHANNEL,  -- Distr. Channel [VTWEG]
    DIVISION,             -- Division [SPART]
    DSPRA,                -- Language [SPRAS]
    XERGS,                -- Group Account Number [XERGS_011]
    AKTVA,                -- Assets [AKTVA_011]
    PSSVA,                -- Liabilities [PSSVA_011]
    ERGAK,                -- Net Loss [ERGAK_011]
    ERGPA,                -- Net Profit/Year [ERGPA_011]
    ERGGV,                -- P+L Profit [ERGGV_011]
    ZUORD,                -- Not Assignable [DZUORD_011]
    ANHNG,                -- Fin.Stmt Notes [ANHNG_011]
    AGING,                -- Aging [HRRP_AGING]
    CONTRAITEMPERMIT,     -- Contra Node [HRRP_CONTRA]
    FUNAREAASSIGNED,      -- Functional Area [HRRP_FUNAREA]
    BANKSPLITASSIGNED,    -- Bank Acct Grouping [HRRP_BANKSPLIT]
    SEMTAGASSIGNED,       -- Sem. Tag Assigned [HRRP_SEMTAG]
    DUPGLACC,             -- FSV has duplicate G/L accounts. [FINS_DUPGLACC]
    PRIMARY KEY (MANDT, HRYTYP, HRYID, HRYVALTO)
);

Learn More