HRRP_DIRECTORY

Transparent Table Application Table
12 Fields 54 CDS Views

Hierarchy directory

HRRP_DIRECTORY is an SAP database table in S/4HANA. Hierarchy directory. It contains 12 fields. 54 CDS views read from this table.

CDS Views using this table (54)

ViewTypeJoinVDMDescription
FAC_CDS_HRRP_ATTR_DIR_SDM view from hrrp_attr_dir with SDM hryid field
fac_cds_hrrp_convert_sdm view from SDM CDS for HRRP new design convert
FAC_HRRP_Directory_SDM view from Hrrp table with SDM field
FAC_HRRP_Directoryt_SDM view inner Hrrp text table with SDM status
FCLM_BAM_HIERARCHY_UH view from BAM Universal Hierarchy
I_BankAccountUniversalHier view from BASIC Bank Account Universal Hierarchy
I_BudgetAccountHierarchy view from BASIC Budget Account Hierarchy
I_BudgetAccountHierarchyStdVH view from BASIC Budget Account Hierarchy
I_CnsldtnCustGroupHierDirEnhcd view from BASIC Consolidation Combined Cust Grp Hierarchy Directory Enhcd
I_CnsldtnDocTypeHierarchy_2 view from BASIC Consolidation Document Type Hierarchy
I_CnsldtnDocTypeHierarchyT_2 view inner BASIC Cnsldtn Document Type Hierarchy - Text
I_CnsldtnDocumentTypeHierDir view from BASIC Consolidation Document Type Hier Dir
I_CnsldtnDocumentTypeHierNode view inner BASIC Document Type - Hierarchy Node
I_CnsldtnGLAccountHierDirEnhcd view from BASIC Consolidation Combined G/L Account Hierarchy Directory Enhcd
I_CnsldtnMatlGrpHierDir view from BASIC Consolidation Material Group Hier Dir
I_CnsldtnPostingLevelHierDir view from BASIC Consolidation Posting Level Directory
I_CnsldtnPostingLevelHierNode view inner BASIC Consolidation Posting Level - HierNode
I_CnsldtnPostingLevelHierNodeT view inner BASIC Consolidation Posting Level HierNode - Txt
I_CnsldtnProdSoldHierDirEnhcd view from BASIC Consolidation Product Sold Hierarchy Directory Enhanced
I_CnsldtnProjectHierDirEnhcd view from BASIC Consolidation Project Hierarchy Directory
I_CnsldtnRptgItmHierDir view from BASIC Reporting Item Hierarchy Directory
I_CnsldtnRptgItmHierDirT view inner BASIC Reporting Item Hierarchy Directory - Txt
I_CnsldtnSalesOrgHierDirEnhcd view from BASIC Consolidation Sales Organization Hierarchy Directory Enhcd
I_CnsldtnSubitemHierDir view from BASIC Consolidation Subitem Hierarchy Dir
I_CnsldtnSubitemHierNode view inner BASIC Consolidation Subitem - HierarchyNode
I_CnsldtnSubitemHierNodeT view inner BASIC Consolidation Subitem HierNode - Text
I_CnsldtnSupplierHierDirEnhcd view from BASIC Consolidation Supplier Hierarchy Directory Enhanced
I_CnsldtnUnitHierDirEnhcd view from BASIC Consolidation Unit Hierarchy Directory Enhanced
I_CorporateIncomeTaxHierarchy view from BASIC Corporate Income Tax Hierarchy
I_CustUniversalHierarchyText view inner BASIC Customer Hierarchy Directory - Text
I_CustUnivHierarchyBase view from BASIC Customer Hierarchy Directory
I_CustUnivHierNodeText view inner BASIC Customer Hierarchy Node - Text
I_GrpRptgSelProjectHierNode view inner BASIC Project Hierarchy Node
I_ProdHierByDistributionChain view from BASIC Product Hierarchy by Product Sales Delivery
I_ProdUniversalHierarchyText view inner BASIC Text View of Product Hierarchy Directory
I_ProdUniversalHierarchyText_2 view inner BASIC Product Hierarchy - Text
I_ProdUnivHierarchyBasic view from BASIC Product Hierarchy Directory
I_ProdUnivHierarchyNodeBasic view inner BASIC Product Hierarchy Node
I_ProdUnivHierNodeText_2 view inner BASIC Product Hierarchy Node - Text
I_ProdUnivHierWthVersID view from BASIC Product Hierarchy Directory
I_SponsoredClassHierarchy view from BASIC Hierarchy of Sponsored Class
I_SponsoredProgramHierarchy view from BASIC Hierarchy of the Sponsored Program
I_WBSElementHierarchy view from BASIC WBS Element Hierarchy
I_WBSElementHierarchy view union_all BASIC WBS Element Hierarchy
P_CnsldtnHierDir view from BASIC
P_CnsldtnUnitOfElimination view inner BASIC
P_CnsldtnUnivHierarchy view from BASIC Consolidation Universal Hierarchy
P_CnsldtnUnivHierarchy_2 view from BASIC Consolidation Universal Hierarchy
P_CnsldtnUnivHierarchyText view inner BASIC Consolidation Universal Hierarchy - Text
P_CnsldtnUnivHierarchyText_2 view inner BASIC
P_CtlgSlsProdHierNodeVH view_entity from COMPOSITE
P_CtlgSlsProdHierVH view_entity from COMPOSITE
P_FCLM_LQH_ATTR view from BASIC
P_FCLM_LQH_TEXT view from BASIC

Fields (12)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY hryid hryid Hierarchy ID
KEY hryver hryversn Version
KEY hryvalto datbi Valid To
hryvalfrom datab Valid From
hrytyp hrytype Hierarchy Type
updtime hryupdtime Updated At
upduser upnam Changed By
hrysource hrysource Source
hrysid vhrid Hierarchy ID
hrycls hrycls Hierarchy Class
isprivate privateind Private Hierarchy

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
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE HRRP_DIRECTORY (
    MANDT,       -- Client [mandt]
    HRYID,       -- Hierarchy ID [hryid]
    HRYVER,      -- Version [hryversn]
    HRYVALTO,    -- Valid To [datbi]
    HRYVALFROM,  -- Valid From [datab]
    HRYTYP,      -- Hierarchy Type [hrytype]
    UPDTIME,     -- Updated At [hryupdtime]
    UPDUSER,     -- Changed By [upnam]
    HRYSOURCE,   -- Source [hrysource]
    HRYSID,      -- Hierarchy ID [vhrid]
    HRYCLS,      -- Hierarchy Class [hrycls]
    ISPRIVATE,   -- Private Hierarchy [privateind]
    PRIMARY KEY (MANDT, HRYID, HRYVER, HRYVALTO)
);

Learn More