MPE_SFI_CONFIRM - MPE SFI Confirmations (History of SFI Execution)
MPE SFI Confirmations (History of SFI Execution) information is stored in SAP table MPE_SFI_CONFIRM.
It is part of development package MPE_EXEC_SFI in software component PP-PEO-SFE. This development package consists of objects that can be grouped under "Manufacturing Execution - Shop Floor Item".
It is part of development package MPE_EXEC_SFI in software component PP-PEO-SFE. This development package consists of objects that can be grouped under "Manufacturing Execution - Shop Floor Item".
Fields for table MPE_SFI_CONFIRM
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
---|---|---|---|---|---|---|
MANDT | Client | X | MANDT | CLNT | 6 | T000 |
DOCUMENT_NUMBER | SFI Confirmation - Document Number | X | MPE_SFI_CONFIRM_DOCUMENT_NUM | INT8 | 8 | |
SFI_ID | ID of Serialized Material | MPE_SFI_ID | INT8 | 8 | ||
OAN_INSTANCE_ID | Operation Activity Network: Instance ID | MPE_OAN_INSTANCE_ID | INT4 | 4 | ||
OAN_ELEMENT_NUMBER | Internal OAN Element Number | MPE_OAN_ELEMENT_NUMBER | INT4 | 4 | ||
SASNAME | Status and Action Schema | MPE_SASNAME_TYPE | CHAR | 80 | ||
SASSTARTSTATUSNAME | Serial Number Status | MPE_SFI_STATUS_TYPE | CHAR | 80 | ||
SASENDSTATUSNAME | Serial Number Status | MPE_SFI_STATUS_TYPE | CHAR | 80 | ||
SASSTATUSDURATION | Duration Based on Calendar Days | MPE_GROSS_DURATION | INT4 | 4 | ||
SASSTATUSDURATIONPP | Duration Based on Operating Times of Work Center | MPE_NET_WORK_CENTER_DURATION | INT4 | 4 | ||
SASSTATUSDURATIONTS | Duration | MPE_DURATION | INT4 | 4 | ||
ACTL_EXEC_DURATION | Actual Execution Time of an Operation Activity (Seconds) | MPE_ACTL_EXEC_DURATION | INT4 | 4 | ||
SASACTIONNAME | Action of a Status and Action Schema | MPE_ACTION_NAME_TYPE | CHAR | 80 | ||
DOCUMENT_TYPE | SFI Confirmation - Document Type | MPE_SFI_CONFIRMATION_DOC_TYPE | INT2 | 2 | ||
KATALOGART | Catalog | QKATART | CHAR | 2 | ||
CODEGRUPPE | Code Group | QCODEGRP | CHAR | 16 | ||
CODE | Code | QCODE | CHAR | 8 | ||
VERSION | Version Number | QVERSNR | CHAR | 12 | ||
EVENTTIME | UTC Time Stamp in Long Form | MPE_TIMESTAMPL | DEC | 11 | ||
EVENTUSER | Last Changed By | MPE_AENAM_TYPE | CHAR | 24 | ||
ENDTIME | UTC Time Stamp in Long Form | MPE_TIMESTAMPL | DEC | 11 | ||
IS_POSTED_RETROACTIVELY | Retroactive Action | MPE_IS_POSTED_RETROACTIVELY | CHAR | 2 | ||
GROSS_DURATION | Duration Based on Calendar Days | MPE_GROSS_DURATION | INT4 | 4 | ||
NET_CALENDAR_DURATION | Duration Based on Factory Calendar | MPE_NET_CALENDAR_DURATION | INT4 | 4 | ||
NET_WORK_CENTER_DURATION | Duration Based on Operating Times of Work Center | MPE_NET_WORK_CENTER_DURATION | INT4 | 4 |