I_MfgOrderFailedConfirmation

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_MfgOrderFailedConfirmation.
-- 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: IMFGORDFAILCONF

CREATE VIEW I_MfgOrderFailedConfirmation AS
SELECT
  afrv.ConfirmationApplicationOrigin AS ConfirmationApplicationOrigin,
  afrv.FailedOrderConfirmationGroup AS FailedOrderConfirmationGroup,
  afrv.FailedOrderConfirmation AS FailedOrderConfirmation,
  afrv.FailedOrderConfirmationText AS FailedOrderConfirmationText,
  afrv.ConfirmationEntryDate AS ConfirmationEntryDate,
  afrv.ConfirmationEntryTime AS ConfirmationEntryTime,
  afrv.ConfirmationExternalEntryDate AS ConfirmationExternalEntryDate,
  afrv.ConfirmationExternalEntryTime AS ConfirmationExternalEntryTime,
  afrv.EnteredByExternalUser AS EnteredByExternalUser,
  afrv.OpenReservationsIsCleared AS OpenReservationsIsCleared,
  afrv.IsFinalConfirmation AS IsFinalConfirmation,
  afrv.FinalConfirmationType AS FinalConfirmationType,
  afrv.OrderConfirmationRecordType AS OrderConfirmationRecordType,
  afrv.SequentialPlantDataCollection AS SequentialPlantDataCollection,
  afrv.ConfirmationGroup AS ConfirmationGroup,
  afrv.ConfirmationCount AS ConfirmationCount,
  afrv.OrderCategory AS ManufacturingOrderCategory,
  afrv.OrderID AS ManufacturingOrder,
  afrv.Sequence AS ManufacturingOrderSequence,
  afrv.Operation AS ManufacturingOrderOperation,
  afrv.Plant AS Plant,
  afrv.WorkCenter AS WorkCenter,
  afrv.CapacityCategory AS CapacityCategory,
  afrv.CapacityRequirementSplit AS CapacityRequirementSplit,
  afrv.BusinessArea AS BusinessArea,
  afrv.CompanyCode AS CompanyCode,
  afrv.ControllingArea AS ControllingArea,
  afrv.Personnel AS Personnel,
  afrv.TimeRecording AS TimeRecording,
  afrv.EmployeeWageType AS EmployeeWageType,
  afrv.EmployeeWageGroup AS EmployeeWageGroup,
  afrv.EmployeeSuitability AS EmployeeSuitability,
  afrv.NumberOfEmployees AS NumberOfEmployees,
  afrv.PostingDate AS PostingDate,
  afrv.PostingDateYear AS PostingDateYear,
  afrv.ConfirmedExecutionStartDate AS ConfirmedExecutionStartDate,
  afrv.ConfirmedExecutionStartTime AS ConfirmedExecutionStartTime,
  afrv.ConfirmedSetupEndDate AS ConfirmedSetupEndDate,
  afrv.ConfirmedSetupEndTime AS ConfirmedSetupEndTime,
  afrv.ConfirmedProcessingStartDate AS ConfirmedProcessingStartDate,
  afrv.ConfirmedProcessingStartTime AS ConfirmedProcessingStartTime,
  afrv.ConfirmedProcessingEndDate AS ConfirmedProcessingEndDate,
  afrv.ConfirmedProcessingEndTime AS ConfirmedProcessingEndTime,
  afrv.ConfirmedTeardownStartDate AS ConfirmedTeardownStartDate,
  afrv.ConfirmedTeardownStartTime AS ConfirmedTeardownStartTime,
  afrv.ConfirmedExecutionEndDate AS ConfirmedExecutionEndDate,
  afrv.ConfirmedExecutionEndTime AS ConfirmedExecutionEndTime,
  afrv.ConfirmationUnit AS ConfirmationUnit,
  afrv.ConfirmationYieldQuantity AS ConfirmationYieldQuantity,
  afrv.ConfirmationScrapQuantity AS ConfirmationScrapQuantity,
  afrv.ConfirmationReworkQuantity AS ConfirmationReworkQuantity,
  afrv.ConfirmationTotalQuantity AS ConfirmationTotalQuantity,
  afrv.VarianceReasonCode AS VarianceReasonCode,
  afrv.OpWorkQuantityUnit1 AS OpWorkQuantityUnit1,
  afrv.OpConfirmedWorkQuantity1 AS OpConfirmedWorkQuantity1,
  afrv.NoFurtherOpWorkQuantity1IsExpd AS NoFurtherOpWorkQuantity1IsExpd,
  afrv.OpWorkQuantityUnit2 AS OpWorkQuantityUnit2,
  afrv.OpConfirmedWorkQuantity2 AS OpConfirmedWorkQuantity2,
  afrv.NoFurtherOpWorkQuantity2IsExpd AS NoFurtherOpWorkQuantity2IsExpd,
  afrv.OpWorkQuantityUnit3 AS OpWorkQuantityUnit3,
  afrv.OpConfirmedWorkQuantity3 AS OpConfirmedWorkQuantity3,
  afrv.NoFurtherOpWorkQuantity3IsExpd AS NoFurtherOpWorkQuantity3IsExpd,
  afrv.OpWorkQuantityUnit4 AS OpWorkQuantityUnit4,
  afrv.OpConfirmedWorkQuantity4 AS OpConfirmedWorkQuantity4,
  afrv.NoFurtherOpWorkQuantity4IsExpd AS NoFurtherOpWorkQuantity4IsExpd,
  afrv.OpWorkQuantityUnit5 AS OpWorkQuantityUnit5,
  afrv.OpConfirmedWorkQuantity5 AS OpConfirmedWorkQuantity5,
  afrv.NoFurtherOpWorkQuantity5IsExpd AS NoFurtherOpWorkQuantity5IsExpd,
  afrv.OpWorkQuantityUnit6 AS OpWorkQuantityUnit6,
  afrv.OpConfirmedWorkQuantity6 AS OpConfirmedWorkQuantity6,
  afrv.NoFurtherOpWorkQuantity6IsExpd AS NoFurtherOpWorkQuantity6IsExpd,
  afrv.BusinessProcess AS BusinessProcess,
  afrv.BusinessProcessEntryUnit AS BusinessProcessEntryUnit,
  afrv.BusinessProcessConfirmedQty AS BusinessProcessConfirmedQty,
  afrv.NoFurtherBusinessProcQtyIsExpd AS NoFurtherBusinessProcQtyIsExpd,
  afrv.BusinessProcRemainingQtyUnit AS BusinessProcRemainingQtyUnit,
  afrv.BusinessProcessRemainingQty AS BusinessProcessRemainingQty,
  afrv.ActualDurationUnit AS ActualDurationUnit,
  afrv.ActualDuration AS ActualDuration,
  afrv.BreakDurationUnit AS BreakDurationUnit,
  afrv.ConfirmedBreakDuration AS ConfirmedBreakDuration
