I_MfgOrderConfirmation

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_MfgOrderConfirmation.
-- 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: IPPMFGORDCONF

CREATE VIEW I_MfgOrderConfirmation AS
SELECT
  conf.ConfirmationGroup AS MfgOrderConfirmationGroup,
  conf.OrderConfirmation AS MfgOrderConfirmation,
  cast(conf.OrderID as manufacturingorder preserving type) AS ManufacturingOrder,
  cast(conf.Sequence as manufacturingordersequence preserving type) AS ManufacturingOrderSequence,
  cast(conf.OrderOperation as co_vornr preserving type) AS ManufacturingOrderOperation,
  conf.OrderOperation_2 AS ManufacturingOrderOperation_2,
  cast(conf.OrderCategory as manufacturingordercategory preserving type) AS ManufacturingOrderCategory,
  cast(conf.OrderType as manufacturingordertype preserving type) AS ManufacturingOrderType,
  conf.OrderInternalID AS OrderInternalID,
  conf.OrderOperationInternalID AS OrderOperationInternalID,
  conf.SuperiorOperationInternalID AS SuperiorOperationInternalID,
  conf.ConfirmationText AS ConfirmationText,
  conf.Language AS Language,
  conf.LongTextExists AS LongTextExists,
  conf.ConfirmationEntryDate AS MfgOrderConfirmationEntryDate,
  conf.ConfirmationEntryTime AS MfgOrderConfirmationEntryTime,
  conf.EnteredByUser AS EnteredByUser,
  conf.LastChangeDate AS LastChangeDate,
  conf.LastChangedByUser AS LastChangedByUser,
  conf.ConfirmationExternalEntryDate AS ConfirmationExternalEntryDate,
  conf.ConfirmationExternalEntryTime AS ConfirmationExternalEntryTime,
  conf.EnteredByExternalUser AS EnteredByExternalUser,
  conf.ExternalSystemConfirmation AS ExternalSystemConfirmation,
  conf.FinalConfirmationType AS FinalConfirmationType,
  conf.IsFinalConfirmation AS IsFinalConfirmation,
  conf.OpenReservationsIsCleared AS OpenReservationsIsCleared,
  conf.IsReversed AS IsReversed,
  conf.IsReversal AS IsReversal,
  conf.CancldMfgOrderConfCount AS CancldMfgOrderConfCount,
  conf.APIConfHasNoGoodsMovements AS APIConfHasNoGoodsMovements,
  conf.ConfirmationApplicationOrigin AS ConfirmationApplicationOrigin,
  conf.OrderConfirmationType AS OrderConfirmationType,
  conf.OrderConfirmationRecordType AS OrderConfirmationRecordType,
  conf.MilestoneIsConfirmed AS MilestoneIsConfirmed,
  conf.MilestoneConfirmationType AS MilestoneConfirmationType,
  conf.IsConfirmedByMilestoneConf AS IsConfirmedByMilestoneConf,
  conf.MilestoneConfirmationGroup AS MilestoneConfirmationGroup,
  conf.MilestoneConfirmation AS MilestoneConfirmation,
  conf.Plant AS Plant,
  conf.WorkCenterTypeCode AS WorkCenterTypeCode,
  conf.WorkCenterInternalID AS WorkCenterInternalID,
  conf.CapacityInternalID AS CapacityInternalID,
  conf.CapacityRequirementSplit AS CapacityRequirementSplit,
  conf.ShiftGrouping AS ShiftGrouping,
  conf.MaterialDocument AS MaterialDocument,
  conf.MaterialDocumentYear AS MaterialDocumentYear,
  conf.FailedGoodsMovement AS FailedGoodsMovement,
  conf.PlantDataCollectionID AS PlantDataCollectionID,
  conf.OriginalBatch AS OriginalBatch,
  conf.BatchBySupplier AS BatchBySupplier,
  conf.BusinessArea AS BusinessArea,
  conf.CompanyCode AS CompanyCode,
  conf.ControllingArea AS ControllingArea,
  conf.ProfitCenter AS ProfitCenter,
  conf.SenderCostCenter AS SenderCostCenter,
  conf.ProductCostCollector AS ProductCostCollector,
  conf.Personnel AS Personnel,
  conf.TimeRecording AS TimeRecording,
  conf.EmployeeWageType AS EmployeeWageType,
  conf.EmployeeWageGroup AS EmployeeWageGroup,
  conf.EmployeeSuitability AS EmployeeSuitability,
  conf.NumberOfEmployees AS NumberOfEmployees,
  conf.PostingDate AS PostingDate,
  conf.PostingDateYear AS PostingDateYear,
  conf.ConfirmedExecutionStartDate AS ConfirmedExecutionStartDate,
  conf.ConfirmedExecutionStartTime AS ConfirmedExecutionStartTime,
  conf.ConfirmedSetupEndDate AS ConfirmedSetupEndDate,
  conf.ConfirmedSetupEndTime AS ConfirmedSetupEndTime,
  conf.ConfirmedProcessingStartDate AS ConfirmedProcessingStartDate,
  conf.ConfirmedProcessingStartTime AS ConfirmedProcessingStartTime,
  conf.ConfirmedProcessingEndDate AS ConfirmedProcessingEndDate,
  conf.ConfirmedProcessingEndTime AS ConfirmedProcessingEndTime,
  conf.ConfirmedTeardownStartDate AS ConfirmedTeardownStartDate,
  conf.ConfirmedTeardownStartTime AS ConfirmedTeardownStartTime,
  conf.ConfirmedExecutionEndDate AS ConfirmedExecutionEndDate,
  conf.ConfirmedExecutionEndTime AS ConfirmedExecutionEndTime,
  conf.ConfirmationUnit AS ConfirmationUnit,
  conf.ConfirmationYieldQuantity AS ConfirmationYieldQuantity,
  conf.ConfirmationScrapQuantity AS ConfirmationScrapQuantity,
  conf.ConfirmationReworkQuantity AS ConfirmationReworkQuantity,
  conf.ConfirmationTotalQuantity AS ConfirmationTotalQuantity,
  conf.VarianceReasonCode AS VarianceReasonCode,
  cast(OrderQuantityUnit as productionunit preserving type) AS ProductionUnit,
  cast(ConfirmedYieldQtyInOrderUnit as ru_gmnga preserving type) AS ConfYieldQtyInProductionUnit,
  conf.OperationUnit AS OperationUnit,
  conf.OpPlannedTotalQuantity AS OpPlannedTotalQuantity,
  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.BreakDurationUnit AS BreakDurationUnit,
  conf.ConfirmedBreakDuration AS ConfirmedBreakDuration,
  conf._ConfirmationGroup AS _ConfirmationGroup,
  conf._OrderInternalID AS _OrderInternalID,
  conf._ConfirmationUnit AS _ConfirmationUnit,
  conf._OperationUnit AS _OperationUnit,
  conf._FinalConfirmationType AS _FinalConfirmationType,
  conf._ConfirmationType AS _ConfirmationType,
  conf._ConfirmationRecordType AS _ConfirmationRecordType,
  conf._ConfirmationApplOrigin AS _ConfirmationApplOrigin,
  conf._MilestoneConfirmationGroup AS _MilestoneConfirmationGroup,
  conf._MilestoneConfirmation AS _MilestoneConfirmation,
  conf._User AS _User,
  conf._UserContactCard AS _UserContactCard,
  conf._Language AS _Language,
  conf._WorkCenterType AS _WorkCenterType,
  conf._WorkCenter AS _WorkCenter,
  conf._Plant AS _Plant,
  conf._Capacity AS _Capacity,
  conf._ShiftGrouping AS _ShiftGrouping,
  conf._ShiftDefinition AS _ShiftDefinition,
  conf._BusinessArea AS _BusinessArea,
  conf._CompanyCode AS _CompanyCode,
  conf._ControllingArea AS _ControllingArea,
  conf._ProductCostCollector AS _ProductCostCollector,
  conf._BusinessProcess AS _BusinessProcess,
  conf._BusinessProcessUnit AS _BusinessProcessUnit,
  conf._WorkQuantityUnit1 AS _WorkQuantityUnit1,
  conf._WorkQuantityUnit2 AS _WorkQuantityUnit2,
  conf._WorkQuantityUnit3 AS _WorkQuantityUnit3,
  conf._WorkQuantityUnit4 AS _WorkQuantityUnit4,
  conf._WorkQuantityUnit5 AS _WorkQuantityUnit5,
  conf._WorkQuantityUnit6 AS _WorkQuantityUnit6,
  conf._BreakDurationUnit AS _BreakDurationUnit,
  conf._VarianceReason AS _VarianceReason,
  conf._EmployeeWageGroup AS _EmployeeWageGroup,
  conf._EmployeeSuitability AS _EmployeeSuitability,
  conf._Employee AS _Employee,
  conf._PersonWorkAgreement AS _PersonWorkAgreement,
  conf._MaterialDocument AS _MaterialDocument,
  conf._MaterialDocument3 AS _MaterialDocument3,
  conf._MaterialDocumentYear AS _MaterialDocumentYear,
  conf._PostingDate AS _PostingDate,
  conf._PostingDateYear AS _PostingDateYear,
  conf._FinalConfIndicator AS _FinalConfIndicator,
  conf._ReversedIndicator AS _ReversedIndicator,
  conf._ReversalIndicator AS _ReversalIndicator,
  conf._LongTextIndicator AS _LongTextIndicator,
  conf._LongText AS _LongText
