I_MfgOrderOperationConfOper

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_MfgOrderOperationConfOper.
-- 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: IPPMFGORDOPCONFO

CREATE VIEW I_MfgOrderOperationConfOper AS
SELECT
  conf.MfgOrderConfirmation AS MfgOrderConfirmation,
  conf.MfgOrderConfirmationCount AS MfgOrderConfirmationCount,
  conf.ConfirmationText AS ConfirmationText,
  conf.Language AS Language,
  item.Material AS Material,
  conf.Plant AS Plant,
  cast(conf._WorkCenter.WorkCenter as pph_arbpl preserving type) AS WorkCenter,
  conf.WorkCenterTypeCode AS WorkCenterTypeCode,
  conf.WorkCenterInternalID AS WorkCenterInternalID,
  conf.CapacityInternalID AS CapacityInternalID,
  conf.CapacityRequirementSplit AS CapacityRequirementSplit,
  conf.IsFinalConfirmation AS IsFinalConfirmation,
  conf.OpenReservationsIsCleared AS OpenReservationsIsCleared,
  conf.IsReversed AS IsReversed,
  conf.IsReversal AS IsReversal,
  conf.CancldMfgOrderOpConfCount AS CancldMfgOrderOpConfCount,
  conf.IsConfirmedByMilestoneConf AS IsConfirmedByMilestoneConf,
  conf.MilestoneIsConfirmed AS MilestoneIsConfirmed,
  conf.MilestoneConfirmationType AS MilestoneConfirmationType,
  conf.EnteredByUser AS EnteredByUser,
  conf.MfgOrderConfirmationEntryDate AS MfgOrderConfirmationEntryDate,
  conf.MfgOrderConfirmationEntryTime AS MfgOrderConfirmationEntryTime,
  cast(left(conf.MfgOrderConfirmationEntryTime,2) as pph_entryhour) AS MfgOrderConfirmationEntryHour,
  date.ReportingDateWeekDay AS EntryDateWeekDay,
  date.ReportingDateWeek AS EntryDateWeek,
  date.ReportingDateMonth AS EntryDateMonth,
  date.ReportingDateYear AS EntryDateYear,
  cast(concat(date.ReportingDateYear, date.ReportingDateMonth) as vdm_yearmonth) AS EntryDateYearMonth,
  cast(date.ReportingPeriod as pph_reportingperiod preserving type) AS ReportingPeriod,
  conf.LastChangeDate AS LastChangeDate,
  conf.LastChangedByUser AS LastChangedByUser,
  conf.ConfirmationExternalEntryDate AS ConfirmationExternalEntryDate,
  conf.ConfirmationExternalEntryTime AS ConfirmationExternalEntryTime,
  conf.EnteredByExternalUser AS EnteredByExternalUser,
  conf.ManufacturingOrder AS ManufacturingOrder,
  conf.ManufacturingOrderSequence AS ManufacturingOrderSequence,
  conf.ManufacturingOrderOperation AS ManufacturingOrderOperation,
  conf.ManufacturingOrderOperation_2 AS ManufacturingOrderOperation_2,
  conf.ManufacturingOrderCategory AS ManufacturingOrderCategory,
  conf.ManufacturingOrderType AS ManufacturingOrderType,
  conf.ProductionPlant AS ProductionPlant,
  conf.ProductionSupervisor AS ProductionSupervisor,
  conf.MRPController AS MRPController,
  item.MRPPlant AS MRPPlant,
  item.MRPArea AS MRPArea,
  conf.OrderInternalBillOfOperations AS OrderInternalBillOfOperations,
  conf.OrderIntBillOfOperationsItem AS OrderIntBillOfOperationsItem,
  conf.BusinessArea AS BusinessArea,
  conf.CompanyCode AS CompanyCode,
  conf.ControllingArea AS ControllingArea,
  conf.ProductCostCollector AS ProductCostCollector,
  conf.TimeRecording AS TimeRecording,
  conf.EmployeeWageType AS EmployeeWageType,
  conf.EmployeeWageGroup AS EmployeeWageGroup,
  conf.EmployeeSuitability AS EmployeeSuitability,
  conf.NumberOfEmployees AS NumberOfEmployees,
  conf.ConfirmedExecutionStartDate AS ConfirmedExecutionStartDate,
  conf.ConfirmedExecutionEndDate AS ConfirmedExecutionEndDate,
  conf.PostingDate AS PostingDate,
  conf.VarianceReasonCode AS VarianceReasonCode,
  conf.ConfirmationUnit AS ConfirmationUnit,
  conf.ConfirmationYieldQuantity AS ConfirmationYieldQuantity,
  conf.ConfirmationScrapQuantity AS ConfirmationScrapQuantity,
  conf.ConfirmationReworkQuantity AS ConfirmationReworkQuantity,
  conf.ConfirmationTotalQuantity AS ConfirmationTotalQuantity,
  cast(oper.OperationScrapPercent as pph_aufak preserving type) AS OperationPlannedScrapPercent,
  item.ProductionUnit AS ProductionUnit,
  cast(item.ItemQuantity as co_psmng preserving type) AS MfgOrderItemPlannedTotalQty,
  cast(item.MfgOrderItemPlannedScrapQty as co_psamg preserving type) AS MfgOrderItemPlannedScrapQty,
  item.IsCompletelyDelivered AS MfgOrderItemIsFinallyDelivered,
  conf.MfgOrderConfirmedYieldQty AS MfgOrderConfirmedYieldQty,
  conf.MfgOrderConfirmedScrapQty AS MfgOrderConfirmedScrapQty,
  conf.MfgOrderConfirmedReworkQty AS MfgOrderConfirmedReworkQty,
  conf.MfgOrderConfirmedTotalQty AS MfgOrderConfirmedTotalQty,
  (conf.MfgOrderConfirmedScrapQty + conf.MfgOrderConfirmedReworkQty) AS MfgOrderConfdScrapReworkQty,
  cast(oper.OperationUnit as operationunit preserving type) AS OperationUnit,
  oper.OpPlannedTotalQuantity AS OpPlannedTotalQuantity,
  oper.OpPlannedScrapQuantity AS OpPlannedScrapQuantity,
  oper.OpTotalConfirmedScrapQty AS OpTotalConfirmedScrapQty,
  oper.OpTotalConfirmedYieldQty AS OpTotalConfirmedYieldQty,
  oper.OperationConfirmedReworkQty AS OperationConfirmedReworkQty,
  conf.OpWorkQuantityUnit1 AS OpWorkQuantityUnit1,
  conf.OpConfirmedWorkQuantity1 AS OpConfirmedWorkQuantity1,
  conf.NoFurtherOpWorkQuantity1IsExpd AS NoFurtherOpWorkQuantity1IsExpd,
  conf.OpWorkQuantityUnit2 AS OpWorkQuantityUnit2,
  conf.OpConfirmedWorkQuantity2 AS OpConfirmedWorkQuantity2,
  conf.NoFurtherOpWorkQuantity2IsExpd AS NoFurtherOpWorkQuantity2IsExpd,
  conf.OpWorkQuantityUnit3 AS OpWorkQuantityUnit3,
  conf.OpConfirmedWorkQuantity3 AS OpConfirmedWorkQuantity3,
  conf.NoFurtherOpWorkQuantity3IsExpd AS NoFurtherOpWorkQuantity3IsExpd,
  conf.OpWorkQuantityUnit4 AS OpWorkQuantityUnit4,
  conf.OpConfirmedWorkQuantity4 AS OpConfirmedWorkQuantity4,
  conf.NoFurtherOpWorkQuantity4IsExpd AS NoFurtherOpWorkQuantity4IsExpd,
  conf.OpWorkQuantityUnit5 AS OpWorkQuantityUnit5,
  conf.OpConfirmedWorkQuantity5 AS OpConfirmedWorkQuantity5,
  conf.NoFurtherOpWorkQuantity5IsExpd AS NoFurtherOpWorkQuantity5IsExpd,
  conf.OpWorkQuantityUnit6 AS OpWorkQuantityUnit6,
  conf.OpConfirmedWorkQuantity6 AS OpConfirmedWorkQuantity6,
  conf.NoFurtherOpWorkQuantity6IsExpd AS NoFurtherOpWorkQuantity6IsExpd,
  conf.BusinessProcess AS BusinessProcess,
  conf.BusinessProcessEntryUnit AS BusinessProcessEntryUnit,
  conf.BusinessProcessConfirmedQty AS BusinessProcessConfirmedQty,
  conf.NoFurtherBusinessProcQtyIsExpd AS NoFurtherBusinessProcQtyIsExpd,
  conf.BusinessProcRemainingQtyUnit AS BusinessProcRemainingQtyUnit,
  conf.BusinessProcessRemainingQty AS BusinessProcessRemainingQty,
  conf._ConfirmationGroup AS _ConfirmationGroup,
  conf._ManufacturingOrder AS _ManufacturingOrder,
  conf._MfgOrder AS _MfgOrder,
  conf._MfgOrderSequence AS _MfgOrderSequence,
  conf._MfgOrderOperation AS _MfgOrderOperation,
  conf._MfgOrderCategory AS _MfgOrderCategory,
  conf._MfgOrderType AS _MfgOrderType,
  conf._OrdInternalBillOfOperations AS _OrdInternalBillOfOperations,
  conf._OrderInternalID AS _OrderInternalID,
  conf._ConfirmationUnit AS _ConfirmationUnit,
  item._ProductionUnit AS _ProductionUnit,
  conf._User AS _User,
  conf._Language AS _Language,
  conf._WorkCenterType AS _WorkCenterType,
  conf._WorkCenter AS _WorkCenter,
  conf._Plant AS _Plant,
  item._Material AS _Material,
  conf._ProductionPlant AS _ProductionPlant,
  conf._ProductionSupervisor AS _ProductionSupervisor,
  conf._MRPController AS _MRPController,
  item._MRPPlant AS _MRPPlant,
  item._MRPArea AS _MRPArea,
  conf._Capacity AS _Capacity,
  conf._BusinessArea AS _BusinessArea,
  conf._CompanyCode AS _CompanyCode,
  conf._ControllingArea AS _ControllingArea,
  conf._ProfitCenter AS _ProfitCenter,
  conf._BusinessProcess AS _BusinessProcess,
  conf._ProductCostCollector AS _ProductCostCollector,
  conf._VarianceReason AS _VarianceReason,
  conf._Employee AS _Employee,
  conf._EmployeeWageGroup AS _EmployeeWageGroup,
  conf._EmployeeSuitability AS _EmployeeSuitability
