I_ProcOrdMgmtConfirmation

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_ProcOrdMgmtConfirmation.
-- 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: IPROCORDMGMTCONF

CREATE VIEW I_ProcOrdMgmtConfirmation AS
SELECT
  MfgOrderConfirmationGroup AS ConfirmationGroup,
  MfgOrderConfirmation AS ConfirmationCount,
  afru.ManufacturingOrder AS ProcessOrder,
  cast( _Op.MfgOrderPhaseSuperiorOperation as manufacturingorderoperation preserving type ) AS MfgOrderPhaseSuperiorOperation,
  afru.ManufacturingOrderType AS ManufacturingOrderType,
  afru.OrderInternalID AS OrderInternalBillOfOperations,
  afru.OrderOperationInternalID AS OrderIntBillOfOperationsItem,
  afru.SuperiorOperationInternalID AS SuperiorOperationInternalID,
  afru.ConfirmationText AS ConfirmationText,
  afru.Language AS Language,
  afru._MfgOrder.Material AS Material,
  afru._MfgOrder.MfgOrderPlannedTotalQty AS MfgOrderPlannedTotalQty,
  afru._MfgOrder.ProductionUnit AS ProductionUnit,
  afru.WorkCenterInternalID AS WorkCenterInternalID,
  FinalConfirmationType,
  IsFinalConfirmation,
  OpenReservationsIsCleared,
  IsReversed,
  IsReversal,
  APIConfHasNoGoodsMovements,
  OrderConfirmationRecordType,
  case MfgOrderConfirmationEntryTime when '240000' then cast(cast(concat(MfgOrderConfirmationEntryDate,cast('235959' as tims))as abap.numc(15)) as timestamp) else cast(cast(concat(MfgOrderConfirmationEntryDate , MfgOrderConfirmationEntryTime)as abap.numc(15)) as timestamp) end as ConfirmedDateTime AS numc15astimestampendasConfirmedDateTime,
  MfgOrderConfirmationEntryDate,
  MfgOrderConfirmationEntryTime,
  EnteredByUser,
  LastChangeDate,
  LastChangedByUser,
  ConfirmationExternalEntryDate,
  ConfirmationExternalEntryTime,
  EnteredByExternalUser,
  ExternalSystemConfirmation,
  afru.Plant AS Plant,
  PostingDate,
  ConfirmedExecutionStartDate,
  ConfirmedExecutionStartTime,
  ConfirmedSetupEndDate,
  ConfirmedSetupEndTime,
  ConfirmedProcessingStartDate,
  ConfirmedProcessingStartTime,
  ConfirmedProcessingEndDate,
  ConfirmedProcessingEndTime,
  ConfirmedTeardownStartDate,
  ConfirmedTeardownStartTime,
  ConfirmedExecutionEndDate,
  ConfirmedExecutionEndTime,
  ConfirmationUnit,
  ConfirmationYieldQuantity,
  ConfirmationScrapQuantity,
  afru.OpConfirmedWorkQuantity1 AS OpConfirmedWorkQuantity1,
  afru.OpWorkQuantityUnit1 AS OpWorkQuantityUnit1,
  _ActivityTexts.WorkCenterActivityText1 AS WorkCenterActivityText1,
  afru.OpConfirmedWorkQuantity2 AS OpConfirmedWorkQuantity2,
  afru.OpWorkQuantityUnit2 AS OpWorkQuantityUnit2,
  _ActivityTexts.WorkCenterActivityText2 AS WorkCenterActivityText2,
  afru.OpConfirmedWorkQuantity3 AS OpConfirmedWorkQuantity3,
  afru.OpWorkQuantityUnit3 AS OpWorkQuantityUnit3,
  _ActivityTexts.WorkCenterActivityText3 AS WorkCenterActivityText3,
  afru.OpConfirmedWorkQuantity4 AS OpConfirmedWorkQuantity4,
  afru.OpWorkQuantityUnit4 AS OpWorkQuantityUnit4,
  _ActivityTexts.WorkCenterActivityText4 AS WorkCenterActivityText4,
  afru.OpConfirmedWorkQuantity5 AS OpConfirmedWorkQuantity5,
  afru.OpWorkQuantityUnit5 AS OpWorkQuantityUnit5,
  _ActivityTexts.WorkCenterActivityText5 AS WorkCenterActivityText5,
  afru.OpConfirmedWorkQuantity6 AS OpConfirmedWorkQuantity6,
  afru.OpWorkQuantityUnit6 AS OpWorkQuantityUnit6,
  _ActivityTexts.WorkCenterActivityText6 AS WorkCenterActivityText6,
  afru._LongText.PlainLongText AS PlainLongText
FROM I_MfgOrderConfirmation AS afru
LEFT OUTER JOIN I_WorkCenterActivityTexts AS _ActivityTexts ON WorkCenterInternalID = _ActivityTexts.WorkCenterInternalID AND _ActivityTexts.WorkCenterTypeCode = 'A'  -- association [0..1]
;