C_MfgOrderOpExecDurnQry

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_MfgOrderOpExecDurnQry.
-- 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: CPPMFGORDEROPDQ
-- Parameters: P_Language : sylangu, P_ReportingStartDate : vdm_performanceperiodstartdate, P_ReportingEndDate : vdm_performanceperiodenddate

CREATE VIEW C_MfgOrderOpExecDurnQry AS
SELECT
  OrderInternalBillOfOperations,
  OrderIntBillOfOperationsItem,
  MRPPlant,
  _MRPPlant.PlantName AS MRPPlantName,
  Material,
  _Material._Text[1: Language=$parameters.P_Language].MaterialName AS MaterialName,
  WorkCenter,
  WorkCenterInternalID,
  _WorkCenter._Text[1: Language=$parameters.P_Language].WorkCenterText AS WorkCenterText,
  ReportingPeriod,
  _ReportingPeriod._Text[1: Language=$parameters.P_Language].ReportingPeriodName AS ReportingPeriodName,
  ManufacturingOrder,
  ManufacturingOrderCategory,
  _MfgOrderCategory._Text[1: Language=$parameters.P_Language].ManufacturingOrderCategoryName AS ManufacturingOrderCategoryName,
  ManufacturingOrderType,
  _MfgOrderType._Text[1: Language=$parameters.P_Language].ManufacturingOrderTypeName AS ManufacturingOrderTypeName,
  ManufacturingOrderOperation,
  MfgOrderOperationText,
  ProductionPlant,
  _ProductionPlant.PlantName AS ProductionPlantName,
  ProductionSupervisor,
  _ProductionSupervisor.ProductionSupervisorName AS ProductionSupervisorName,
  ActualExecutionEndDate,
  ActualExecutionEndTime,
  EndDateHour,
  EndDateWeekDay,
  cast(_EndDateWeekDay._Text[1: Language=$parameters.P_Language].WeekDayName as enddateweekdayname preserving type) AS EndDateWeekDayName,
  EndDateMonth,
  cast(_EndDateMonth._Text[1: Language=$parameters.P_Language].CalendarMonthName as enddatemonthname preserving type) AS EndDateMonthName,
  EndDateYear,
  EndDateYearMonth,
  DurationUnit,
  ActualWorkdayDurnInSeconds,
  PlannedWorkdayDurnInSeconds,
  DeviationWorkdayDurnInSeconds,
  HoursUnitOfMeasure,
  ActualDurationInHours,
  PlannedDurationInHours,
  DeviationDurationInHours,
  ActualDurationUnit,
  PlannedDurationUnit,
  DeviationDurationUnit,
  ActualDuration,
  PlannedDuration,
  DeviationDuration,
  cast(0 as abap.dec(5,2)) AS DurationDeviationPercent
FROM I_MfgOrderOperationDurnCube
;