MPE_SFI_CONFIRM

Transparent Table Application Table
28 Fields 1 CDS Views

MPE SFI Confirmations (History of SFI Execution)

MPE_SFI_CONFIRM is an SAP database table in S/4HANA. MPE SFI Confirmations (History of SFI Execution). It contains 28 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_ShopFloorItemConfirmation view from BASIC Shop Floor Item Confirmation

Fields (28)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY document_number mpe_sfi_confirm_document_num Document Number
sfi_id mpe_sfi_id Serial.Mat. ID
oan_instance_id mpe_oan_instance_id Instance ID
oan_element_number mpe_oan_element_number Element Number
sfi_at_oai_group_id mpe_sfi_at_oai_group_id Serial Number Group
sasname mpe_sasname_type Status Action Schema
sasstartstatusname mpe_sfi_status_type Status
sasendstatusname mpe_sfi_status_type Status
sasstatusduration mpe_gross_duration Duration (Calendar)
sasstatusdurationpp mpe_net_work_center_duration Duration (Op. Time)
sasstatusdurationts mpe_duration Duration
actl_exec_duration mpe_actl_exec_duration Actual Time (s)
sasactionname mpe_action_name_type Action
document_type mpe_sfi_confirmation_doc_type Document Type
katalogart qkatart Catalog
codegruppe qcodegrp Code Group
code qcode Code
version qversnr Version
created_at mpe_create_timestampl Created On
created_by mpe_create_user Created By
eventtime mpe_timestampl Time Stamp
eventuser mpe_aenam_type Changed By
endtime mpe_timestampl Time Stamp
is_posted_retroactively mpe_is_posted_retroactively Retroactive Action
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)

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.

-- MPE SFI Confirmations (History of SFI Execution)
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MPE_SFI_CONFIRM (
    MANDT,                     -- Client [mandt]
    DOCUMENT_NUMBER,           -- Document Number [mpe_sfi_confirm_document_num]
    SFI_ID,                    -- Serial.Mat. ID [mpe_sfi_id]
    OAN_INSTANCE_ID,           -- Instance ID [mpe_oan_instance_id]
    OAN_ELEMENT_NUMBER,        -- Element Number [mpe_oan_element_number]
    SFI_AT_OAI_GROUP_ID,       -- Serial Number Group [mpe_sfi_at_oai_group_id]
    SASNAME,                   -- Status Action Schema [mpe_sasname_type]
    SASSTARTSTATUSNAME,        -- Status [mpe_sfi_status_type]
    SASENDSTATUSNAME,          -- Status [mpe_sfi_status_type]
    SASSTATUSDURATION,         -- Duration (Calendar) [mpe_gross_duration]
    SASSTATUSDURATIONPP,       -- Duration (Op. Time) [mpe_net_work_center_duration]
    SASSTATUSDURATIONTS,       -- Duration [mpe_duration]
    ACTL_EXEC_DURATION,        -- Actual Time (s) [mpe_actl_exec_duration]
    SASACTIONNAME,             -- Action [mpe_action_name_type]
    DOCUMENT_TYPE,             -- Document Type [mpe_sfi_confirmation_doc_type]
    KATALOGART,                -- Catalog [qkatart]
    CODEGRUPPE,                -- Code Group [qcodegrp]
    CODE,                      -- Code [qcode]
    VERSION,                   -- Version [qversnr]
    CREATED_AT,                -- Created On [mpe_create_timestampl]
    CREATED_BY,                -- Created By [mpe_create_user]
    EVENTTIME,                 -- Time Stamp [mpe_timestampl]
    EVENTUSER,                 -- Changed By [mpe_aenam_type]
    ENDTIME,                   -- Time Stamp [mpe_timestampl]
    IS_POSTED_RETROACTIVELY,   -- Retroactive Action [mpe_is_posted_retroactively]
    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]
    PRIMARY KEY (MANDT, DOCUMENT_NUMBER)
);

Learn More