MPE_OA_PRT

Transparent Table Application Table
11 Fields 2 CDS Views

Production Resources/Tools Assignment to Operation Act.

MPE_OA_PRT is an SAP database table in S/4HANA. Production Resources/Tools Assignment to Operation Act.. It contains 11 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_MfgWorkInstructionVarblInfo view left_outer BASIC Work Instruction Referred Variables
I_OpActyBOOProdnRsceToolAssgmt view from BASIC Op. Acty. BOO Op. Prod. Resource/Tool Assgmt

Fields (11)

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
KEY plnty PLNTY Task List Type
KEY plnnr PLNNR Group
KEY pzlfh PZLFH PRT Item Count.
is_referenced_in_cha MPE_IS_REFERENCED_IN_CHA Test Equipment
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.

-- Production Resources/Tools Assignment to Operation Act.
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MPE_OA_PRT (
    MANDT,                 -- Client [MANDT]
    OA_ID,                 -- Operation Activity [MPE_OA_ID]
    OA_VERSION_NO,         -- OA Version [MPE_OA_VERSION_NO]
    PLNTY,                 -- Task List Type [PLNTY]
    PLNNR,                 -- Group [PLNNR]
    PZLFH,                 -- PRT Item Count. [PZLFH]
    IS_REFERENCED_IN_CHA,  -- Test Equipment [MPE_IS_REFERENCED_IN_CHA]
    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, PLNTY, PLNNR, PZLFH)
);

Learn More