P_WrkCtrOpShiftLoadDistr

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 P_WrkCtrOpShiftLoadDistr.
-- 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: PWCSHIFTLOADDIST
-- Parameters: P_StartDate : datum, P_EndDate : datum

CREATE VIEW P_WrkCtrOpShiftLoadDistr AS
SELECT
  OperationCapacityPerShift.WorkCenterInternalID AS WorkCenterInternalID,
  OperationCapacityPerShift.WorkCenterTypeCode AS WorkCenterTypeCode,
  OperationCapacityPerShift.CapacityCategoryAllocation AS CapacityCategoryAllocation,
  OperationCapacityPerShift.CapacityInternalID AS CapacityInternalID,
  OperationCapacityPerShift.CapacityActiveVersion AS CapacityActiveVersion,
  OperationCapacityPerShift.AvailableCapacityShift AS AvailableCapacityShift,
  OperationCapacityPerShift.WeekDay AS WeekDay,
  OperationCapacityPerShift.ValidityEndDate AS ValidityEndDate,
  OperationCapacityPerShift.CalendarDate AS CalendarDate,
  OperationCapacityPerShift.Material AS Material,
  OperationCapacityPerShift.OrderID AS OrderID,
  OperationCapacityPerShift.Operation AS Operation,
  OperationCapacityPerShift.ShiftName AS ShiftName,
  OperationCapacityPerShift.Plant AS Plant,
  OperationCapacityPerShift.MRPController AS MRPController,
  OperationCapacityPerShift.WorkCenter AS WorkCenter,
  OperationCapacityPerShift.FactoryCalendar AS FactoryCalendar,
  OperationCapacityPerShift.CalendarWeek AS CalendarWeek,
  OperationCapacityPerShift.CalendarMonth AS CalendarMonth,
  OperationCapacityPerShift.CalendarYear AS CalendarYear,
  OperationCapacityPerShift.FactoryCalendarDate AS FactoryCalendarDate,
  OperationCapacityPerShift.CapacityRequirement AS CapacityRequirement,
  fltp_to_dec(OperationCapacityPerShift.CapacityStartTime as abap.dec(10,2))as CapacityStartTime AS dec102asCapacityStartTime,
  fltp_to_dec(OperationCapacityPerShift.CapacityEndTime as abap.dec(10,2)) AS CapacityEndTime,
  OperationCapacityPerShift.CapacityRequirementOrigin AS CapacityRequirementOrigin,
  OperationCapacityPerShift.CapacityRequirementUnit AS CapacityRequirementUnit,
  OperationCapacityPerShift.OrderInternalID AS OrderInternalID,
  OperationCapacityPerShift.OrderType AS OrderType,
  OperationCapacityPerShift.OrderCategory AS OrderCategory,
  OperationCapacityPerShift.ProductionVersion AS ProductionVersion,
  OperationCapacityPerShift.OrderPlannedTotalQty AS OrderPlannedTotalQty,
  OperationCapacityPerShift.BaseUnit AS BaseUnit,
  OperationCapacityPerShift.OperationPlanningStatusCode AS OperationPlanningStatusCode,
  OperationCapacityPerShift.OperationLatestStartDate AS OperationLatestStartDate,
  OperationCapacityPerShift.OperationLatestStartTime AS OperationLatestStartTime,
  OperationCapacityPerShift.OperationLatestEndDate AS OperationLatestEndDate,
  OperationCapacityPerShift.OperationLatestEndTime AS OperationLatestEndTime,
  OperationCapacityPerShift.OpLtstSchedldExecStrtTme AS OpLtstSchedldExecStrtTme,
  OperationCapacityPerShift.OpLtstSchedldExecEndTme AS OpLtstSchedldExecEndTme,
  OperationCapacityPerShift.OpLtstSchedldProcgStrtDte AS OpLtstSchedldProcgStrtDte,
  OperationCapacityPerShift.OpLtstSchedldProcgStrtTme AS OpLtstSchedldProcgStrtTme,
  OperationCapacityPerShift.OpLtstSchedldTrdwnStrtDte AS OpLtstSchedldTrdwnStrtDte,
  OperationCapacityPerShift.OpLtstSchedldTrdwnStrtTme AS OpLtstSchedldTrdwnStrtTme,
  OperationCapacityPerShift.RemainingCapReqOpSegSetupDurn AS RemainingCapReqOpSegSetupDurn,
  OperationCapacityPerShift.RemainingCapReqOpSegProcgDurn AS RemainingCapReqOpSegProcgDurn,
  OperationCapacityPerShift.RemainingCapReqOpSegTrdwnDurn AS RemainingCapReqOpSegTrdwnDurn,
  OperationCapacityPerShift.RequirementHours AS RequirementHours,
  OperationCapacityPerShift.OrderStatusCode AS OrderStatusCode,
  OperationCapacityPerShift.OrderFirmingStatusCode AS OrderFirmingStatusCode,
  cast ('H' as meins) AS WorkCenterCapacityUnit,
  OperationCapacityPerShift.WorkCenterResponsible AS WorkCenterResponsible,
  OperationCapacityPerShift.WorkCenterCategoryCode AS WorkCenterCategoryCode,
  (OperationCapacityPerShift.TotOperatingDurationInSeconds) / cast(3600 as abap.fltp) AS WorkCenterAvailableCapacity,
  (cast(OperationCapacityPerShift.CalCapacityInParallel as abap.fltp) / cast(3600 as abap.fltp)) * OperationDistrpercPct.CapacityDistrPercent / cast(100 as abap.fltp) as WorkCenterCapacityRequirement AS fltpasWorkCenterCapacityRequirement
FROM P_WrkCtrCapOpWrkDays
INNER JOIN P_WorkCenterOpDistrPct ON /* join condition not captured in parsed metadata */
;