- 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_MfgOrderOpExecDurnQry
Mfg Order Operation Execution Duration - Query
| view: CPPMFGORDEROPDQ
| Extraction:
Not supported
| Component: Virtual Data Model in PP
- 🔑 Keys (2)
- 💰 Amounts
- ∑ Quantities
- 📅 Dates (2)
- ☰ Categorical (2)
- Other (27)
- 🔗 Relations (6)
| Column Name | Description | |
|---|---|---|
| OrderInternalBillOfOperations | Order Internal ID | |
| OrderIntBillOfOperationsItem | Internal Identifier of an Operation or Activity |
| Column Name | Description |
|---|
| Column Name | Description |
|---|
| Column Name | Description | |
|---|---|---|
| ActualExecutionEndDate | Confirmed End Date of Execution | |
| ActualExecutionEndTime | Confirmed End Time of Execution |
| Column Name | Description | |
|---|---|---|
| ReportingPeriod | Reporting Period | Show values |
| ManufacturingOrderCategory | Manufacturing Order Category | Show values |
| Column Name | Description | Domain name | |
|---|---|---|---|
| MRPPlantName | Plant Name | ||
| MaterialName | Material Description | TEXT40 | |
| WorkCenter | Work Center | ARBPL | |
| WorkCenterText | Work Center Text | TEXT40 | |
| ReportingPeriodName | Reporting Period Name | DDTEXT | |
| ManufacturingOrder | Manufacturing Order ID | AUFNR | |
| ManufacturingOrderCategoryName | Manufacturing Order Category Name | DDTEXT | |
| ManufacturingOrderTypeName | Manufacturing Order Type Name | TEXT40 | |
| ManufacturingOrderOperation | Manufacturing Order Operation | VORNR | |
| MfgOrderOperationText | Manufacturing Order Operation Text | TEXT40 | |
| ProductionPlantName | Plant Name | TEXT30 | |
| ProductionSupervisorName | Production Supervisor Name | ||
| EndDateHour | End Date Hour | HOUR2 | |
| EndDateWeekDay | Week Day | NUM1 | |
| EndDateWeekDayName | End Date Week Day Name | DDTEXT | |
| EndDateMonth | Calendar Month | NUM2 | |
| EndDateMonthName | End Date Month Name | DDTEXT | |
| EndDateYear | Calendar Year | NUM4 | |
| EndDateYearMonth | Year Month | NUM6 | |
| ActualWorkdayDurnInSeconds | Actual Duration in Seconds | ||
| PlannedWorkdayDurnInSeconds | Planned Duration in Seconds | ||
| DeviationWorkdayDurnInSeconds | Deviation Duration in Seconds | ||
| ActualDuration | Actual Duration | DEC20 | |
| PlannedDuration | Planned Duration | DEC20 | |
| DeviationDuration | Deviation Between Planned and Actual Duration | DEC20 | |
| DurationDeviationPercent | null | ||
| StockSegment | Stock Segment |
| Master Data Relations | Join Conditions |
|---|---|
Manufacturing Order Type
| |
Material Number for Order
| |
Planning Plant for an Order
| |
Production Plant
| |
Production Supervisor
| |
Work Center Internal ID
|