FROM I_MfgOrderOperationConf AS conf
INNER JOIN I_OrderItem AS item ON /* join condition not captured in parsed metadata */
INNER JOIN I_OrderOperation AS oper ON /* join condition not captured in parsed metadata */
INNER JOIN P_PPH_ReportingDate3 AS date ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_WorkCenterBySemanticKey AS _WorkCenterBySemanticKey ON WorkCenter = _WorkCenterBySemanticKey.WorkCenter AND ProductionPlant = _WorkCenterBySemanticKey.Plant  -- association [0..1]
LEFT OUTER JOIN I_CalendarDate AS _PostingDate ON PostingDate = _PostingDate.CalendarDate  -- association [1..1]
LEFT OUTER JOIN I_CalendarDate AS _EntryDate ON MfgOrderConfirmationEntryDate = _EntryDate.CalendarDate  -- association [1..1]
LEFT OUTER JOIN I_CalendarDate AS _LastChangeDate ON LastChangeDate = _LastChangeDate.CalendarDate  -- association [0..1]
LEFT OUTER JOIN I_WeekDay AS _EntryDateWeekDay ON EntryDateWeekDay = _EntryDateWeekDay.WeekDay  -- association [0..1]
LEFT OUTER JOIN I_CalendarMonth AS _EntryDateMonth ON EntryDateMonth = _EntryDateMonth.CalendarMonth  -- association [0..1]
LEFT OUTER JOIN I_ReportingPeriod AS _ReportingPeriod ON ReportingPeriod = _ReportingPeriod.ReportingPeriod  -- association [1..1]
;