MPE_OA

Transparent Table Application Table
15 Fields 3 CDS Views

Operation Activity

MPE_OA is an SAP database table in S/4HANA. Operation Activity. It contains 15 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
E_OperationActivity view from EXTENSION Operation Activity - Extension
I_OperationActivity view from BASIC Operation Activity
V_SFIAtOpActyMissingStatus view inner

Fields (15)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY id mpe_oa_id Operation Activity
KEY version_no mpe_oa_version_no OA Version
activity_sasname mpe_sasname_oa SAS for Op. Activity
sfi_sasname mpe_sasname_sfioa SAS Serialized Prod.
released mpe_released_type Released
process_sequence mpe_rtgv_proc_seq Assembly Sequence
fav_guid sysuuid_c32 UUID
fav_versn mpe_rtg_template_versn Template Versn
fav_guid_old sysuuid_c32 UUID
fav_versn_old mpe_rtg_template_versn Template Versn
source_oa_id mpe_source_oa_id Source OA ID
original_count mpe_ca_original_count Change Alert Count
versn_origin_routing mpe_template_object_origin Origin
extended_quality_checks mpe_rtg_eqc_rel Relevant for EQC

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.

-- Operation Activity
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MPE_OA (
    MANDT,                    -- Client [mandt]
    ID,                       -- Operation Activity [mpe_oa_id]
    VERSION_NO,               -- OA Version [mpe_oa_version_no]
    ACTIVITY_SASNAME,         -- SAS for Op. Activity [mpe_sasname_oa]
    SFI_SASNAME,              -- SAS Serialized Prod. [mpe_sasname_sfioa]
    RELEASED,                 -- Released [mpe_released_type]
    PROCESS_SEQUENCE,         -- Assembly Sequence [mpe_rtgv_proc_seq]
    FAV_GUID,                 -- UUID [sysuuid_c32]
    FAV_VERSN,                -- Template Versn [mpe_rtg_template_versn]
    FAV_GUID_OLD,             -- UUID [sysuuid_c32]
    FAV_VERSN_OLD,            -- Template Versn [mpe_rtg_template_versn]
    SOURCE_OA_ID,             -- Source OA ID [mpe_source_oa_id]
    ORIGINAL_COUNT,           -- Change Alert Count [mpe_ca_original_count]
    VERSN_ORIGIN_ROUTING,     -- Origin [mpe_template_object_origin]
    EXTENDED_QUALITY_CHECKS,  -- Relevant for EQC [mpe_rtg_eqc_rel]
    PRIMARY KEY (MANDT, ID, VERSION_NO)
);

Learn More