MPE_PRT_OAI

Transparent Table Application Table
6 Fields 1 CDS Views

Production Resources/Tools Assignment to Oper. Act. Instance

MPE_PRT_OAI is an SAP database table in S/4HANA. Production Resources/Tools Assignment to Oper. Act. Instance. It contains 6 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_OperationActyPRTAssignment view from BASIC Operation Activity Instance PRT Assign

Fields (6)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY aufpl CO_AUFPL Plan No.f.Oper.
KEY pzlfh PZLFH PRT Item Count.
KEY oan_instance_id MPE_OAN_INSTANCE_ID Instance ID
KEY oan_element_number MPE_OAN_ELEMENT_NUMBER Element Number
is_referenced_in_cha MPE_IS_REFERENCED_IN_CHA Test Equipment

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 Oper. Act. Instance
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MPE_PRT_OAI (
    MANDT,                 -- Client [MANDT]
    AUFPL,                 -- Plan No.f.Oper. [CO_AUFPL]
    PZLFH,                 -- PRT Item Count. [PZLFH]
    OAN_INSTANCE_ID,       -- Instance ID [MPE_OAN_INSTANCE_ID]
    OAN_ELEMENT_NUMBER,    -- Element Number [MPE_OAN_ELEMENT_NUMBER]
    IS_REFERENCED_IN_CHA,  -- Test Equipment [MPE_IS_REFERENCED_IN_CHA]
    PRIMARY KEY (MANDT, AUFPL, PZLFH, OAN_INSTANCE_ID, OAN_ELEMENT_NUMBER)
);

Learn More