MPE_CMP_OAI_INST

Transparent Table Application Table
12 Fields 1 CDS Views

Instances for Components at Operation Activity Instances

MPE_CMP_OAI_INST is an SAP database table in S/4HANA. Instances for Components at Operation Activity Instances. It contains 12 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_OpActyCompInstceAssignment view from BASIC Assignment of component instance to operation activity

Fields (12)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY rsnum RSNUM Reservation
KEY rspos RSPOS Item no.
KEY rsart RSART Record type
KEY oan_instance_id MPE_OAN_INSTANCE_ID Instance ID
KEY oan_element_number MPE_OAN_ELEMENT_NUMBER Element Number
KEY inst_guid DMU_GUID16 DMU GUID
tmxguid DMU_GUID16 DMU GUID
inst_guid_reference DMU_GUID16 DMU GUID
mrs_leaf_assignment_uuid MPE_MRS_LEAF_ASSIGNMENT_UUID Leaf Assignment UUID
mrs_item_detail_uuid MPE_MRS_ITEM_UUID MRS Item UUID
mrs_item_detail_is_contextual MPE_MRS_ITEM_DET_IS_CONTEXTUAL Contextual

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.

-- Instances for Components at Operation Activity Instances
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MPE_CMP_OAI_INST (
    MANDT,                          -- Client [MANDT]
    RSNUM,                          -- Reservation [RSNUM]
    RSPOS,                          -- Item no. [RSPOS]
    RSART,                          -- Record type [RSART]
    OAN_INSTANCE_ID,                -- Instance ID [MPE_OAN_INSTANCE_ID]
    OAN_ELEMENT_NUMBER,             -- Element Number [MPE_OAN_ELEMENT_NUMBER]
    INST_GUID,                      -- DMU GUID [DMU_GUID16]
    TMXGUID,                        -- DMU GUID [DMU_GUID16]
    INST_GUID_REFERENCE,            -- DMU GUID [DMU_GUID16]
    MRS_LEAF_ASSIGNMENT_UUID,       -- Leaf Assignment UUID [MPE_MRS_LEAF_ASSIGNMENT_UUID]
    MRS_ITEM_DETAIL_UUID,           -- MRS Item UUID [MPE_MRS_ITEM_UUID]
    MRS_ITEM_DETAIL_IS_CONTEXTUAL,  -- Contextual [MPE_MRS_ITEM_DET_IS_CONTEXTUAL]
    PRIMARY KEY (MANDT, RSNUM, RSPOS, RSART, OAN_INSTANCE_ID, OAN_ELEMENT_NUMBER, INST_GUID)
);

Learn More