MPE_EXEC_HOLD_SO

Transparent Table Application Table
7 Fields 1 CDS Views

SFI@OA affected when a Production Hold was applied

MPE_EXEC_HOLD_SO is an SAP database table in S/4HANA. SFI@OA affected when a Production Hold was applied. It contains 7 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_ProdnHoldAffcdSFIAtOpActy view from BASIC SFI at OA affected when a production hold was applied

Fields (7)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY hold_nmbr mpe_hold_nmbr Hold ID
KEY sfi_id mpe_sfi_id Serial.Mat. ID
KEY oan_instance_id mpe_oan_instance_id Instance ID
KEY oan_element_number mpe_oan_element_number Element Number
sas_name mpe_sasname_type Status Action Schema
sas_status_name mpe_status_name_type Status

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.

-- SFI@OA affected when a Production Hold was applied
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MPE_EXEC_HOLD_SO (
    MANDT,               -- Client [mandt]
    HOLD_NMBR,           -- Hold ID [mpe_hold_nmbr]
    SFI_ID,              -- Serial.Mat. ID [mpe_sfi_id]
    OAN_INSTANCE_ID,     -- Instance ID [mpe_oan_instance_id]
    OAN_ELEMENT_NUMBER,  -- Element Number [mpe_oan_element_number]
    SAS_NAME,            -- Status Action Schema [mpe_sasname_type]
    SAS_STATUS_NAME,     -- Status [mpe_status_name_type]
    PRIMARY KEY (MANDT, HOLD_NMBR, SFI_ID, OAN_INSTANCE_ID, OAN_ELEMENT_NUMBER)
);

Learn More