MPE_OAI_ASS_TEAM

Transparent Table Application Table
9 Fields 1 CDS Views

Team to Operation Activity Instance Assignment

MPE_OAI_ASS_TEAM is an SAP database table in S/4HANA. Team to Operation Activity Instance Assignment. It contains 9 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_OpActyRespyMgmtTeamAssgmtBsc view from BASIC Team to Operation Acty Instance Assgmt

Fields (9)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY oan_instance_id MPE_OAN_INSTANCE_ID Instance ID
KEY oan_element_number MPE_OAN_ELEMENT_NUMBER Element Number
KEY respymgmtteamid MPE_TEAM_ID Team
created_by MPE_CREATE_USER Created By
created_at MPE_CREATE_TIMESTAMP Created On
oa_exec_prio MPE_OA_EXEC_PRIO Execution Priority
changed_by MPE_CHANGE_BY Changed By
changed_at MPE_CHANGE_AT_TIMESTAMP Changed At

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.

-- Team to Operation Activity Instance Assignment
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MPE_OAI_ASS_TEAM (
    MANDT,               -- Client [MANDT]
    OAN_INSTANCE_ID,     -- Instance ID [MPE_OAN_INSTANCE_ID]
    OAN_ELEMENT_NUMBER,  -- Element Number [MPE_OAN_ELEMENT_NUMBER]
    RESPYMGMTTEAMID,     -- Team [MPE_TEAM_ID]
    CREATED_BY,          -- Created By [MPE_CREATE_USER]
    CREATED_AT,          -- Created On [MPE_CREATE_TIMESTAMP]
    OA_EXEC_PRIO,        -- Execution Priority [MPE_OA_EXEC_PRIO]
    CHANGED_BY,          -- Changed By [MPE_CHANGE_BY]
    CHANGED_AT,          -- Changed At [MPE_CHANGE_AT_TIMESTAMP]
    PRIMARY KEY (MANDT, OAN_INSTANCE_ID, OAN_ELEMENT_NUMBER, RESPYMGMTTEAMID)
);

Learn More