I_WorkCtrOpLoadDistrAggrgd

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_WorkCtrOpLoadDistrAggrgd.
-- 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: IWCLOADDISTAGG
-- Parameters: P_CapacityPlanningStartDate : datum, P_CapacityPlanningEndDate : datum, P_CapacityEvalTimePerdCode : char1

CREATE VIEW I_WorkCtrOpLoadDistrAggrgd AS
SELECT
  CapacityPerDailyShift.WorkCenterInternalID AS WorkCenterInternalID,
  CapacityPerDailyShift.WorkCenterTypeCode AS WorkCenterTypeCode,
  CapacityPerDailyShift.CapacityCategoryAllocation AS CapacityCategoryAllocation,
  CapacityPerDailyShift.CapacityInternalID AS CapacityInternalID,
  CapacityPerDailyShift.CapacityRequirement AS CapacityRequirement,
  CapacityPerDailyShift.Material AS Material,
  CapacityPerDailyShift.OrderID AS OrderID,
  CapacityPerDailyShift.Operation AS Operation,
  case $parameters.P_CapacityEvalTimePerdCode when 'D' then cast('' as abap.char(4)) when 'W' then cast('' as abap.char(4)) when 'M' then cast('' as abap.char(4)) when 'Y' then cast('' as abap.char(4)) when 'S' then cast(CapacityPerDailyShift.ShiftName as abap.char(4)) else cast('' as abap.char(4)) end as ShiftName AS char4endasShiftName,
  case $parameters.P_CapacityEvalTimePerdCode when 'D' then cast(CalendarDate as abap.char(10)) when 'W' then cast(CalendarWeek as abap.char(10)) when 'M' then cast(CalendarMonth as abap.char(10)) when 'Y' then cast(CalendarYear as abap.char(10)) else cast(CalendarDate as abap.char(10)) end as CapacityEvaluationTimePeriod AS char10endasCapacityEvaluationTimePeriod,
  CapacityPerDailyShift.Plant AS Plant,
  CapacityPerDailyShift.MRPController AS MRPController,
  CapacityPerDailyShift.WorkCenter AS WorkCenter,
  CapacityPerDailyShift.FactoryCalendar AS FactoryCalendar,
  $parameters.P_CapacityEvalTimePerdCode AS CapacityEvaluationTimePerdCode,
  case $parameters.P_CapacityEvalTimePerdCode when 'S' then CapacityPerDailyShift.CapacityStartTime end as CapacityStartTime AS CapacityStartTimeendasCapacityStartTime,
  case $parameters.P_CapacityEvalTimePerdCode when 'S' then CapacityPerDailyShift.CapacityEndTime end as CapacityEndTime AS CapacityEndTimeendasCapacityEndTime,
  CapacityPerDailyShift.WorkCenterResponsible AS WorkCenterResponsible,
  CapacityPerDailyShift.WorkCenterCategoryCode AS WorkCenterCategoryCode,
  CapacityPerDailyShift.CapacityRequirementOrigin AS CapacityRequirementOrigin,
  CapacityPerDailyShift.CapacityRequirementUnit AS CapacityRequirementUnit,
  CapacityPerDailyShift.OrderInternalID AS OrderInternalID,
  CapacityPerDailyShift.OrderType AS OrderType,
  CapacityPerDailyShift.OrderCategory AS OrderCategory,
  CapacityPerDailyShift.ProductionVersion AS ProductionVersion,
  CapacityPerDailyShift.OrderPlannedTotalQty AS OrderPlannedTotalQty,
  CapacityPerDailyShift.BaseUnit AS BaseUnit,
  CapacityPerDailyShift.OperationPlanningStatusCode AS OperationPlanningStatusCode,
  CapacityPerDailyShift.OperationLatestStartDate AS OperationLatestStartDate,
  CapacityPerDailyShift.OperationLatestStartTime AS OperationLatestStartTime,
  CapacityPerDailyShift.OperationLatestEndDate AS OperationLatestEndDate,
  CapacityPerDailyShift.OperationLatestEndTime AS OperationLatestEndTime,
  CapacityPerDailyShift.OpLtstSchedldExecStrtTme AS OpLtstSchedldExecStrtTme,
  CapacityPerDailyShift.OpLtstSchedldExecEndTme AS OpLtstSchedldExecEndTme,
  CapacityPerDailyShift.OpLtstSchedldProcgStrtDte AS OpLtstSchedldProcgStrtDte,
  CapacityPerDailyShift.OpLtstSchedldProcgStrtTme AS OpLtstSchedldProcgStrtTme,
  CapacityPerDailyShift.OpLtstSchedldTrdwnStrtDte AS OpLtstSchedldTrdwnStrtDte,
  CapacityPerDailyShift.OpLtstSchedldTrdwnStrtTme AS OpLtstSchedldTrdwnStrtTme,
  CapacityPerDailyShift.RemainingCapReqOpSegSetupDurn AS RemainingCapReqOpSegSetupDurn,
  CapacityPerDailyShift.RemainingCapReqOpSegProcgDurn AS RemainingCapReqOpSegProcgDurn,
  CapacityPerDailyShift.RemainingCapReqOpSegTrdwnDurn AS RemainingCapReqOpSegTrdwnDurn,
  fltp_to_dec(CapacityPerDailyShift.RequirementHours as abap.dec( 10,2)) AS OpCompltnRqmtInCapUnit,
  CapacityPerDailyShift.OrderStatusCode AS OrderStatusCode,
  CapacityPerDailyShift.OrderFirmingStatusCode AS OrderFirmingStatusCode,
  CapacityPerDailyShift.WorkCenterCapacityUnit AS WorkCenterCapacityUnit,
  fltp_to_dec(CapacityPerDailyShift.WorkCenterAvailableCapacity as abap.dec( 10,2)) AS WorkCenterAvailableCapacity,
  fltp_to_dec(CapacityPerDailyShift.WorkCenterCapacityRequirement as abap.dec(10,2)) AS WorkCenterCapRqmtInCapUnit
FROM P_WRKCTROPSHIFTLOADAGGRGD
;