MPE_OA_COMP

Transparent Table Application Table
15 Fields 3 CDS Views

Component Assignment to Operation Activities

MPE_OA_COMP is an SAP database table in S/4HANA. Component Assignment to Operation Activities. It contains 15 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_MfgWorkInstructionVarblInfo view left_outer BASIC Work Instruction Referred Variables
I_OpActyBOOOpBOMItmAssgmt view from BASIC Op. Acty. BOO Op. BOM Item Assgmt
I_ProdnModOpActyCompBasic view_entity inner BASIC OAC Keys and basic data

Fields (15)

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 zuonr CIM_ZUORD Allocation no.
quantity KMPMG Quantity
base_uom KMPME Component UoM
is_output MPE_IS_OUTPUT Output indicator
sequence_no MPE_RTGV_PROC_SEQ_NO Assembly Sequence
instance_assembly_rqd MPE_INSTCE_ASSEMBLY_RQD Instance assembly
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.

-- Component 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_COMP (
    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]
    ZUONR,                  -- Allocation no. [CIM_ZUORD]
    QUANTITY,               -- Quantity [KMPMG]
    BASE_UOM,               -- Component UoM [KMPME]
    IS_OUTPUT,              -- Output indicator [MPE_IS_OUTPUT]
    SEQUENCE_NO,            -- Assembly Sequence [MPE_RTGV_PROC_SEQ_NO]
    INSTANCE_ASSEMBLY_RQD,  -- Instance assembly [MPE_INSTCE_ASSEMBLY_RQD]
    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, ZUONR)
);

Learn More