UHM_WHERE_USED

Transparent Table Application Table
14 Fields 1 CDS Views

Consumption Application Changes

UHM_WHERE_USED is an SAP database table in S/4HANA. Consumption Application Changes. It contains 14 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
FAC_UH_MIGRTN_I_HIER_WHEREUSED view_entity from Hierarchy where used list - data model

Fields (14)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY hier_type HTYPE Hierarchy Type
KEY application UHMWAPP Application
KEY object UHMWOBJECT Object
KEY subobject UHMWSUBOBJECT Subobject
KEY objectvalue UHMOBJVAL Object Value
KEY subojectvalue UHMSUBOBJVAL Subobject Value
KEY hier_old_id UHOLDHID Hierarchy Old ID
KEY sub_class SUBCATGV Class
hier_new_id UHNEWHID Hierarchy New ID
whereused_activity_typ UHMWSTYP Activity Type
whereused_activity_status HTYPES Completed
updated_by HIERUPDBY Last Changed By
updated_at HIERUPDAT Changed At

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.

-- Consumption Application Changes
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE UHM_WHERE_USED (
    MANDT,                      -- Client [MANDT]
    HIER_TYPE,                  -- Hierarchy Type [HTYPE]
    APPLICATION,                -- Application [UHMWAPP]
    OBJECT,                     -- Object [UHMWOBJECT]
    SUBOBJECT,                  -- Subobject [UHMWSUBOBJECT]
    OBJECTVALUE,                -- Object Value [UHMOBJVAL]
    SUBOJECTVALUE,              -- Subobject Value [UHMSUBOBJVAL]
    HIER_OLD_ID,                -- Hierarchy Old ID [UHOLDHID]
    SUB_CLASS,                  -- Class [SUBCATGV]
    HIER_NEW_ID,                -- Hierarchy New ID [UHNEWHID]
    WHEREUSED_ACTIVITY_TYP,     -- Activity Type [UHMWSTYP]
    WHEREUSED_ACTIVITY_STATUS,  -- Completed [HTYPES]
    UPDATED_BY,                 -- Last Changed By [HIERUPDBY]
    UPDATED_AT,                 -- Changed At [HIERUPDAT]
    PRIMARY KEY (MANDT, HIER_TYPE, APPLICATION, OBJECT, SUBOBJECT, OBJECTVALUE, SUBOJECTVALUE, HIER_OLD_ID, SUB_CLASS)
);

Learn More