MPE_OA_WI

Transparent Table Application Table
9 Fields 1 CDS Views

Work Instruction Assignment to Operation Activities

MPE_OA_WI is an SAP database table in S/4HANA. Work Instruction Assignment to Operation Activities. It contains 9 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_OpActyWorkInstructionAssgmt view from BASIC Op. Acty. Work Instruction Assignment

Fields (9)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY oa_id MPE_OA_ID Operation Activity
KEY oa_version_no MPE_OA_VERSION_NO OA Version
wi_id MPE_WI_ID Work Instruction
wi_version_no MPE_WI_VERSION_NO Version No.
created_by MPE_CREATE_USER Created By
created_at MPE_CREATE_TIMESTAMP Created On
changed_by MPE_LCHANGE_USER Changed By
changed_at MPE_LCHANGE_TIMESTAMP Changed On

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.

-- Work Instruction Assignment to Operation Activities
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MPE_OA_WI (
    MANDT,          -- Client [MANDT]
    OA_ID,          -- Operation Activity [MPE_OA_ID]
    OA_VERSION_NO,  -- OA Version [MPE_OA_VERSION_NO]
    WI_ID,          -- Work Instruction [MPE_WI_ID]
    WI_VERSION_NO,  -- Version No. [MPE_WI_VERSION_NO]
    CREATED_BY,     -- Created By [MPE_CREATE_USER]
    CREATED_AT,     -- Created On [MPE_CREATE_TIMESTAMP]
    CHANGED_BY,     -- Changed By [MPE_LCHANGE_USER]
    CHANGED_AT,     -- Changed On [MPE_LCHANGE_TIMESTAMP]
    PRIMARY KEY (MANDT, OA_ID, OA_VERSION_NO)
);

Learn More