I_MfgOrderOperationForConf
Mfg Order Operation for Confirmation
I_MfgOrderOperationForConf is a Composite CDS View that provides data about "Mfg Order Operation for Confirmation" in SAP S/4HANA. It reads from 2 data sources (I_MfgOrderOperation, I_OrderItem) and exposes 131 fields with key fields OrderInternalBillOfOperations, OrderIntBillOfOperationsItem. It has 8 associations to related views. Part of development package ODATA_PP_PRODOPER_CNF.
Data Sources (2)
| Source | Alias | Join Type |
|---|---|---|
| I_MfgOrderOperation | oper | from |
| I_OrderItem | orditem | inner |
Associations (8)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [0..1] | I_UnitOfMeasure | _OperationUnit | $projection.OperationUnit = _OperationUnit.UnitOfMeasure |
| [0..1] | I_UnitOfMeasure | _ProductionUnit | $projection.ProductionUnit = _ProductionUnit.UnitOfMeasure |
| [0..1] | I_UnitOfMeasure | _OpWorkQuantityUnit1 | $projection.OpWorkQuantityUnit1 = _OpWorkQuantityUnit1.UnitOfMeasure |
| [0..1] | I_UnitOfMeasure | _OpWorkQuantityUnit2 | $projection.OpWorkQuantityUnit2 = _OpWorkQuantityUnit2.UnitOfMeasure |
| [0..1] | I_UnitOfMeasure | _OpWorkQuantityUnit3 | $projection.OpWorkQuantityUnit3 = _OpWorkQuantityUnit3.UnitOfMeasure |
| [0..1] | I_UnitOfMeasure | _OpWorkQuantityUnit4 | $projection.OpWorkQuantityUnit4 = _OpWorkQuantityUnit4.UnitOfMeasure |
| [0..1] | I_UnitOfMeasure | _OpWorkQuantityUnit5 | $projection.OpWorkQuantityUnit5 = _OpWorkQuantityUnit5.UnitOfMeasure |
| [0..1] | I_UnitOfMeasure | _OpWorkQuantityUnit6 | $projection.OpWorkQuantityUnit6 = _OpWorkQuantityUnit6.UnitOfMeasure |
Annotations (10)
| Name | Value | Level | Field |
|---|---|---|---|
| AbapCatalog.sqlViewName | IMFGORDOPFORCONF | view | |
| AbapCatalog.compiler.compareFilter | true | view | |
| AbapCatalog.preserveKey | true | view | |
| AccessControl.authorizationCheck | #CHECK | view | |
| ClientHandling.algorithm | #SESSION_VARIABLE | view | |
| ObjectModel.usageType.serviceQuality | #C | view | |
| ObjectModel.usageType.sizeCategory | #XL | view | |
| ObjectModel.usageType.dataClass | #MIXED | view | |
| VDM.viewType | #COMPOSITE | view | |
| EndUserText.label | Mfg Order Operation for Confirmation | view |
Fields (131)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | OrderInternalBillOfOperations | I_MfgOrderOperation | OrderInternalBillOfOperations | Order Internal Bill of Operations |
| KEY | OrderIntBillOfOperationsItem | I_MfgOrderOperation | OrderIntBillOfOperationsItem | Order Internal Bill of Operations Item |
| ManufacturingOrder | I_MfgOrderOperation | ManufacturingOrder | Order | |
| ManufacturingOrderSequence | I_MfgOrderOperation | ManufacturingOrderSequence | ||
| ManufacturingOrderOperation | I_MfgOrderOperation | ManufacturingOrderOperation | Activity | |
| ManufacturingOrderSubOperation | ||||
| ManufacturingOrderCategory | I_MfgOrderOperation | ManufacturingOrderCategory | ||
| ManufacturingOrderType | I_MfgOrderOperation | ManufacturingOrderType | ||
| ProductionSupervisor | I_MfgOrderOperation | ProductionSupervisor | Prodn Supervisor | |
| MRPController | I_MfgOrderOperation | MRPController | MRP Controller | |
| Material | I_OrderItem | Material | Vehicle Model | |
| MfgOrderOperationText | I_MfgOrderOperation | MfgOrderOperationText | ||
| OperationControlProfile | I_MfgOrderOperation | OperationControlProfile | Control Key | |
| OperationConfirmation | I_MfgOrderOperation | OperationConfirmation | ||
| FactoryCalendar | I_MfgOrderOperation | FactoryCalendar | Factory Calendar | |
| ProductionPlant | I_MfgOrderOperation | ProductionPlant | Prod plnt | |
| OperationIsCreated | ||||
| OperationIsReleased | ||||
| OperationIsPrinted | ||||
| OperationIsConfirmed | ||||
| OperationIsPartiallyConfirmed | ||||
| OperationIsDeleted | ||||
| OperationIsTechlyCompleted | ||||
| OperationIsClosed | ||||
| OperationIsScheduled | ||||
| OperationIsPartiallyDelivered | ||||
| OperationIsDelivered | ||||
| ConfirmationIsRequired | ||||
| ConfirmationIsNotPossible | ||||
| WorkCenterInternalID | I_MfgOrderOperation | WorkCenterInternalID | Work Center | |
| WorkCenterTypeCode | I_MfgOrderOperation | WorkCenterTypeCode_2 | ||
| OpErlstSchedldExecStrtDte | I_MfgOrderOperation | OpErlstSchedldExecStrtDte | Earl.start date | |
| OpErlstSchedldExecStrtTme | I_MfgOrderOperation | OpErlstSchedldExecStrtTme | ||
| OpErlstSchedldProcgStrtDte | I_MfgOrderOperation | OpErlstSchedldProcgStrtDte | ||
| OpErlstSchedldProcgStrtTme | I_MfgOrderOperation | OpErlstSchedldProcgStrtTme | ||
| OpErlstSchedldTrdwnStrtDte | I_MfgOrderOperation | OpErlstSchedldTrdwnStrtDte | ||
| OpErlstSchedldTrdwnStrtTme | I_MfgOrderOperation | OpErlstSchedldTrdwnStrtTme | ||
| OpErlstSchedldExecEndDte | I_MfgOrderOperation | OpErlstSchedldExecEndDte | EarliestEndDate | |
| OpErlstSchedldExecEndTme | I_MfgOrderOperation | OpErlstSchedldExecEndTme | ||
| OpLtstSchedldExecStrtDte | I_MfgOrderOperation | OpLtstSchedldExecStrtDte | Latest start | |
| OpLtstSchedldExecStrtTme | I_MfgOrderOperation | OpLtstSchedldExecStrtTme | ||
| OpLtstSchedldProcgStrtDte | I_MfgOrderOperation | OpLtstSchedldProcgStrtDte | ||
| OpLtstSchedldProcgStrtTme | I_MfgOrderOperation | OpLtstSchedldProcgStrtTme | ||
| OpLtstSchedldTrdwnStrtDte | I_MfgOrderOperation | OpLtstSchedldTrdwnStrtDte | ||
| OpLtstSchedldTrdwnStrtTme | I_MfgOrderOperation | OpLtstSchedldTrdwnStrtTme | ||
| OpLtstSchedldExecEndDte | I_MfgOrderOperation | OpLtstSchedldExecEndDte | Lat.finish date | |
| OpLtstSchedldExecEndTme | I_MfgOrderOperation | OpLtstSchedldExecEndTme | ||
| OperationConfirmedStartDate | I_MfgOrderOperation | OperationConfirmedStartDate | ||
| OperationConfirmedEndDate | I_MfgOrderOperation | OperationConfirmedEndDate | ||
| OpActualExecutionStartDate | I_MfgOrderOperation | OpActualExecutionStartDate | Execution Start Date | |
| OpActualExecutionStartTime | I_MfgOrderOperation | OpActualExecutionStartTime | ||
| OpActualSetupEndDate | I_MfgOrderOperation | OpActualSetupEndDate | ||
| OpActualSetupEndTime | I_MfgOrderOperation | OpActualSetupEndTime | ||
| OpActualProcessingStartDate | I_MfgOrderOperation | OpActualProcessingStartDate | ||
| OpActualProcessingStartTime | I_MfgOrderOperation | OpActualProcessingStartTime | ||
| OpActualProcessingEndDate | I_MfgOrderOperation | OpActualProcessingEndDate | ||
| OpActualProcessingEndTime | I_MfgOrderOperation | OpActualProcessingEndTime | ||
| OpActualTeardownStartDate | I_MfgOrderOperation | OpActualTeardownStartDate | ||
| OpActualTeardownStartTme | I_MfgOrderOperation | OpActualTeardownStartTme | ||
| OpActualExecutionEndDate | I_MfgOrderOperation | OpActualExecutionEndDate | Execution End Date | |
| OpActualExecutionEndTime | I_MfgOrderOperation | OpActualExecutionEndTime | ||
| OperationUnit | I_MfgOrderOperation | OperationUnit | Act/op UoM | |
| ProductionUnit | I_MfgOrderOperation | ProductionUnit | ||
| OpQtyToBaseQtyDnmntr | I_MfgOrderOperation | OpQtyToBaseQtyDnmntr | ||
| OpQtyToBaseQtyNmrtr | I_MfgOrderOperation | OpQtyToBaseQtyNmrtr | ||
| OperationScrapPercent | I_MfgOrderOperation | OperationScrapPercent | Scrap | |
| OpPlannedTotalQuantity | I_MfgOrderOperation | OpPlannedTotalQuantity | ||
| OpPlannedScrapQuantity | I_MfgOrderOperation | OpPlannedScrapQuantity | ||
| OpPlannedYieldQuantity | I_MfgOrderOperation | OpPlannedYieldQuantity | ||
| OpTotalConfirmedYieldQty | I_MfgOrderOperation | OpTotalConfirmedYieldQty | ||
| OpTotalConfirmedScrapQty | I_MfgOrderOperation | OpTotalConfirmedScrapQty | ||
| OperationConfirmedReworkQty | I_MfgOrderOperation | OperationConfirmedReworkQty | ||
| OpWorkQuantityUnit1 | I_MfgOrderOperation | OpWorkQuantityUnit1 | ||
| OpConfirmedWorkQuantity1 | I_MfgOrderOperation | OpConfirmedWorkQuantity1 | ||
| NoFurtherOpWorkQuantity1IsExpd | I_MfgOrderOperation | NoFurtherOpWorkQuantity1IsExpd | ||
| OpWorkQuantityUnit2 | I_MfgOrderOperation | OpWorkQuantityUnit2 | ||
| OpConfirmedWorkQuantity2 | I_MfgOrderOperation | OpConfirmedWorkQuantity2 | ||
| NoFurtherOpWorkQuantity2IsExpd | I_MfgOrderOperation | NoFurtherOpWorkQuantity2IsExpd | ||
| OpWorkQuantityUnit3 | I_MfgOrderOperation | OpWorkQuantityUnit3 | ||
| OpConfirmedWorkQuantity3 | I_MfgOrderOperation | OpConfirmedWorkQuantity3 | ||
| NoFurtherOpWorkQuantity3IsExpd | I_MfgOrderOperation | NoFurtherOpWorkQuantity3IsExpd | ||
| OpWorkQuantityUnit4 | I_MfgOrderOperation | OpWorkQuantityUnit4 | ||
| OpConfirmedWorkQuantity4 | I_MfgOrderOperation | OpConfirmedWorkQuantity4 | ||
| NoFurtherOpWorkQuantity4IsExpd | I_MfgOrderOperation | NoFurtherOpWorkQuantity4IsExpd | ||
| OpWorkQuantityUnit5 | I_MfgOrderOperation | OpWorkQuantityUnit5 | ||
| OpConfirmedWorkQuantity5 | I_MfgOrderOperation | OpConfirmedWorkQuantity5 | ||
| NoFurtherOpWorkQuantity5IsExpd | I_MfgOrderOperation | NoFurtherOpWorkQuantity5IsExpd | ||
| OpWorkQuantityUnit6 | I_MfgOrderOperation | OpWorkQuantityUnit6 | ||
| OpConfirmedWorkQuantity6 | I_MfgOrderOperation | OpConfirmedWorkQuantity6 | ||
| NoFurtherOpWorkQuantity6IsExpd | I_MfgOrderOperation | NoFurtherOpWorkQuantity6IsExpd | ||
| WorkCenterStandardWorkQtyUnit1 | I_MfgOrderOperation | WorkCenterStandardWorkQtyUnit1 | ||
| WorkCenterStandardWorkQty1 | I_MfgOrderOperation | WorkCenterStandardWorkQty1 | ||
| CostCtrActivityType1 | I_MfgOrderOperation | CostCtrActivityType1 | Activity Type | |
| WorkCenterStandardWorkQtyUnit2 | I_MfgOrderOperation | WorkCenterStandardWorkQtyUnit2 | ||
| WorkCenterStandardWorkQty2 | I_MfgOrderOperation | WorkCenterStandardWorkQty2 | ||
| CostCtrActivityType2 | I_MfgOrderOperation | CostCtrActivityType2 | Activity Type | |
| WorkCenterStandardWorkQtyUnit3 | I_MfgOrderOperation | WorkCenterStandardWorkQtyUnit3 | ||
| WorkCenterStandardWorkQty3 | I_MfgOrderOperation | WorkCenterStandardWorkQty3 | ||
| CostCtrActivityType3 | I_MfgOrderOperation | CostCtrActivityType3 | Activity Type | |
| WorkCenterStandardWorkQtyUnit4 | I_MfgOrderOperation | WorkCenterStandardWorkQtyUnit4 | ||
| WorkCenterStandardWorkQty4 | I_MfgOrderOperation | WorkCenterStandardWorkQty4 | ||
| CostCtrActivityType4 | I_MfgOrderOperation | CostCtrActivityType4 | Activity Type | |
| WorkCenterStandardWorkQtyUnit5 | I_MfgOrderOperation | WorkCenterStandardWorkQtyUnit5 | ||
| WorkCenterStandardWorkQty5 | I_MfgOrderOperation | WorkCenterStandardWorkQty5 | ||
| CostCtrActivityType5 | I_MfgOrderOperation | CostCtrActivityType5 | Activity Type | |
| WorkCenterStandardWorkQtyUnit6 | I_MfgOrderOperation | WorkCenterStandardWorkQtyUnit6 | ||
| WorkCenterStandardWorkQty6 | I_MfgOrderOperation | WorkCenterStandardWorkQty6 | ||
| CostCtrActivityType6 | I_MfgOrderOperation | CostCtrActivityType6 | Activity Type | |
| Personnel | I_MfgOrderOperation | Personnel | Personnel No. | |
| _OrdInternalBillOfOperations | I_MfgOrderOperation | _OrdInternalBillOfOperations | ||
| _MfgOrder | I_MfgOrderOperation | _MfgOrder | ||
| _MfgOrderSequence | I_MfgOrderOperation | _MfgOrderSequence | ||
| _MfgOrderCategory | I_MfgOrderOperation | _MfgOrderCategory | ||
| _MfgOrderType | I_MfgOrderOperation | _MfgOrderType | ||
| _ProductionSupervisor | I_MfgOrderOperation | _ProductionSupervisor | ||
| _MRPController | I_MfgOrderOperation | _MRPController | ||
| _OperationConfirmation | I_MfgOrderOperation | _OperationConfirmation | ||
| _FactoryCalendar | I_MfgOrderOperation | _FactoryCalendar | ||
| _ProductionPlant | I_MfgOrderOperation | _ProductionPlant | ||
| _OperationUnit | _OperationUnit | |||
| _ProductionUnit | _ProductionUnit | |||
| _OpWorkQuantityUnit1 | _OpWorkQuantityUnit1 | |||
| _OpWorkQuantityUnit2 | _OpWorkQuantityUnit2 | |||
| _OpWorkQuantityUnit3 | _OpWorkQuantityUnit3 | |||
| _OpWorkQuantityUnit4 | _OpWorkQuantityUnit4 | |||
| _OpWorkQuantityUnit5 | _OpWorkQuantityUnit5 | |||
| _OpWorkQuantityUnit6 | _OpWorkQuantityUnit6 | |||
| _WorkCenter | I_MfgOrderOperation | _WorkCenter_2 | ||
| _WorkCenterType | I_MfgOrderOperation | _WorkCenterType_2 | ||
| _Material | I_OrderItem | _Material | ||
| _OperationControlProfile | I_MfgOrderOperation | _OperationControlProfile |
Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.
-- Derived SQL interpretation of CDS view I_MfgOrderOperationForConf.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: IMFGORDOPFORCONF
CREATE VIEW I_MfgOrderOperationForConf AS
SELECT
oper.OrderInternalBillOfOperations AS OrderInternalBillOfOperations,
oper.OrderIntBillOfOperationsItem AS OrderIntBillOfOperationsItem,
oper.ManufacturingOrder AS ManufacturingOrder,
oper.ManufacturingOrderSequence AS ManufacturingOrderSequence,
oper.ManufacturingOrderOperation AS ManufacturingOrderOperation,
cast(oper.ManufacturingOrderSubOperation as vdm_vornr preserving type) AS ManufacturingOrderSubOperation,
oper.ManufacturingOrderCategory AS ManufacturingOrderCategory,
oper.ManufacturingOrderType AS ManufacturingOrderType,
oper.ProductionSupervisor AS ProductionSupervisor,
oper.MRPController AS MRPController,
orditem.Material AS Material,
oper.MfgOrderOperationText AS MfgOrderOperationText,
oper.OperationControlProfile AS OperationControlProfile,
oper.OperationConfirmation AS OperationConfirmation,
oper.FactoryCalendar AS FactoryCalendar,
oper.ProductionPlant AS ProductionPlant,
case when _isCreated.StatusCode is null then '' else 'X' end AS OperationIsCreated,
case when _isReleased.StatusCode is null then '' else 'X' end AS OperationIsReleased,
case when _isPrinted.StatusCode is null then '' else 'X' end AS OperationIsPrinted,
case when _isConfirmed.StatusCode is null then '' else 'X' end AS OperationIsConfirmed,
case when _isPartConf.StatusCode is null then '' else 'X' end AS OperationIsPartiallyConfirmed,
case when _isDeleted.StatusCode is null then '' else 'X' end AS OperationIsDeleted,
case when _isTechCompl.StatusCode is null then '' else 'X' end AS OperationIsTechlyCompleted,
case when _isClosed.StatusCode is null then '' else 'X' end AS OperationIsClosed,
case when _isScheduled.StatusCode is null then '' else 'X' end AS OperationIsScheduled,
case when _isPartDeliv.StatusCode is null then '' else 'X' end AS OperationIsPartiallyDelivered,
case when _isDelivered.StatusCode is null then '' else 'X' end AS OperationIsDelivered,
oper._OperationControlProfile.ConfirmationIsRequired AS ConfirmationIsRequired,
oper._OperationControlProfile.ConfirmationIsNotPossible AS ConfirmationIsNotPossible,
oper.WorkCenterInternalID AS WorkCenterInternalID,
oper.WorkCenterTypeCode_2 AS WorkCenterTypeCode,
oper.OpErlstSchedldExecStrtDte AS OpErlstSchedldExecStrtDte,
oper.OpErlstSchedldExecStrtTme AS OpErlstSchedldExecStrtTme,
oper.OpErlstSchedldProcgStrtDte AS OpErlstSchedldProcgStrtDte,
oper.OpErlstSchedldProcgStrtTme AS OpErlstSchedldProcgStrtTme,
oper.OpErlstSchedldTrdwnStrtDte AS OpErlstSchedldTrdwnStrtDte,
oper.OpErlstSchedldTrdwnStrtTme AS OpErlstSchedldTrdwnStrtTme,
oper.OpErlstSchedldExecEndDte AS OpErlstSchedldExecEndDte,
oper.OpErlstSchedldExecEndTme AS OpErlstSchedldExecEndTme,
oper.OpLtstSchedldExecStrtDte AS OpLtstSchedldExecStrtDte,
oper.OpLtstSchedldExecStrtTme AS OpLtstSchedldExecStrtTme,
oper.OpLtstSchedldProcgStrtDte AS OpLtstSchedldProcgStrtDte,
oper.OpLtstSchedldProcgStrtTme AS OpLtstSchedldProcgStrtTme,
oper.OpLtstSchedldTrdwnStrtDte AS OpLtstSchedldTrdwnStrtDte,
oper.OpLtstSchedldTrdwnStrtTme AS OpLtstSchedldTrdwnStrtTme,
oper.OpLtstSchedldExecEndDte AS OpLtstSchedldExecEndDte,
oper.OpLtstSchedldExecEndTme AS OpLtstSchedldExecEndTme,
oper.OperationConfirmedStartDate AS OperationConfirmedStartDate,
oper.OperationConfirmedEndDate AS OperationConfirmedEndDate,
oper.OpActualExecutionStartDate AS OpActualExecutionStartDate,
oper.OpActualExecutionStartTime AS OpActualExecutionStartTime,
oper.OpActualSetupEndDate AS OpActualSetupEndDate,
oper.OpActualSetupEndTime AS OpActualSetupEndTime,
oper.OpActualProcessingStartDate AS OpActualProcessingStartDate,
oper.OpActualProcessingStartTime AS OpActualProcessingStartTime,
oper.OpActualProcessingEndDate AS OpActualProcessingEndDate,
oper.OpActualProcessingEndTime AS OpActualProcessingEndTime,
oper.OpActualTeardownStartDate AS OpActualTeardownStartDate,
oper.OpActualTeardownStartTme AS OpActualTeardownStartTme,
oper.OpActualExecutionEndDate AS OpActualExecutionEndDate,
oper.OpActualExecutionEndTime AS OpActualExecutionEndTime,
oper.OperationUnit AS OperationUnit,
oper.ProductionUnit AS ProductionUnit,
oper.OpQtyToBaseQtyDnmntr AS OpQtyToBaseQtyDnmntr,
oper.OpQtyToBaseQtyNmrtr AS OpQtyToBaseQtyNmrtr,
oper.OperationScrapPercent AS OperationScrapPercent,
oper.OpPlannedTotalQuantity AS OpPlannedTotalQuantity,
oper.OpPlannedScrapQuantity AS OpPlannedScrapQuantity,
oper.OpPlannedYieldQuantity AS OpPlannedYieldQuantity,
oper.OpTotalConfirmedYieldQty AS OpTotalConfirmedYieldQty,
oper.OpTotalConfirmedScrapQty AS OpTotalConfirmedScrapQty,
oper.OperationConfirmedReworkQty AS OperationConfirmedReworkQty,
oper.OpWorkQuantityUnit1 AS OpWorkQuantityUnit1,
oper.OpConfirmedWorkQuantity1 AS OpConfirmedWorkQuantity1,
oper.NoFurtherOpWorkQuantity1IsExpd AS NoFurtherOpWorkQuantity1IsExpd,
oper.OpWorkQuantityUnit2 AS OpWorkQuantityUnit2,
oper.OpConfirmedWorkQuantity2 AS OpConfirmedWorkQuantity2,
oper.NoFurtherOpWorkQuantity2IsExpd AS NoFurtherOpWorkQuantity2IsExpd,
oper.OpWorkQuantityUnit3 AS OpWorkQuantityUnit3,
oper.OpConfirmedWorkQuantity3 AS OpConfirmedWorkQuantity3,
oper.NoFurtherOpWorkQuantity3IsExpd AS NoFurtherOpWorkQuantity3IsExpd,
oper.OpWorkQuantityUnit4 AS OpWorkQuantityUnit4,
oper.OpConfirmedWorkQuantity4 AS OpConfirmedWorkQuantity4,
oper.NoFurtherOpWorkQuantity4IsExpd AS NoFurtherOpWorkQuantity4IsExpd,
oper.OpWorkQuantityUnit5 AS OpWorkQuantityUnit5,
oper.OpConfirmedWorkQuantity5 AS OpConfirmedWorkQuantity5,
oper.NoFurtherOpWorkQuantity5IsExpd AS NoFurtherOpWorkQuantity5IsExpd,
oper.OpWorkQuantityUnit6 AS OpWorkQuantityUnit6,
oper.OpConfirmedWorkQuantity6 AS OpConfirmedWorkQuantity6,
oper.NoFurtherOpWorkQuantity6IsExpd AS NoFurtherOpWorkQuantity6IsExpd,
oper.WorkCenterStandardWorkQtyUnit1 AS WorkCenterStandardWorkQtyUnit1,
oper.WorkCenterStandardWorkQty1 AS WorkCenterStandardWorkQty1,
oper.CostCtrActivityType1 AS CostCtrActivityType1,
oper.WorkCenterStandardWorkQtyUnit2 AS WorkCenterStandardWorkQtyUnit2,
oper.WorkCenterStandardWorkQty2 AS WorkCenterStandardWorkQty2,
oper.CostCtrActivityType2 AS CostCtrActivityType2,
oper.WorkCenterStandardWorkQtyUnit3 AS WorkCenterStandardWorkQtyUnit3,
oper.WorkCenterStandardWorkQty3 AS WorkCenterStandardWorkQty3,
oper.CostCtrActivityType3 AS CostCtrActivityType3,
oper.WorkCenterStandardWorkQtyUnit4 AS WorkCenterStandardWorkQtyUnit4,
oper.WorkCenterStandardWorkQty4 AS WorkCenterStandardWorkQty4,
oper.CostCtrActivityType4 AS CostCtrActivityType4,
oper.WorkCenterStandardWorkQtyUnit5 AS WorkCenterStandardWorkQtyUnit5,
oper.WorkCenterStandardWorkQty5 AS WorkCenterStandardWorkQty5,
oper.CostCtrActivityType5 AS CostCtrActivityType5,
oper.WorkCenterStandardWorkQtyUnit6 AS WorkCenterStandardWorkQtyUnit6,
oper.WorkCenterStandardWorkQty6 AS WorkCenterStandardWorkQty6,
oper.CostCtrActivityType6 AS CostCtrActivityType6,
oper.Personnel AS Personnel,
oper._OrdInternalBillOfOperations AS _OrdInternalBillOfOperations,
oper._MfgOrder AS _MfgOrder,
oper._MfgOrderSequence AS _MfgOrderSequence,
oper._MfgOrderCategory AS _MfgOrderCategory,
oper._MfgOrderType AS _MfgOrderType,
oper._ProductionSupervisor AS _ProductionSupervisor,
oper._MRPController AS _MRPController,
oper._OperationConfirmation AS _OperationConfirmation,
oper._FactoryCalendar AS _FactoryCalendar,
oper._ProductionPlant AS _ProductionPlant,
oper._WorkCenter_2 AS _WorkCenter,
oper._WorkCenterType_2 AS _WorkCenterType,
orditem._Material AS _Material,
oper._OperationControlProfile AS _OperationControlProfile
FROM I_MfgOrderOperation AS oper
INNER JOIN I_OrderItem AS orditem ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_UnitOfMeasure AS _OperationUnit ON OperationUnit = _OperationUnit.UnitOfMeasure -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _ProductionUnit ON ProductionUnit = _ProductionUnit.UnitOfMeasure -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _OpWorkQuantityUnit1 ON OpWorkQuantityUnit1 = _OpWorkQuantityUnit1.UnitOfMeasure -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _OpWorkQuantityUnit2 ON OpWorkQuantityUnit2 = _OpWorkQuantityUnit2.UnitOfMeasure -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _OpWorkQuantityUnit3 ON OpWorkQuantityUnit3 = _OpWorkQuantityUnit3.UnitOfMeasure -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _OpWorkQuantityUnit4 ON OpWorkQuantityUnit4 = _OpWorkQuantityUnit4.UnitOfMeasure -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _OpWorkQuantityUnit5 ON OpWorkQuantityUnit5 = _OpWorkQuantityUnit5.UnitOfMeasure -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _OpWorkQuantityUnit6 ON OpWorkQuantityUnit6 = _OpWorkQuantityUnit6.UnitOfMeasure -- association [0..1]
;Learn More
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- CDS View Annotations — A Complete Guide
- What Is a CDS View in SAP S/4HANA?
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA
- 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
- BW Extractor to CDS View Migration Guide
- S/4HANA CDS View Deprecation: What You Need to Know
- ABAP CDS View Tutorial — From Basics to Real-World Examples
- RAP and CDS Views — Building Transactional Apps in SAP S/4HANA
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA