I_WorkCenterCapacityShift_2

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_WorkCenterCapacityShift_2.
-- 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: IWRKCTRCAPSHIFT2

CREATE VIEW I_WorkCenterCapacityShift_2 AS
SELECT
  CapacityInternalID,
  CapacityActiveVersion,
  cast(ValidityEndDate as datub preserving type ) AS IntervalEndDate,
  cast(WeekDay as vdm_weekday preserving type) AS WeekDay,
  AvailableCapacityShift,
  cast(ValidityStartDate as datuv preserving type ) AS IntervalStartDate,
  WorkDayRule,
  ShiftDefinition,
  cast(ShiftStartTime as kapbegzeit preserving type ) AS ShiftStartTime,
  cast(ShiftEndTime as kapendzeit preserving type ) AS ShiftEndTime,
  cast(ShiftStartDate as begda preserving type ) AS ShiftDefValidityStartDate,
  cast(ShiftEndDate as endda preserving type ) AS ShiftDefValidityEndDate,
  cast(CapacityNumberOfCapacities as kapanzahl preserving type ) AS CapacityNumberOfCapacities,
  cast(CapacityPlanUtilizationPercent as nutzgrad preserving type ) AS CapacityPlanUtilizationPercent,
  cast(BreakDurationInSeconds as kappause preserving type ) AS CapacityBreakDuration,
  cast(ceil(fltp_to_dec(OperatingDurationInSeconds as dec17_3)) as kapeinzt preserving type ) AS OperatingDurationInSeconds,
  cast(ceil(fltp_to_dec(TotOperatingDurationInSeconds as dec17_3)) as pph_kapaz preserving type ) AS TotOperatingDurationInSeconds
FROM P_WorkCenterCapacityShiftCalc
LEFT OUTER JOIN I_Capacity AS _Capacity ON CapacityInternalID = _Capacity.CapacityInternalID  -- association [1..1]
LEFT OUTER JOIN I_AvailableCapacityType AS _AvailableCapacityType ON CapacityActiveVersion = _AvailableCapacityType.AvailableCapacityType  -- association [1..1]
LEFT OUTER JOIN I_CalendarDate AS _EndDate ON IntervalEndDate = _EndDate.CalendarDate  -- association [1..1]
LEFT OUTER JOIN I_WeekDay AS _WeekDay ON WeekDay = _WeekDay.WeekDay  -- association [1..1]
;