SFI_ID in MPE_SFI_STATUS
Serial.Mat. ID (DE: ID serial. Mat.)
SFI_ID is a field in SAP table MPE_SFI_STATUS (MPE SFI Status on OAN). It represents "Serial.Mat. ID". Data element: MPE_SFI_ID. Available in 57 CDS view(s) as ShopFloorItem, AssemblyShopFloorItem.
Business Meaning
| Description (EN) | Serial.Mat. ID |
|---|---|
| Beschreibung (DE) | ID serial. Mat. |
| Data Element | MPE_SFI_ID |
| Key Field | Yes |
CDS Views & Technical Names (57)
MPE_SFI_STATUS.SFI_ID is exposed in CDS views under the following technical names. Views reading the table directly are listed first; "via" marks views that pass the field on through intermediate views.
ShopFloorItem
(44 views)
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| I_ShopFloorItemStatus | direct | BASIC | Shop Floor Item Status | |
| C_OpActyInstcePlndSerialNumber | via 2 level | CONSUMPTION | Plnd Serial Number at OA Instance | |
| C_ShopFloorItemAtOpActyVH | via 2 level | CONSUMPTION | Shop floor items at operation activity | |
| C_ShopFloorItemSkippedOpActy | via 2 level | CONSUMPTION | Shop Floor Item Skipped OA | |
| I_ActiveShopFloorItemAtOpActy | via 2 level | BASIC | Active shop floor item at operation activity | |
| I_SFIAtOpActyForBackflush | via 2 level | COMPOSITE | SFI at OA relevant for Backflush | |
| I_SFIAtOpActyForBkflshBasic | via 2 level | COMPOSITE | SFI at OA relevant for Backflush | |
| I_SFIAtOpActyInspCharcInfo | via 2 level | COMPOSITE | IC info of SFI at OAI | |
| I_ShopFloorItemAtOpActy | via 2 level | COMPOSITE | Shop Floor Item At Operation Activity | |
| P_ActvCmpltdSFIGroupMember | via 2 level | CONSUMPTION | ||
| P_MfgOrderOpSFIAggrgdStsCat | via 2 level | COMPOSITE | ||
| P_MfgOrdOpActiveInQueueSFI | via 2 level | COMPOSITE | ||
| P_MfgOrdOpNotInitialSFI | via 2 level | COMPOSITE | ||
| P_OriglRplcdSFIOpActyStatus | via 2 level | CONSUMPTION | ||
| P_SFIAtOANotValdForGrpCopy | via 2 level | CONSUMPTION | ||
| P_SFIAtOpActyCompForBackflush | via 2 level | CONSUMPTION | ||
| P_SFIAtOpActyPlndMatlRetQts | via 2 level | CONSUMPTION | ||
| P_SFIAtOpActyTestEquipPRTUnion | via 2 level | CONSUMPTION | ||
| P_SFIAtOperationActivityBasic | via 2 level | COMPOSITE | ||
| P_SFICompletedOpActy | via 2 level | COMPOSITE | ||
| P_SFINotAssldTrcblComponent1 | via 2 level | COMPOSITE | SFI Not Assembled Traceable Components | |
| P_SFIOperationActivityPlndPRT | via 2 level | CONSUMPTION | ||
| P_ShopFloorItemAtOpActyComp | via 2 level | CONSUMPTION | ||
| C_MfgOrderOpSFIAggrgdStsCat | via 3 levels | CONSUMPTION | Aggregated SFI Status for Operation | |
| C_SFIAtOpActyInspCharcInfo | via 3 levels | CONSUMPTION | SFI with operation activity instances | |
| I_ActvShopFloorItemAtOpActyVH | via 3 levels | COMPOSITE | Active shop floor items at operation activity | |
| I_MfgOrdOpActiveInitialSFI | via 3 levels | COMPOSITE | Active and initial SFI at an Operation | |
| I_SFIAtOperationActivityBasic | via 3 levels | COMPOSITE | Basic data of a Shop Floor Item at an Operation Activity | |
| I_SFIOpActyNonTrcblUsedPRT | via 3 levels | COMPOSITE | SFI used non traceable PRT | |
| P_RplcdSFIAtOpActyCompForBckfl | via 3 levels | CONSUMPTION | ||
| P_RplcdSFIAtOpActyForBkflshBsc | via 3 levels | CONSUMPTION | ||
| P_SFIAtOpActyPlndMatlRet | via 3 levels | CONSUMPTION | ||
| P_SFINotAssldTrcblComponent | via 3 levels | COMPOSITE | SFI Not Assembled Traceable Components | |
| P_SFIOperationActivityPRTUnion | via 3 levels | CONSUMPTION | ||
| P_ShopFloorItemAtOpActyComp2 | via 3 levels | CONSUMPTION | ||
| C_SFIAtOpActyPlndMatlRet | via 4 levels | CONSUMPTION | Shop Floor Item At OA Planned Material Return | |
| C_ShopFloorItemAtOpActyComp | via 4 levels | CONSUMPTION | Shop Floor Item At OA Component | |
| P_MfgOrdOpSerialNumberForSplit | via 4 levels | CONSUMPTION | Serial Number that can be split at an Order Operation | |
| P_SFIBkflshdDsassldComp | via 4 levels | CONSUMPTION | ||
| P_SFIBkflshdTmpDsassldComp | via 4 levels | CONSUMPTION | ||
| P_SFIOperationActivityPRT | via 4 levels | CONSUMPTION | ||
| C_MfgOrdOpSerialNumberForSplit | via 5 levels | CONSUMPTION | Active and initial SFI at an Operation | |
| C_SFIOpActyPRTAssignment | via 5 levels | CONSUMPTION | ||
| P_SFIBkflshdTmpDsassldCompQty | via 5 levels | CONSUMPTION |
AssemblyShopFloorItem
(13 views)
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| P_SFIAssembledComponent | via 2 level | CONSUMPTION | ||
| P_SFIAtOpActyBckflshByOrigComp | via 2 level | COMPOSITE | ||
| P_ShopFloorItemComponent | via 2 level | CONSUMPTION | ||
| P_SFIAssembledComponent2 | via 3 levels | CONSUMPTION | ||
| C_SFIAssembledComponent | via 4 levels | CONSUMPTION | Component Assembled into a SFI (Manual and Backflushed) | |
| I_SFINotAssldTrcblComponent | via 4 levels | COMPOSITE | SFI Not Assembled Traceable Components | |
| P_SFIAssldNonTrcblCompByLdngRe | via 4 levels | CONSUMPTION | ||
| P_SFIDsassldNonTrcblComponent | via 4 levels | CONSUMPTION | ||
| C_SFIDsassldNonTrcblComponent | via 5 levels | CONSUMPTION | SFI disassembled non traceable component | |
| P_SFIDsassldNonTrcblCompUnion | via 5 levels | CONSUMPTION | ||
| P_SFINonTrcblComponentAssembly | via 5 levels | CONSUMPTION | ||
| C_SFIAssldNonTrcblComponent | via 6 levels | CONSUMPTION | SFI assembled non traceable component | |
| C_SFIRetdNonTraceableMaterial | via 6 levels | CONSUMPTION | Obsolete SFI returned non traceable mat |
Other Tables with Field SFI_ID (15)
| Table | Data Element | Key | Description |
|---|---|---|---|
| AFFW | MPE_SFI_ID | Goods Movements with Errors from Confirmations | |
| MPE_ASSY_CRRTN | MPE_SFI_ID | Component Assembly Correction | |
| MPE_BOM_PS_REL | MPE_SFI_ID | KEY | Serialized Product for End Item and Major Assembly |
| MPE_COMP_ASSEMBL | MPE_ASSEMBLED_SFI_ID | Component Assembly | |
| MPE_EXEC_HOLD | MPE_SFI_ID | Production Hold | |
| MPE_EXEC_HOLD_SO | MPE_SFI_ID | KEY | SFI@OA affected when a Production Hold was applied |
| MPE_OAI_EQUI_REG | MPE_SFI_ID | Equipment Registration during OA Execution | |
| MPE_OAI_LBR_ACTN | MPE_SFI_ID | Labor action of users during OA execution | |
| MPE_OAI_PRT_REG | MPE_SFI_ID | PRT Registration during OA Execution | |
| MPE_OBJECT_LOG | MPE_SFI_ID | Log for Buisness Objects | |
| MPE_SFI | MPE_SFI_ID | KEY | Shop Floor Item |
| MPE_SFI_CONFIRM | MPE_SFI_ID | MPE SFI Confirmations (History of SFI Execution) | |
| MPE_SFI_RWRK_OP | MPE_SFI_ID | KEY | Rework Operation to be executed for a shop floor item |
| MPE_TT_CLAIM_OA | MPE_SFI_ID | Tool Tracking: OAs | |
| QAPP | MPE_SFI_ID | Inspection point |
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA