MPE_OA_PIC

Transparent Table Application Table
16 Fields 2 CDS Views

Inspection Characteristic Assignment to Operation Activities

MPE_OA_PIC is an SAP database table in S/4HANA. Inspection Characteristic Assignment to Operation Activities. It contains 16 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_OpActyBOOCharcAssgmt view from BASIC Op. Acty. Prod. Rtg Insp. Charc. Assgmt

Fields (16)

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 plnkn plnkn Node
KEY merknr qmerknrp Characteristic
item_no mpe_insp_char_item_no Sort No.
group_column_no mpe_group_column_no Group Column No.
division_seq_no mpe_division_seq_no Division Seq No.
zuonr cim_zuord Allocation no.
tmxguid cim_dmu_guid16 DMU GUID
mrs_leaf_asgmt_uuid mpe_mrs_leaf_assignment_uuid Leaf Assignment UUID
char_relevance qp_char_relevance Insp. Relevance
versn_origin_routing mpe_template_object_origin Origin
pic_status mpe_pic_status IC Status

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.

-- Inspection Characteristic 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_PIC (
    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]
    PLNKN,                 -- Node [plnkn]
    MERKNR,                -- Characteristic [qmerknrp]
    ITEM_NO,               -- Sort No. [mpe_insp_char_item_no]
    GROUP_COLUMN_NO,       -- Group Column No. [mpe_group_column_no]
    DIVISION_SEQ_NO,       -- Division Seq No. [mpe_division_seq_no]
    ZUONR,                 -- Allocation no. [cim_zuord]
    TMXGUID,               -- DMU GUID [cim_dmu_guid16]
    MRS_LEAF_ASGMT_UUID,   -- Leaf Assignment UUID [mpe_mrs_leaf_assignment_uuid]
    CHAR_RELEVANCE,        -- Insp. Relevance [qp_char_relevance]
    VERSN_ORIGIN_ROUTING,  -- Origin [mpe_template_object_origin]
    PIC_STATUS,            -- IC Status [mpe_pic_status]
    PRIMARY KEY (MANDT, OA_ID, OA_VERSION_NO, PLNTY, PLNNR, PLNKN, MERKNR)
);

Learn More