FROM I_FailedOrderConfirmation AS afrv
LEFT OUTER JOIN I_MfgOrderCategory AS _ManufacturingOrderCategory ON ManufacturingOrderCategory = _ManufacturingOrderCategory.ManufacturingOrderCategory  -- association [0..1]
LEFT OUTER JOIN I_ManufacturingOrder AS _ManufacturingOrder ON ManufacturingOrder = _ManufacturingOrder.ManufacturingOrder  -- association [1..1]
LEFT OUTER JOIN I_ManufacturingOrderSequence AS _ManufacturingOrderSequence ON ManufacturingOrder = _ManufacturingOrderSequence.ManufacturingOrder AND ManufacturingOrderSequence = _ManufacturingOrderSequence.ManufacturingOrderSequence  -- association [1..1]
LEFT OUTER JOIN I_MfgOrderOperationBySemKey AS _ManufacturingOrderOperation ON ManufacturingOrder = _ManufacturingOrderOperation.ManufacturingOrder AND ManufacturingOrderSequence = _ManufacturingOrderOperation.ManufacturingOrderSequence AND ManufacturingOrderOperation = _ManufacturingOrderOperation.ManufacturingOrderOperation  -- association [1..1]
LEFT OUTER JOIN I_MfgOrderFailedConfLog AS _FailedConfirmationLog ON SequentialPlantDataCollection = _FailedConfirmationLog.SequentialPlantDataCollection  -- association [0..1]
LEFT OUTER JOIN I_MfgOrderFailedConfGroup AS _FailedOrderConfirmationGroup ON ConfirmationApplicationOrigin = _FailedOrderConfirmationGroup.ConfirmationApplicationOrigin AND FailedOrderConfirmationGroup = _FailedOrderConfirmationGroup.FailedOrderConfirmationGroup  -- association [1..1]
;