MPE_OAC

Transparent Table Application Table
25 Fields 1 CDS Views

Operation Activity Confirmation

MPE_OAC is an SAP database table in S/4HANA. Operation Activity Confirmation. It contains 25 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_OpActyConfirmation view from BASIC Operation Activity Confirmation

Fields (25)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY doc_nmbr mpe_oac_doc_nmbr Document Number
oan_instance_id mpe_oan_instance_id Instance ID
oan_element_number mpe_oan_element_number Element Number
oac_type mpe_oac_type Conf. Record Type
sas_action_name mpe_action_name_type Action
action_user ru_ernam Entered by User
action_time mpe_oac_actn_time Executed On
crtn_user mpe_create_user Created By
crtn_time mpe_oac_crtn_time Created On
yield ru_lmnga Yield Quantity
scrap mpe_scrap_frm_prcssg Scrap in Process
scrap_bfr_strt mpe_scrap_bfr_strt Scrap in Queue
skip_qty mpe_skip_qty Skipped Qty
uom ru_vorme Confirmation Unit
umren umren Denominator
umrez umrez Numerator
pdsnr pdsnr_d Number
trggrd_by_doc_nmbr mpe_exec_triggered_by_doc Document Number
gross_duration mpe_gross_duration Duration (Calendar)
net_calendar_duration mpe_net_calendar_duration Duration (Work Days)
net_work_center_duration mpe_net_work_center_duration Duration (Op. Time)
actl_exec_duration mpe_actl_exec_duration Actual Time (s)
is_posted_retroactively mpe_is_posted_retroactively Retroactive Action
auto_creation_code mpe_oac_auto_creation_code Origin of OA Conf.

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 Confirmation
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MPE_OAC (
    MANDT,                     -- Client [mandt]
    DOC_NMBR,                  -- Document Number [mpe_oac_doc_nmbr]
    OAN_INSTANCE_ID,           -- Instance ID [mpe_oan_instance_id]
    OAN_ELEMENT_NUMBER,        -- Element Number [mpe_oan_element_number]
    OAC_TYPE,                  -- Conf. Record Type [mpe_oac_type]
    SAS_ACTION_NAME,           -- Action [mpe_action_name_type]
    ACTION_USER,               -- Entered by User [ru_ernam]
    ACTION_TIME,               -- Executed On [mpe_oac_actn_time]
    CRTN_USER,                 -- Created By [mpe_create_user]
    CRTN_TIME,                 -- Created On [mpe_oac_crtn_time]
    YIELD,                     -- Yield Quantity [ru_lmnga]
    SCRAP,                     -- Scrap in Process [mpe_scrap_frm_prcssg]
    SCRAP_BFR_STRT,            -- Scrap in Queue [mpe_scrap_bfr_strt]
    SKIP_QTY,                  -- Skipped Qty [mpe_skip_qty]
    UOM,                       -- Confirmation Unit [ru_vorme]
    UMREN,                     -- Denominator [umren]
    UMREZ,                     -- Numerator [umrez]
    PDSNR,                     -- Number [pdsnr_d]
    TRGGRD_BY_DOC_NMBR,        -- Document Number [mpe_exec_triggered_by_doc]
    GROSS_DURATION,            -- Duration (Calendar) [mpe_gross_duration]
    NET_CALENDAR_DURATION,     -- Duration (Work Days) [mpe_net_calendar_duration]
    NET_WORK_CENTER_DURATION,  -- Duration (Op. Time) [mpe_net_work_center_duration]
    ACTL_EXEC_DURATION,        -- Actual Time (s) [mpe_actl_exec_duration]
    IS_POSTED_RETROACTIVELY,   -- Retroactive Action [mpe_is_posted_retroactively]
    AUTO_CREATION_CODE,        -- Origin of OA Conf. [mpe_oac_auto_creation_code]
    PRIMARY KEY (MANDT, DOC_NMBR)
);

Learn More