MPE_OA_INSTANCE

Transparent Table Application Table
14 Fields 2 CDS Views

Operation Activity Instance

MPE_OA_INSTANCE is an SAP database table in S/4HANA. Operation Activity Instance. It contains 14 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_OperationActivityInstance view from BASIC Operation Activity Instance
V_SFIAtOpActyMissingStatus view from

Fields (14)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
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
expd_yield MPE_OA_EXPD_YIELD OA Expected Yield
expd_scrap MPE_OA_EXPD_SCRAP OA Expected Scrap
uom MPE_OA_UOM OA Unit of Measure
expd_exec_durn MPE_EXPD_EXEC_DURATION Target Time (s)
expd_exec_labor_time MPE_EXPD_EXEC_LABOR_TIME Target Time (s)
plnty PLNTY Task List Type
plnnr PLNNR Group
plnal PLNAL Group Counter
plnkn PLNKN Node
versn PLNVERSN Routing Version

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.

-- Operation Activity Instance
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MPE_OA_INSTANCE (
    MANDT,                 -- Client [MANDT]
    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]
    EXPD_YIELD,            -- OA Expected Yield [MPE_OA_EXPD_YIELD]
    EXPD_SCRAP,            -- OA Expected Scrap [MPE_OA_EXPD_SCRAP]
    UOM,                   -- OA Unit of Measure [MPE_OA_UOM]
    EXPD_EXEC_DURN,        -- Target Time (s) [MPE_EXPD_EXEC_DURATION]
    EXPD_EXEC_LABOR_TIME,  -- Target Time (s) [MPE_EXPD_EXEC_LABOR_TIME]
    PLNTY,                 -- Task List Type [PLNTY]
    PLNNR,                 -- Group [PLNNR]
    PLNAL,                 -- Group Counter [PLNAL]
    PLNKN,                 -- Node [PLNKN]
    VERSN,                 -- Routing Version [PLNVERSN]
    PRIMARY KEY (MANDT, OAN_INSTANCE_ID, OAN_ELEMENT_NUMBER)
);

Learn More