UHDT_HIER

Transparent Table Customizing Table
5 Fields 36 CDS Views

Hierarchy Description Table

UHDT_HIER is an SAP database table in S/4HANA. Hierarchy Description Table. It contains 5 fields. 36 CDS views read from this table.

CDS Views using this table (36)

ViewTypeJoinVDMDescription
FAC_CDS_FSV_VERSION view left_outer Universal Financial Statement Version
FAC_CDS_UH_ACTIVITYTYPE view left_outer Universal Functional Activity Type
FAC_CDS_UH_COMPANYCODEHIER view left_outer Universal Company Code Hierarchy
FAC_CDS_UH_COSTCENTERHIER view left_outer Universal Cost Center Hierarchy
FAC_CDS_UH_FSVHIER view left_outer Universal Financial Statement Version
FAC_CDS_UH_FUNCNLAREAHIER view left_outer Universal Functional Area Hierarchy
FAC_CDS_UH_GENERICHIER view left_outer Universal Generic Hierarchy
FAC_CDS_UH_GLACCOUNTHIER view left_outer Universal Hierarchy G/L Account
FAC_CDS_UH_HIERARCHY view left_outer Hierarchy Information
FAC_CDS_UH_HIERARCHY_VH view left_outer Hierarchy Information
FAC_CDS_UH_NOTIFICATION view left_outer Notification to Be Update
FAC_CDS_UH_PRFTCENTERHIER view left_outer Universal Profit Center Hierarchy
FAC_CDS_UH_REGIONHIER view left_outer Universal Region Hierarchy
FAC_CDS_UH_RULEHIER view left_outer Rule Hierarchy
FAC_CDS_UH_SEGMENTHIER view left_outer Universal Segment Hierarchy
FAC_CDS_UH_STSTCLKEYFIG view left_outer Universal Hier Statistical Key Figure
fac_cds_uh_version view left_outer Universal Hierarchy Version
FAC_CDS_UH_VSRN_TO_UPDATE view left_outer Hierarchy Version to Be Update
FINCS_UH_BUSINESSAREAHIER view left_outer Universal Hierarchy Business Area Hierarchy
FINCS_UH_COSTCENTERHIER view left_outer Universal Hierarchy Cost Center Hierarchy
FINCS_UH_COUNTRYKEYHIER view left_outer Universal Hierarchy Country/Region Hier
FINCS_UH_CUSTOMERGRPHIER view left_outer Universal Hierarchy Customer Group Hierarchy
FINCS_UH_CUSTOMERHIER view left_outer Universal Hierarchy Customer Hierarchy
FINCS_UH_FINTRANSTYPEHIER view left_outer Universal Hierarchy Transaction Type Hierarchy
FINCS_UH_FSITEMHIER view left_outer Universal Hierarchy Financial Statement Item Hierarchy
FINCS_UH_FUNCTIONALAREAHIER view left_outer Universal Hierarchy Functional Area Hier
FINCS_UH_GLACCOUNTHIER view left_outer Universal Hierarchy G/L Account Hierarchy
FINCS_UH_PRODUCTHIER view left_outer Universal Hierarchy Product Sold Hierarchy
FINCS_UH_PROFITCENTERHIER view left_outer Universal Hierarchy Profit Center Hierarchy
FINCS_UH_PROJECTHIER view left_outer Universal Hierarchy Project Hierarchy
FINCS_UH_RITEMHIER view left_outer Universal Hierarchy Reporting Item Hierarchy
FINCS_UH_SALESORGHIER view left_outer Universal Hierarchy Sales Organization Hierarchy
FINCS_UH_SEGMENTHIER view left_outer Universal Hierarchy Segment Hierarchy
FINCS_UH_SUPPLIERHIER view left_outer Universal Hierarchy Supplier Hierarchy
FINCS_UH_UNITHIER view left_outer Universal Hierarchy - Consolidation Unit Hierarchy
I_UniversalHierHierarchy view from BASIC Hierarchy in Universal Hierarchy

Fields (5)

KeyField Data ElementDescription DomainTypeLength
KEY client mandt Client
KEY hier_hid vhrid Hierarchy ID
KEY hier_catg cakey Type
KEY lang langu Language
hier_desc vhdec Description

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 Description Table
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE UHDT_HIER (
    CLIENT,     -- Client [mandt]
    HIER_HID,   -- Hierarchy ID [vhrid]
    HIER_CATG,  -- Type [cakey]
    LANG,       -- Language [langu]
    HIER_DESC,  -- Description [vhdec]
    PRIMARY KEY (CLIENT, HIER_HID, HIER_CATG, LANG)
);

Learn More