MPE_EXEC_HOLD

Transparent Table Application Table
24 Fields 1 CDS Views

Production Hold

MPE_EXEC_HOLD is an SAP database table in S/4HANA. Production Hold. It contains 24 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_ProductionHoldBasic view from BASIC Production Hold

Fields (24)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY hold_nmbr mpe_hold_nmbr Hold ID
hold_object_type mpe_hold_object_type Object Type
werks werks_d Plant
matnr matnr Material
arbid cr_objid Object ID
aufnr aufnr Order
aufpl co_aufpl Plan No.f.Oper.
aplzl co_aplzl Counter
oan_instance_id mpe_oan_instance_id Instance ID
oan_element_number mpe_oan_element_number Element Number
sfi_id mpe_sfi_id Serial.Mat. ID
sfi_at_oai_group_id mpe_sfi_at_oai_group_id Serial Number Group
started_at mpe_start_time Put on Hold
ended_at mpe_end_time Released On
gross_duration mpe_gross_duration Duration (Calendar)
net_calendar_duration mpe_net_calendar_duration Duration (Work Days)
net_work_center_duration mpe_net_work_center_duration Duration (Op. Time)
qmnum qdefectinternalid Internal Defect ID
fenum felfd Item
notification qmnum Notification
notification_item felfd Item
is_applied_for_order_chg mpe_is_applied_for_order_chg Change Order
trggrd_by_hold_nmbr mpe_hold_nmbr Hold 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.

-- Production Hold
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MPE_EXEC_HOLD (
    MANDT,                     -- Client [mandt]
    HOLD_NMBR,                 -- Hold ID [mpe_hold_nmbr]
    HOLD_OBJECT_TYPE,          -- Object Type [mpe_hold_object_type]
    WERKS,                     -- Plant [werks_d]
    MATNR,                     -- Material [matnr]
    ARBID,                     -- Object ID [cr_objid]
    AUFNR,                     -- Order [aufnr]
    AUFPL,                     -- Plan No.f.Oper. [co_aufpl]
    APLZL,                     -- Counter [co_aplzl]
    OAN_INSTANCE_ID,           -- Instance ID [mpe_oan_instance_id]
    OAN_ELEMENT_NUMBER,        -- Element Number [mpe_oan_element_number]
    SFI_ID,                    -- Serial.Mat. ID [mpe_sfi_id]
    SFI_AT_OAI_GROUP_ID,       -- Serial Number Group [mpe_sfi_at_oai_group_id]
    STARTED_AT,                -- Put on Hold [mpe_start_time]
    ENDED_AT,                  -- Released On [mpe_end_time]
    GROSS_DURATION,            -- Duration (Calendar) [mpe_gross_duration]
    NET_CALENDAR_DURATION,     -- Duration (Work Days) [mpe_net_calendar_duration]
    NET_WORK_CENTER_DURATION,  -- Duration (Op. Time) [mpe_net_work_center_duration]
    QMNUM,                     -- Internal Defect ID [qdefectinternalid]
    FENUM,                     -- Item [felfd]
    NOTIFICATION,              -- Notification [qmnum]
    NOTIFICATION_ITEM,         -- Item [felfd]
    IS_APPLIED_FOR_ORDER_CHG,  -- Change Order [mpe_is_applied_for_order_chg]
    TRGGRD_BY_HOLD_NMBR,       -- Hold ID [mpe_hold_nmbr]
    PRIMARY KEY (MANDT, HOLD_NMBR)
);

Learn More