I_MfgOrderOperationConf

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_MfgOrderOperationConf.
-- 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: IPPMFGORDOPCONF

CREATE VIEW I_MfgOrderOperationConf AS
SELECT
  afru.ConfirmationGroup AS MfgOrderConfirmation,
  afru.OrderConfirmation AS MfgOrderConfirmationCount,
  cast(afru.OrderID as manufacturingorder preserving type) AS ManufacturingOrder,
  cast(afru.Sequence as manufacturingordersequence preserving type) AS ManufacturingOrderSequence,
  cast(afru.OrderOperation as manufacturingorderoperation preserving type) AS ManufacturingOrderOperation,
  cast(aufv.OrderCategory as manufacturingordercategory preserving type) AS ManufacturingOrderCategory,
  cast(aufv.OrderType as manufacturingordertype preserving type) AS ManufacturingOrderType,
  cast(aufv.Plant as pwwrk preserving type) AS ProductionPlant,
  cast(aufv.ProductionSupervisor as pph_fevor preserving type) AS ProductionSupervisor,
  cast(aufv.MRPController as pph_dispo preserving type) AS MRPController,
  cast(afru.OrderInternalID as orderinternalbillofoperations preserving type) AS OrderInternalBillOfOperations,
  cast(afru.OrderOperationInternalID as orderintbillofoperationsitem preserving type) AS OrderIntBillOfOperationsItem,
  afru.Plant AS Plant,
  afru.WorkCenterTypeCode AS WorkCenterTypeCode,
  afru. WorkCenterInternalID AS WorkCenterInternalID,
  afru.CapacityInternalID AS CapacityInternalID,
  afru.CapacityRequirementSplit AS CapacityRequirementSplit,
  afru.ShiftGrouping AS ShiftGrouping,
  afru.ConfirmationText AS ConfirmationText,
  afru.Language AS Language,
  afru.LongTextExists AS LongTextExists,
  afru.ConfirmationEntryDate AS MfgOrderConfirmationEntryDate,
  afru.ConfirmationEntryTime AS MfgOrderConfirmationEntryTime,
  afru.EnteredByUser AS EnteredByUser,
  afru.LastChangeDate AS LastChangeDate,
  afru.LastChangedByUser AS LastChangedByUser,
  afru.ConfirmationExternalEntryDate AS ConfirmationExternalEntryDate,
  afru.ConfirmationExternalEntryTime AS ConfirmationExternalEntryTime,
  afru.EnteredByExternalUser AS EnteredByExternalUser,
  afru.FinalConfirmationType AS FinalConfirmationType,
  afru.IsFinalConfirmation AS IsFinalConfirmation,
  afru.OpenReservationsIsCleared AS OpenReservationsIsCleared,
  afru.IsReversed AS IsReversed,
  afru.IsReversal AS IsReversal,
  afru.CancldMfgOrderConfCount AS CancldMfgOrderOpConfCount,
  afru.OrderConfirmationRecordType AS OrderConfirmationRecordType,
  afru.MilestoneIsConfirmed AS MilestoneIsConfirmed,
  afru.MilestoneConfirmationType AS MilestoneConfirmationType,
  afru.IsConfirmedByMilestoneConf AS IsConfirmedByMilestoneConf,
  afru.MilestoneConfirmationGroup AS MilestoneConfirmationGroup,
  afru.MilestoneConfirmation AS MilestoneConfirmation,
  aufv.BusinessArea AS BusinessArea,
  aufv.CompanyCode AS CompanyCode,
  aufv.ControllingArea AS ControllingArea,
  cast(aufv.ProductCostCollector as pkosa_d preserving type) AS ProductCostCollector,
  afru.Personnel AS Personnel,
  afru.TimeRecording AS TimeRecording,
  afru.EmployeeWageType AS EmployeeWageType,
  afru.EmployeeWageGroup AS EmployeeWageGroup,
  afru.EmployeeSuitability AS EmployeeSuitability,
  afru.NumberOfEmployees AS NumberOfEmployees,
  afru.PostingDate AS PostingDate,
  afru.ConfirmedExecutionStartDate AS ConfirmedExecutionStartDate,
  afru.ConfirmedExecutionStartTime AS ConfirmedExecutionStartTime,
  afru.ConfirmedSetupEndDate AS ConfirmedSetupEndDate,
  afru.ConfirmedSetupEndTime AS ConfirmedSetupEndTime,
  afru.ConfirmedProcessingStartDate AS ConfirmedProcessingStartDate,
  afru.ConfirmedProcessingStartTime AS ConfirmedProcessingStartTime,
  afru.ConfirmedProcessingEndDate AS ConfirmedProcessingEndDate,
  afru.ConfirmedProcessingEndTime AS ConfirmedProcessingEndTime,
  afru.ConfirmedTeardownStartDate AS ConfirmedTeardownStartDate,
  afru.ConfirmedTeardownStartTime AS ConfirmedTeardownStartTime,
  afru.ConfirmedExecutionEndDate AS ConfirmedExecutionEndDate,
  afru.ConfirmedExecutionEndTime AS ConfirmedExecutionEndTime,
  afru.VarianceReasonCode AS VarianceReasonCode,
  afru.ConfirmationUnit AS ConfirmationUnit,
  afru.ConfirmationYieldQuantity AS ConfirmationYieldQuantity,
  afru.ConfirmationScrapQuantity AS ConfirmationScrapQuantity,
  afru.ConfirmationReworkQuantity AS ConfirmationReworkQuantity,
  afru.ConfirmationTotalQuantity AS ConfirmationTotalQuantity,
  cast(afru.OrderQuantityUnit as productionunit preserving type) AS ProductionUnit,
  afru.ConfirmedYieldQtyInOrderUnit AS ConfYieldQtyInProductionUnit,
  afru.OperationUnit AS OperationUnit,
  afru.OpPlannedTotalQuantity AS OpPlannedTotalQuantity,
  cast(aufv.OrderConfirmedYieldQty as co_igmng preserving type) AS MfgOrderConfirmedYieldQty,
  cast(aufv.OrderConfirmedScrapQty as co_iasmg preserving type) AS MfgOrderConfirmedScrapQty,
  aufv.MfgOrderConfirmedReworkQty AS MfgOrderConfirmedReworkQty,
  cast((aufv.OrderConfirmedYieldQty + aufv.OrderConfirmedScrapQty + aufv.MfgOrderConfirmedReworkQty) as pph_tmnga) AS MfgOrderConfirmedTotalQty,
  afru.OpWorkQuantityUnit1 AS OpWorkQuantityUnit1,
  afru.OpConfirmedWorkQuantity1 AS OpConfirmedWorkQuantity1,
  afru.NoFurtherOpWorkQuantity1IsExpd AS NoFurtherOpWorkQuantity1IsExpd,
  afru.OpWorkQuantityUnit2 AS OpWorkQuantityUnit2,
  afru.OpConfirmedWorkQuantity2 AS OpConfirmedWorkQuantity2,
  afru.NoFurtherOpWorkQuantity2IsExpd AS NoFurtherOpWorkQuantity2IsExpd,
  afru.OpWorkQuantityUnit3 AS OpWorkQuantityUnit3,
  afru.OpConfirmedWorkQuantity3 AS OpConfirmedWorkQuantity3,
  afru.NoFurtherOpWorkQuantity3IsExpd AS NoFurtherOpWorkQuantity3IsExpd,
  afru.OpWorkQuantityUnit4 AS OpWorkQuantityUnit4,
  afru.OpConfirmedWorkQuantity4 AS OpConfirmedWorkQuantity4,
  afru.NoFurtherOpWorkQuantity4IsExpd AS NoFurtherOpWorkQuantity4IsExpd,
  afru.OpWorkQuantityUnit5 AS OpWorkQuantityUnit5,
  afru.OpConfirmedWorkQuantity5 AS OpConfirmedWorkQuantity5,
  afru.NoFurtherOpWorkQuantity5IsExpd AS NoFurtherOpWorkQuantity5IsExpd,
  afru.OpWorkQuantityUnit6 AS OpWorkQuantityUnit6,
  afru.OpConfirmedWorkQuantity6 AS OpConfirmedWorkQuantity6,
  afru.NoFurtherOpWorkQuantity6IsExpd AS NoFurtherOpWorkQuantity6IsExpd,
  afru.BusinessProcess AS BusinessProcess,
  afru.BusinessProcessEntryUnit AS BusinessProcessEntryUnit,
  afru.BusinessProcessConfirmedQty AS BusinessProcessConfirmedQty,
  afru.NoFurtherBusinessProcQtyIsExpd AS NoFurtherBusinessProcQtyIsExpd,
  afru.BusinessProcRemainingQtyUnit AS BusinessProcRemainingQtyUnit,
  afru.BusinessProcessRemainingQty AS BusinessProcessRemainingQty,
  afru.BreakDurationUnit AS BreakDurationUnit,
  afru.ConfirmedBreakDuration AS ConfirmedBreakDuration,
  afru._ConfirmationGroup AS _ConfirmationGroup,
  afru._FinalConfirmationType AS _FinalConfirmationType,
  afru._ConfirmationRecordType AS _ConfirmationRecordType,
  afru._ConfirmationUnit AS _ConfirmationUnit,
  afru._MilestoneConfirmationGroup AS _MilestoneConfirmationGroup,
  afru._MilestoneConfirmation AS _MilestoneConfirmation,
  afru._User AS _User,
  afru._Language AS _Language,
  afru._WorkCenterType AS _WorkCenterType,
  afru._WorkCenter AS _WorkCenter,
  afru._Plant AS _Plant,
  aufv._ProductionSupervisor AS _ProductionSupervisor,
  aufv._MRPController AS _MRPController,
  afru._Capacity AS _Capacity,
  afru._ShiftGrouping AS _ShiftGrouping,
  afru._ShiftDefinition AS _ShiftDefinition,
  aufv._BusinessArea AS _BusinessArea,
  aufv._CompanyCode AS _CompanyCode,
  aufv._ControllingArea AS _ControllingArea,
  aufv._ProfitCenter AS _ProfitCenter,
  aufv._ProductCostCollector AS _ProductCostCollector,
  afru._BusinessProcessUnit AS _BusinessProcessUnit,
  afru._WorkQuantityUnit1 AS _WorkQuantityUnit1,
  afru._WorkQuantityUnit2 AS _WorkQuantityUnit2,
  afru._WorkQuantityUnit3 AS _WorkQuantityUnit3,
  afru._WorkQuantityUnit4 AS _WorkQuantityUnit4,
  afru._WorkQuantityUnit5 AS _WorkQuantityUnit5,
  afru._WorkQuantityUnit6 AS _WorkQuantityUnit6,
  afru._BreakDurationUnit AS _BreakDurationUnit,
  afru._VarianceReason AS _VarianceReason,
  afru._EmployeeWageGroup AS _EmployeeWageGroup,
  afru._EmployeeSuitability AS _EmployeeSuitability,
  afru._Employee AS _Employee,
  afru._LongTextIndicator AS _LongTextIndicator,
  afru._LongText AS _LongText
