UHM_ID_CHLOG

Transparent Table Customizing Table

Hierarchy ID Change Log

UHM_ID_CHLOG is an SAP database table in S/4HANA. Hierarchy ID Change Log. It contains 10 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
FAC_UH_MIGRTN_P_HIER_ID_lOG view from Union view for hierarchy id log
FAC_UH_MIGRTN_P_HIER_TYPE_LOG view from Union view for hierarchy type change log

Fields (10)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY hier_type htype Hierarchy Type
KEY hier_id uholdhid Hierarchy Old ID
KEY sub_class subcatgv Class
KEY action hieridact Action
KEY updated_at uhmupat Updated At
KEY updated_by uname User Name
KEY field uhmigcdfield Field
old_value uhmigoldval Old Value
new_value uhmignewval New Value

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 Change Log
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE UHM_ID_CHLOG (
    MANDT,       -- Client [mandt]
    HIER_TYPE,   -- Hierarchy Type [htype]
    HIER_ID,     -- Hierarchy Old ID [uholdhid]
    SUB_CLASS,   -- Class [subcatgv]
    ACTION,      -- Action [hieridact]
    UPDATED_AT,  -- Updated At [uhmupat]
    UPDATED_BY,  -- User Name [uname]
    FIELD,       -- Field [uhmigcdfield]
    OLD_VALUE,   -- Old Value [uhmigoldval]
    NEW_VALUE,   -- New Value [uhmignewval]
    PRIMARY KEY (MANDT, HIER_TYPE, HIER_ID, SUB_CLASS, ACTION, UPDATED_AT, UPDATED_BY, FIELD)
);