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