C_OrderWorkCenterSchedule

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_OrderWorkCenterSchedule.
-- 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.

CREATE VIEW C_OrderWorkCenterSchedule AS
SELECT
  OrderInternalBillOfOperations,
  OrderIntBillOfOperationsItem,
  cast(ManufacturingOrder as aufnr preserving type) AS ManufacturingOrder,
  ManufacturingOrderOperation,
  MfgOrderOperationText,
  _MfgOrder._Material._Text[1: Language=$session.system_language].MaterialName AS MaterialName,
  _OrderOperation._MfgOrder.Material AS Material,
  ManufacturingOrderSequence,
  ProductionPlant,
  WorkCenterInternalID,
  WorkCenter,
  WorkCenterTypeCode,
  ManufacturingOrderCategory,
  ManufacturingOrderType,
  ProductionSupervisor,
  _OrderOperation._ProductionSupervisor.ProductionSupervisorName AS ProductionSupervisorName,
  MRPController,
  MRPControllerName,
  _OrderOperation._ProductionPlant.PlantName AS ProductionPlantName,
  cast(_ProductionPlant._Address.AddressTimeZone as co_plant_timezone ) AS PlantTimeZone,
  OperationIsClosed,
  OperationIsTechlyCompleted,
  OperationIsDelivered,
  OperationIsPartiallyDelivered,
  OperationIsPartiallyConfirmed,
  OperationIsPrinted,
  OperationIsReleased,
  OperationIsCreated,
  OperationIsScheduled,
  OperationIsConfirmed,
  OperationIsDeleted,
  cast( case when OperationIsDeleted = 'X' then '10' when OperationIsClosed = 'X' then '09' when OperationIsTechlyCompleted = 'X' then '08' when OperationIsDelivered = 'X' then '07' when OperationIsPartiallyDelivered = 'X' then '06' when OperationIsConfirmed = 'X' then '05' when OperationIsPartiallyConfirmed = 'X' then '04' when OperationIsReleased = 'X' then '03' when OperationIsScheduled = 'X' then '02' when OperationIsCreated = 'X' then '01' end as abap.numc(2)) as OperationStatusInternalID AS numc2asOperationStatusInternalID,
  OpPlannedTotalQuantity,
  OpTotalConfirmedYieldQty,
  OperationReferenceQuantity,
  OperationConfirmedReworkQty,
  OpTotalConfirmedScrapQty,
  OperationUnit,
  OpLtstSchedldExecStrtDte,
  OpLtstSchedldExecStrtTme,
  OpLtstSchedldExecEndDte,
  OpLtstSchedldExecEndTme,
  OpActualExecutionStartDate,
  OpActualExecutionStartTime,
  cast( case when _OrderOperation.OperationYieldDeviationQty < 0 then ( - 1 * _OrderOperation.OperationYieldDeviationQty ) else 0 end as abap.quan(13,3) ) AS MissingQuantity,
  OperationExecutionEndIsLate,
  OperationExecutionStartIsLate,
  OperationYieldDeviationQty,
  ExecutionStartLatenessInMins,
  ExecutionEndLatenessInMinutes,
  InspectionLot,
  _QualityIssue.InspHasRejectedCharc AS InspHasRejectedCharc,
  _QualityIssue.InspHasRejectedInspSubset AS InspHasRejectedInspSubset,
  _QualityIssue.InspHasRejectedInspLot AS InspHasRejectedInspLot,
  _MfgOrder._Material AS _Material,
  _ManufacturingFeatureStatus.MfgFeatureIsActiveInAnyPlant AS MfgFeatureIsActiveInAnyPlant,
  cast('' as mpe_effectivity_parameter_desc) AS EffectivityParameterDesc,
  cast('' as abap.sstring( 256 )) AS EffctyTypeCnctntdParamDesc,
  _OrderOperation._MfgOrder._BillOfOperations._BillOfOperationsVersionType.BOOVersionChangeRecordIsRqd AS BOOVersionChangeRecordIsRqd,
  BillOfOperationsType,
  cast(BillOfOperationsGroup as mpe_rtg_routing_group preserving type ) AS BillOfOperationsGroup,
  cast(BillOfOperationsVariant as mpe_rtg_routing_variant preserving type) AS BillOfOperationsVariant,
  BillOfOperationsVersion,
  MfgOrderOperationOrigin
FROM P_ManageOperations AS _OrderOperation
LEFT OUTER JOIN P_Mfgcompsmissaggr AS _Component ON OrderInternalBillOfOperations = _Component.OrderInternalBillOfOperations AND OrderIntBillOfOperationsItem = _Component.OrderIntBillOfOperationsItem  -- association [0..1]
LEFT OUTER JOIN P_MfgOrderOperationIsOnHold AS _MfgOrderOperationIsOnHold ON OrderInternalBillOfOperations = _MfgOrderOperationIsOnHold.OrderInternalID AND OrderIntBillOfOperationsItem = _MfgOrderOperationIsOnHold.OrderOperationInternalID  -- association [1..1]
LEFT OUTER JOIN I_ManufacturingFeatureStatus AS _ManufacturingFeatureStatus ON ProductionPlant = _ManufacturingFeatureStatus.Plant AND _ManufacturingFeatureStatus.ManufacturingFeature = 'EPO'  -- association [0..1]
LEFT OUTER JOIN P_MPEInspIssuesByOperation AS _QualityIssue ON OrderInternalBillOfOperations = _QualityIssue.OrderInternalBillOfOperations AND OrderIntBillOfOperationsItem = _QualityIssue.InspPlanOperationInternalID AND InspectionLot = _QualityIssue.InspectionLot  -- association [0..1]
LEFT OUTER JOIN I_OrderItem AS _OrderItem ON ManufacturingOrder = _OrderItem.OrderID AND _OrderItem.OrderItem = '0001'  -- association [0..1]
LEFT OUTER JOIN I_MfgOrderOperationOrigin AS _MfgOrderOperationOrigin ON MfgOrderOperationOrigin = _MfgOrderOperationOrigin.MfgOrderOperationOrigin  -- association [0..1]
LEFT OUTER JOIN E_OrderOperation AS _Extension ON OrderInternalBillOfOperations = _Extension.OrderInternalID AND OrderIntBillOfOperationsItem = _Extension.OrderOperationInternalID  -- association [1..1]
;