MPE_OA_CER

Transparent Table Application Table
5 Fields 1 CDS Views

OBSOLETE: Certificate Assignment to Operation Activities

MPE_OA_CER is an SAP database table in S/4HANA. OBSOLETE: Certificate Assignment to Operation Activities. It contains 5 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_OpActyCertificateAssignment view from BASIC Op. Acty. Certificate Assignment

Fields (5)

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 certificateid mpe_cer_cerid Certification
requiredskillevel mpe_cer_sl SkillLevel

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.

-- OBSOLETE: Certificate 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_CER (
    MANDT,              -- Client [mandt]
    OA_ID,              -- Operation Activity [mpe_oa_id]
    OA_VERSION_NO,      -- OA Version [mpe_oa_version_no]
    CERTIFICATEID,      -- Certification [mpe_cer_cerid]
    REQUIREDSKILLEVEL,  -- SkillLevel [mpe_cer_sl]
    PRIMARY KEY (MANDT, OA_ID, OA_VERSION_NO, CERTIFICATEID)
);

Learn More