FROM I_OrderConfirmation AS conf
LEFT OUTER JOIN I_ManufacturingOrder AS _MfgOrder ON ManufacturingOrder = _MfgOrder.ManufacturingOrder  -- association [1..1]
LEFT OUTER JOIN I_MfgOrder AS _MfgOrder2 ON ManufacturingOrder = _MfgOrder2.ManufacturingOrder  -- association [1..1]
LEFT OUTER JOIN I_MfgOrderSequence AS _MfgOrderSequence ON ManufacturingOrder = _MfgOrderSequence.ManufacturingOrder AND ManufacturingOrderSequence = _MfgOrderSequence.ManufacturingOrderSequence  -- association [0..1]
LEFT OUTER JOIN I_ManufacturingOrderSequence AS _MfgOrderSequence2 ON ManufacturingOrder = _MfgOrderSequence2.ManufacturingOrder AND ManufacturingOrderSequence = _MfgOrderSequence2.ManufacturingOrderSequence  -- association [0..1]
LEFT OUTER JOIN I_MfgOrderOperationBySemanKey AS _MfgOrderOperation ON ManufacturingOrder = _MfgOrderOperation.ManufacturingOrder AND ManufacturingOrderSequence = _MfgOrderOperation.ManufacturingOrderSequence AND ManufacturingOrderOperation = _MfgOrderOperation.ManufacturingOrderOperation  -- association [1..1]
LEFT OUTER JOIN I_MfgOrderOperationBySemKey AS _MfgOrderOperation2 ON ManufacturingOrder = _MfgOrderOperation2.ManufacturingOrder AND ManufacturingOrderSequence = _MfgOrderOperation2.ManufacturingOrderSequence AND ManufacturingOrderOperation_2 = _MfgOrderOperation2.ManufacturingOrderOperation  -- 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_UnitOfMeasure AS _ProductionUnit ON ProductionUnit = _ProductionUnit.UnitOfMeasure  -- association [1..1]
LEFT OUTER JOIN I_MaterialDocumentHeader AS _MaterialDocument2 ON MaterialDocument = _MaterialDocument2.MaterialDocument AND MaterialDocumentYear = _MaterialDocument2.MaterialDocumentYear  -- association [0..1]
LEFT OUTER JOIN I_FailedGoodsMovement AS _FailedGoodsMovement ON FailedGoodsMovement = _FailedGoodsMovement.FailedGoodsMovement  -- association [0..1]
LEFT OUTER JOIN I_MfgOrderConfirmationLongText AS _MfgOrderConfLongText ON MfgOrderConfirmationGroup = _MfgOrderConfLongText.MfgOrderConfirmationGroup AND MfgOrderConfirmation = _MfgOrderConfLongText.MfgOrderConfirmationCount  -- association [0..*]
LEFT OUTER JOIN I_MfgOrderConfMatlDocItem AS _ConfMatlDocItem ON MfgOrderConfirmationGroup = _ConfMatlDocItem.MfgOrderConfirmationGroup AND MfgOrderConfirmation = _ConfMatlDocItem.MfgOrderConfirmation  -- association [0..*]
LEFT OUTER JOIN I_FailedGoodsMovementItem AS _ConfFailedGdsMvtItem ON MfgOrderConfirmationGroup = _ConfFailedGdsMvtItem.ConfirmationGroup AND MfgOrderConfirmation = _ConfFailedGdsMvtItem.ConfirmationCount  -- association [0..*]
LEFT OUTER JOIN I_ConfFailedActualCostCalc AS _ConfFailedActualCost ON MfgOrderConfirmationGroup = _ConfFailedActualCost.ConfirmationGroup AND MfgOrderConfirmation = _ConfFailedActualCost.OrderConfirmation  -- association [0..*]
LEFT OUTER JOIN E_OrderConfirmation AS _Extension ON MfgOrderConfirmationGroup = _Extension.ConfirmationGroup AND MfgOrderConfirmation = _Extension.ConfirmationCount  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _PlantText ON Plant = _PlantText.Plant  -- association [1..1]
LEFT OUTER JOIN I_ManufacturingOrder AS _MfgOrderText ON ManufacturingOrder = _MfgOrderText.ManufacturingOrder  -- association [1..1]
LEFT OUTER JOIN I_WorkCenterText AS _WorkCenterText ON WorkCenterInternalID = _WorkCenterText.WorkCenterInternalID AND WorkCenterTypeCode = _WorkCenterText.WorkCenterTypeCode  -- association [0..*]
LEFT OUTER JOIN I_PersonWorkAgreement_1 AS _PersonWorkAgreementText ON Personnel = _PersonWorkAgreementText.PersonWorkAgreement  -- association [0..1]
LEFT OUTER JOIN I_BusinessAreaText AS _BusinessAreaText ON BusinessArea = _BusinessAreaText.BusinessArea  -- association [0..*]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCodeText ON CompanyCode = _CompanyCodeText.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_ControllingArea AS _ControllingAreaText ON ControllingArea = _ControllingAreaText.ControllingArea  -- association [0..1]
;