MPE_OAI_LBR_ACTN

Transparent Table Application Table
24 Fields 1 CDS Views

Labor action of users during OA execution

MPE_OAI_LBR_ACTN is an SAP database table in S/4HANA. Labor action of users during OA execution. It contains 24 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_OpActyLaborAction view from BASIC Labor action at operation activity

Fields (24)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY doc_nmbr mpe_doc_nmbr Document Number
oan_instance_id mpe_oan_instance_id Instance ID
oan_element_number mpe_oan_element_number Element Number
sfi_id mpe_sfi_id Serial.Mat. ID
exec_user mpe_user User
sfi_at_oai_group_id mpe_sfi_at_oai_group_id Serial Number Group
action_type mpe_labor_action_type Action
action_time mpe_oac_actn_time Executed On
created_by mpe_create_user Created By
created_at mpe_create_timestampl Created On
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)
reltd_doc_nmbr mpe_reltd_doc_nmbr Related Document
actl_exec_duration mpe_actl_exec_labor_duration Actual Time (s)
is_posted_retroactively mpe_is_posted_retroactively Retroactive Action
katalogart qkatart Catalog
codegruppe qcodegrp Code Group
code qcode Code
version qversnr Version
is_trggrd_implicitly mpe_is_triggered_implicitly Triggered Implicitly
trggrd_by_doc_cat mpe_exec_triggered_by_doc_cat Document Category
trggrd_by_doc_nmbr mpe_exec_triggered_by_doc Document Number

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.

-- Labor action of users during OA execution
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MPE_OAI_LBR_ACTN (
    MANDT,                     -- Client [mandt]
    DOC_NMBR,                  -- Document Number [mpe_doc_nmbr]
    OAN_INSTANCE_ID,           -- Instance ID [mpe_oan_instance_id]
    OAN_ELEMENT_NUMBER,        -- Element Number [mpe_oan_element_number]
    SFI_ID,                    -- Serial.Mat. ID [mpe_sfi_id]
    EXEC_USER,                 -- User [mpe_user]
    SFI_AT_OAI_GROUP_ID,       -- Serial Number Group [mpe_sfi_at_oai_group_id]
    ACTION_TYPE,               -- Action [mpe_labor_action_type]
    ACTION_TIME,               -- Executed On [mpe_oac_actn_time]
    CREATED_BY,                -- Created By [mpe_create_user]
    CREATED_AT,                -- Created On [mpe_create_timestampl]
    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]
    RELTD_DOC_NMBR,            -- Related Document [mpe_reltd_doc_nmbr]
    ACTL_EXEC_DURATION,        -- Actual Time (s) [mpe_actl_exec_labor_duration]
    IS_POSTED_RETROACTIVELY,   -- Retroactive Action [mpe_is_posted_retroactively]
    KATALOGART,                -- Catalog [qkatart]
    CODEGRUPPE,                -- Code Group [qcodegrp]
    CODE,                      -- Code [qcode]
    VERSION,                   -- Version [qversnr]
    IS_TRGGRD_IMPLICITLY,      -- Triggered Implicitly [mpe_is_triggered_implicitly]
    TRGGRD_BY_DOC_CAT,         -- Document Category [mpe_exec_triggered_by_doc_cat]
    TRGGRD_BY_DOC_NMBR,        -- Document Number [mpe_exec_triggered_by_doc]
    PRIMARY KEY (MANDT, DOC_NMBR)
);

Learn More