MPE_OAI_ASS_USR

Transparent Table Application Table
9 Fields 1 CDS Views

Shop Floor User to Operation Activity Instance Assignment

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

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_OpActyUserAssgmtBasic view from BASIC User 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 exec_user mpe_user User
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.

-- Shop Floor User 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_USR (
    MANDT,               -- Client [mandt]
    OAN_INSTANCE_ID,     -- Instance ID [mpe_oan_instance_id]
    OAN_ELEMENT_NUMBER,  -- Element Number [mpe_oan_element_number]
    EXEC_USER,           -- User [mpe_user]
    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, EXEC_USER)
);

Learn More