UHM_HIER_ID_OV

Transparent Table Customizing Table
12 Fields 4 CDS Views

Hierarchy ID Overview

UHM_HIER_ID_OV is an SAP database table in S/4HANA. Hierarchy ID Overview. It contains 12 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
FAC_CDS_FSV_VERSION view left_outer Universal Financial Statement Version
FAC_UH_MIGRTN_I_HIERARCHY_ID view_entity from Hierarchy ID view - data model
FAC_UH_MIGRTN_I_STATUS_CC view from Migration status for cost center group
FAC_UH_MIGRTN_I_STATUS_FSV view from Migration status for financial statement version

Fields (12)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY hier_type htype Hierarchy Type
KEY hier_old_id uholdhid Hierarchy Old ID
KEY sub_class subcatgv Class
hier_new_id uhnewhid Hierarchy New ID
hier_mig_status uhmigs Migration Status
updated_by hierupdby Last Changed By
updated_at hierupdat Changed At
hier_old_status vrsst Status
hier_dependency uhmigdpndcy Dependent Hierarchy
hier_dependency_subclass subcatgv Class
mgh_verid vrsid Version 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 ID Overview
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE UHM_HIER_ID_OV (
    MANDT,                     -- Client [mandt]
    HIER_TYPE,                 -- Hierarchy Type [htype]
    HIER_OLD_ID,               -- Hierarchy Old ID [uholdhid]
    SUB_CLASS,                 -- Class [subcatgv]
    HIER_NEW_ID,               -- Hierarchy New ID [uhnewhid]
    HIER_MIG_STATUS,           -- Migration Status [uhmigs]
    UPDATED_BY,                -- Last Changed By [hierupdby]
    UPDATED_AT,                -- Changed At [hierupdat]
    HIER_OLD_STATUS,           -- Status [vrsst]
    HIER_DEPENDENCY,           -- Dependent Hierarchy [uhmigdpndcy]
    HIER_DEPENDENCY_SUBCLASS,  -- Class [subcatgv]
    MGH_VERID,                 -- Version ID [vrsid]
    PRIMARY KEY (MANDT, HIER_TYPE, HIER_OLD_ID, SUB_CLASS)
);

Learn More