- Application Platform (AP)
- Basis Components (BC)
- Business Mobile (MOB)
- Business Network Solutions (BNS)
- Controlling (CO)
- Cross-Application Components (CA)
- Cross-Application Components (CA)
- Customer Relationship Management (CRM)
- Enterprise Contract Management (CM)
- Enterprise Controlling (EC)
- Enterprise information management solutions (EIM)
- Environment, Health, and Safety / Product Compliance (EHS)
- Financial Accounting (FI)
- Financial Services (FS)
- Global Trade Services (SLL)
- Investment Management (IM)
- LOD Components (LOD)
- Legal Content Management (LCM)
- Logistics - General (LO)
- Logistics Execution (LE)
- Materials Management (MM)
- Occasional Platform User (OPU)
- Payroll (PY)
- Personnel Management (PA)
- Plant Maintenance (PM)
- Portfolio and Project Management (PPM)
- Product Lifecycle Management (PLM)
- Production Planning and Control (PP)
- Basic Data (PP-BD)
- Capacity Planning and Finite Sequencing (PP-CFS)
- Capacity Requirements Planning (PP-CRP)
- Demand-Driven Replenishment (PP-DD)
- Enterprise Services (PP-ES)
- Fiori UI for Production Planning and Control (PP-FIO)
- Integration with Manufacturing Execution Systems (PP-MES)
- KANBAN (PP-KAB)
- Manufacturing Engineering Cockpit (PP-PEO)
- Material Requirements Planning (PP-MRP)
- Predictive MRP (PP-PMR)
- Production Orders (PP-SFC)
- Production Planning (PP-MP)
- Production Planning for Process Industries (PP-PI)
- Repetitive Manufacturing (PP-REM)
- Virtual Data Model in PP (PP-VDM)
- Project System (PS)
- Public Sector Management (PSM)
- Purchasing SAP Cloud (PUR)
- Quality Management (QM)
- Real Estate Management (RE)
- SAP Business Warehouse (BW)
- SAP Supplier Lifecycle Management (SLC)
- Sales and Distribution (SD)
- Service (SV)
- Supply Chain Management (SCM)
- Sustainability management (SUS)
- Transportation Management (TM)
C_ShopFloorItemHold
Serial Number Hold
| view: CMPESFIHOLD
| Extraction:
Not supported
| Component: Shop Floor Execution
Tables used:
AFKO, QMFE, MPE_OAN_INSTANCE, MPE_OA_INSTANCE, AFPO, AFVC, MPE_EXEC_HOLD_SO, MPE_EXEC_HOLD_A, MPE_EXEC_HOLD, QPCD, QPCT, AUFK, MARA, MAKT, QPCD, QPGR, QPCT, MPE_OA_T, MPE_SFI, CRHD, MPE_OAN_ELEMENT
- 🔑 Keys (4)
- 💰 Amounts
- ∑ Quantities
- 📅 Dates
- ☰ Categorical (3)
- Other (29)
- 🔗 Relations (2)
| Column Name | Description | |
|---|---|---|
| ShopFloorItem | ID of Serialized Material | |
| ProductionHold | Number of Production Hold | |
| OpActyNtwkInstance | Operation Activity Network: Instance ID | |
| OpActyNtwkElement | Internal OAN Element Number |
| Column Name | Description |
|---|
| Column Name | Description |
|---|
| Column Name | Description |
|---|
| Column Name | Description | |
|---|---|---|
| ProductionHoldObjectType | Hold Object Type for Manage Production Hold App | Show values |
| ProductionHoldStatus | Status of Production Hold | Show values |
| DefectLifecycleStatus | Defect Status | Show values |
| Column Name | Description | Domain name | |
|---|---|---|---|
| OriginalReplacedShopFloorItem | ID of Originally Replaced Serialized Material | ||
| SerialNumber | Serial Number | GERNR | |
| Material | Material Number | MATNR | |
| MaterialName | Material Description | TEXT40 | |
| ProductionHoldObjectTypeName | Short Text for Fixed Values | DDTEXT | |
| ProdnHoldApplyRsnCodeGrpCtlg | MPE Hold Apply Catalog | QKATART | |
| ProdnHoldApplyRsnCodeGroup | Reason Code Group for Putting on Hold | QCODEGRP | |
| ProductionHoldApplyReasonCode | Reason for Hold | QCODE | |
| ProdnHoldApplyReasonCodeName | Short Text for Code | QKURZTEXT | |
| ProductionHoldAppliedByUser | Put on Hold by | USNAM | |
| ProductionHoldStartDateTime | Date/Time Put on Hold | TZNTSTMPS | |
| ProductionHoldReleasedByUser | Hold Released By | USNAM | |
| ProductionHoldEndDateTime | Date and Time at Which the Release Was Performed | TZNTSTMPS | |
| ProductionHoldStatusName | Short Text for Fixed Values | DDTEXT | |
| StatusCriticality | null | ||
| DefectInternalID | Internal Defect ID | QDEFECTINTERNALID | |
| Notification | Notification Number | QMNUM | |
| NotificationItem | Item Number in Item Record | FELFD | |
| DefectCode | Defect Code | QCODE | |
| DefectCodeText | Text for Defect Code | QKURZTEXT | |
| DefectLifecycleStatusText | Defect Status Text | VDM_QM_TEXT60 | |
| ManufacturingOrder | Order number | AUFNR | |
| OrderInternalID | Routing number of operations in the order | AUFPL | |
| OrderOperationInternalID | General counter for order | CO_APLZL | |
| ManufacturingOrderSequence | Manufacturing Order Sequence | PLNFOLGE | |
| ManufacturingOrderOperation | Operation of Serial Number when Hold was Applied | VORNR | |
| MfgOrderOperationText | Manufacturing Order Operation Text | TEXT40 | |
| OperationActivityName | Operation Activity Description | MPE_OAN_OBJECT_DESCRIPTION | |
| OpActyNtwkElementExternalID | Operation Activity of Serial Number when Hold was Applied | MPE_OAN_ELEMENT_NUMBER_EXT |
| Master Data Relations | Join Conditions |
|---|---|
Defect Code Group
| |
Production Plant
|