C_MfgProcgExecOperation

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 C_MfgProcgExecOperation.
-- 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: CMPEOPER

CREATE VIEW C_MfgProcgExecOperation AS
SELECT
  MfgProcgExecOperation.OrderIntBillOfOperationsItem AS OrderOperationInternalID,
  MfgProcgExecOperation.ManufacturingOrderCategory AS ManufacturingOrderCategory,
  MfgProcgExecOperation.ManufacturingOrderType AS ManufacturingOrderType,
  MfgProcgExecOperation.Reservation AS Reservation,
  cast(MfgProcgExecOperation.ProdnProcgIsFlexible as mpe_procg_flexibility_ind preserving type) AS ProdnProcgIsFlexible,
  _ProdnProcgFlexibilityIndTxt[1: Language=$session.system_language].ProdnProcgFlexibilityIndName AS ProdnProcgFlexibilityIndName,
  MfgProcgExecOperation.ProductionPlant AS ProductionPlant,
  _ProductionPlant.PlantName AS PlantName,
  MfgProcgExecOperation.MfgOrderOperationText AS MfgOrderOperationText,
  MfgProcgExecOperation.ProduceOpActyNtwkInstance AS ProduceOpActyNtwkInstance,
  cast('00' as numc2 preserving type) AS OperationStatusInternalID,
  cast(' ' as j_istat preserving type) AS OrderOperationMainStatusCode,
  cast(' ' as j_txt30 preserving type) AS OrderOperationMainStatusName,
  MfgProcgExecOperation._Material._Text[1: Language=$session.system_language].MaterialName AS MaterialName,
  _WBSElementBasicData.WBSElementExternalID AS WBSElementExternalID,
  _WBSElementBasicData.WBSDescription AS WBSDescription,
  WBSElementInternalID,
  MfgProcgExecOperation.WorkCenterTypeCode AS WorkCenterTypeCode,
  MfgProcgExecOperation._WorkCenter.WorkCenter AS WorkCenter,
  _WorkCenter._Text[1: Language=$session.system_language].WorkCenterText AS WorkCenterText,
  _WorkCenter.WorkCenterLocation AS WorkCenterLocation,
  _WorkCenter.WorkCenterResponsible AS WorkCenterResponsible,
  _WorkCenter._WorkCenterResponsible.WorkCenterResponsibleName AS WorkCenterResponsibleName,
  _WorkCenter.SupplyArea AS SupplyArea,
  MfgProcgExecOperation.PlantTimeZone AS PlantTimeZone,
  MfgProcgExecOperation.OpLtstSchedldExecStrtDte AS OpLtstSchedldExecStrtDte,
  MfgProcgExecOperation.OpLtstSchedldExecStrtTme AS OpLtstSchedldExecStrtTme,
  MfgProcgExecOperation.OpLtstSchedldExecStrtDteTme AS OpLtstSchedldExecStrtDteTme,
  MfgProcgExecOperation.OpLtstSchedldExecEndDte AS OpLtstSchedldExecEndDte,
  MfgProcgExecOperation.OpLtstSchedldExecEndTme AS OpLtstSchedldExecEndTme,
  MfgProcgExecOperation.OpLtstSchedldExecEndDteTme AS OpLtstSchedldExecEndDteTme,
  MfgProcgExecOperation.OpActualExecutionStartDate AS OpActualExecutionStartDate,
  MfgProcgExecOperation.OpActualExecutionStartTime AS OpActualExecutionStartTime,
  MfgProcgExecOperation.OpActualExecutionEndDate AS OpActualExecutionEndDate,
  MfgProcgExecOperation.OpActualExecutionEndTime AS OpActualExecutionEndTime,
  MfgProcgExecOperation.OpActualExecutionEndDateTime AS OpActualExecutionEndDateTime,
  MfgProcgExecOperation.OpPlannedTotalQuantity AS OpPlannedTotalQuantity,
  MfgProcgExecOperation.OpTotalConfirmedYieldQty AS OpTotalConfirmedYieldQty,
  MfgProcgExecOperation.OpTotalConfirmedScrapQty AS OpTotalConfirmedScrapQty,
  MfgProcgExecOperation.OperationUnit AS OperationUnit,
  MfgProcgExecOperation.OperationExecutionStartIsLate AS OperationExecutionStartIsLate,
  MfgProcgExecOperation.OpActyNtwkInstance AS OpActyNtwkInstance,
  MfgProcgExecOperation.OperationActivityNetwork AS OperationActivityNetwork,
  MfgProcgExecOperation.OpActyNtwkVersionCounter AS OpActyNtwkVersionCounter,
  cast(MfgProcgExecOperation.OpActyConfIsSFIBased as boolean) AS OpActyConfIsSFIBased,
  MfgProcgExecOperation.OperationIsTechlyCompleted AS OperationIsTechlyCompleted,
  MfgProcgExecOperation.OperationIsDelivered AS OperationIsDelivered,
  MfgProcgExecOperation.OperationIsPartiallyDelivered AS OperationIsPartiallyDelivered,
  MfgProcgExecOperation.OperationIsPartiallyConfirmed AS OperationIsPartiallyConfirmed,
  MfgProcgExecOperation.OperationIsPrinted AS OperationIsPrinted,
  cast(MfgProcgExecOperation.OperationIsReleased as mpe_char1 preserving type) AS OperationIsReleased,
  MfgProcgExecOperation.OperationIsCreated AS OperationIsCreated,
  MfgProcgExecOperation.OperationIsScheduled AS OperationIsScheduled,
  MfgProcgExecOperation.OperationIsConfirmed AS OperationIsConfirmed,
  MfgProcgExecOperation.OperationIsDeleted AS OperationIsDeleted,
  MfgProcgExecOperation.OperationExecutionEndIsLate AS OperationExecutionEndIsLate,
  MfgProcgExecOperation.OperationYieldDeviationQty AS OperationYieldDeviationQty,
  MfgProcgExecOperation.ExecutionStartLatenessInHours AS ExecutionStartLatenessInHours,
  MfgProcgExecOperation.ExecutionEndLatenessInHours AS ExecutionEndLatenessInHours,
  MfgProcgExecOperation.ExecutionStartLatenessInMins AS ExecutionStartLatenessInMins,
  MfgProcgExecOperation.ExecutionEndLatenessInMinutes AS ExecutionEndLatenessInMinutes,
  MfgProcgExecOperation.OperationStartDeviationDays AS OperationStartDeviationDays,
  MfgProcgExecOperation.PlannedEndDateDvtnInDays AS PlannedEndDateDvtnInDays,
  cast('' as boolean preserving type) AS OperationHasProductionHold,
  MfgProcgExecOperation.NumberOfMaterialHolds AS NumberOfMaterialHolds,
  MfgProcgExecOperation.NumberOfWorkCenterHolds AS NumberOfWorkCenterHolds,
  MfgProcgExecOperation.NumberOfOrderHolds AS NumberOfOrderHolds,
  MfgProcgExecOperation.NumberOfOperationHolds AS NumberOfOperationHolds,
  MfgProcgExecOperation.NumberOfOperationActivityHolds AS NumberOfOperationActivityHolds,
  cast('' as mpe_effectivity_parameter_desc) AS EffectivityParameterDesc,
  cast('' as mpe_effecty_type_param_desc) AS EffctyTypeCnctntdParamDesc,
  cast(MfgProcgExecOperation.OrderIsShopFloorOrder as boolean preserving type) AS OrderIsShopFloorOrder,
  MfgProcgExecOperation._WorkCenter AS _WorkCenter,
  MfgProcgExecOperation._ProductionPlant AS _ProductionPlant,
  MfgProcgExecOperation._OpActyNtwkInternalId AS _OpActyNtwkInternalId,
  MfgProcgExecOperation._OperationActivityNetwork AS _OperationActivityNetwork