FROM I_OrderConfirmationBasic AS afru
INNER JOIN I_LogisticsOrder AS aufv ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ManufacturingOrder AS _ManufacturingOrder ON ManufacturingOrder = _ManufacturingOrder.ManufacturingOrder  -- association [1..1]
LEFT OUTER JOIN I_MfgOrder AS _MfgOrder ON ManufacturingOrder = _MfgOrder.ManufacturingOrder  -- association [1..1]
LEFT OUTER JOIN I_MfgOrderSequence AS _MfgOrderSequence ON ManufacturingOrder = _MfgOrderSequence.ManufacturingOrder AND ManufacturingOrderSequence = _MfgOrderSequence.ManufacturingOrderSequence  -- association [1..1]
LEFT OUTER JOIN I_MfgOrderOperationBasic AS _MfgOrderOperation ON OrderInternalBillOfOperations = _MfgOrderOperation.OrderInternalBillOfOperations AND OrderIntBillOfOperationsItem = _MfgOrderOperation.OrderIntBillOfOperationsItem  -- association [1..1]
LEFT OUTER JOIN I_MfgOrderCategory AS _MfgOrderCategory ON ManufacturingOrderCategory = _MfgOrderCategory.ManufacturingOrderCategory  -- association [1..1]
LEFT OUTER JOIN I_MfgOrderType AS _MfgOrderType ON ManufacturingOrderType = _MfgOrderType.ManufacturingOrderType  -- association [1..1]
LEFT OUTER JOIN I_OrdInternalBillOfOperations AS _OrdInternalBillOfOperations ON OrderInternalBillOfOperations = _OrdInternalBillOfOperations.OrderInternalBillOfOperations  -- association [1..1]
LEFT OUTER JOIN I_OrderInternalID AS _OrderInternalID ON OrderInternalBillOfOperations = _OrderInternalID.OrderInternalID  -- association [1..1]
LEFT OUTER JOIN I_Plant AS _ProductionPlant ON ProductionPlant = _ProductionPlant.Plant  -- association [1..1]
LEFT OUTER JOIN I_BusinessProcess AS _BusinessProcess ON ControllingArea = _BusinessProcess.ControllingArea AND BusinessProcess = _BusinessProcess.BusinessProcess  -- association [0..1]
;