FROM P_MfgProcgExecOperation AS MfgProcgExecOperation
LEFT OUTER JOIN P_OpActyNtwrkInstceAggrgdScrap AS _OperationScrappedQuantity ON MfgProcgExecOperation.OpActyNtwkInstance = _OperationScrappedQuantity.OpActyNtwkInstance  -- association [0..1]
LEFT OUTER JOIN P_MfgOrdOpHasMissingParts AS _MfgOrdOpHasMissingPart ON Reservation = _MfgOrdOpHasMissingPart.Reservation AND OrderOperationInternalID = _MfgOrdOpHasMissingPart.OrderIntBillOfOperationsItem  -- association [0..1]
LEFT OUTER JOIN C_MfgOrderOperationMissingComp AS _MfgOrderOperationMissingComp ON ManufacturingOrder = _MfgOrderOperationMissingComp.ManufacturingOrder AND ManufacturingOrderOperation = _MfgOrderOperationMissingComp.ManufacturingOrderOperation AND ManufacturingOrderSequence = _MfgOrderOperationMissingComp.ManufacturingOrderSequence  -- association [0..*]
LEFT OUTER JOIN C_ProcgExecOperationActivity AS _ProcgExecOperationActivity ON OpActyNtwkInstance = _ProcgExecOperationActivity.OpActyNtwkInstance  -- association [0..*]
LEFT OUTER JOIN P_OperationProdnRsceToolAssAgg AS _OperationProdnRsceToolAssAgg ON OpActyNtwkInstance = _OperationProdnRsceToolAssAgg.OpActyNtwkInstance  -- association [0..1]
LEFT OUTER JOIN C_MfgOrderOperationHold AS _MfgOrderOperationHold ON OrderInternalID = _MfgOrderOperationHold.OrderInternalID AND OrderOperationInternalID = _MfgOrderOperationHold.OrderOperationInternalID  -- association [0..*]
LEFT OUTER JOIN I_OrderItem AS _OrderItem ON ManufacturingOrder = _OrderItem.OrderID AND _OrderItem.OrderItem = '0001'  -- association [0..1]
LEFT OUTER JOIN I_ProdnProcgFlexibilityIndTxt AS _ProdnProcgFlexibilityIndTxt ON ProdnProcgIsFlexible = _ProdnProcgFlexibilityIndTxt.ProdnProcgIsFlexible  -- association [0..*]
;