I_WorkCenterAvailableCapacity

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_WorkCenterAvailableCapacity.
-- 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: IWRKCTRAVAILCAP

CREATE VIEW I_WorkCenterAvailableCapacity AS
SELECT
  availCapa.WorkCenterInternalID AS WorkCenterInternalID,
  availCapa.WorkCenterTypeCode AS WorkCenterTypeCode,
  availCapa.CapacityCategoryAllocation AS CapacityCategoryAllocation,
  availCapa.CapacityInternalID AS CapacityInternalID,
  availCapa.CapacityActiveVersion AS CapacityActiveVersion,
  availCapa.ValidityEndDate AS ValidityEndDate,
  availCapa.WeekDay AS WeekDay,
  cast (availCapa.AvailableCapacityShift as char1) AS AvailableCapacityShift,
  availCapa.CalendarDate AS CalendarDate,
  cast (availCapa.ShiftStartDate as datub) AS ShiftStartDate,
  cast (availCapa.ShiftStartTime as kapbegzeit) AS ShiftStartTime,
  cast (availCapa.ShiftEndDate as datub) AS ShiftEndDate,
  cast (availCapa.ShiftEndTime as kapbegzeit) AS ShiftEndTime,
  fltp_to_dec(availCapa.CapacityBreakDuration as pph_cap_eval_breakhours) AS CapacityBreakDuration,
  availCapa.WorkCenterCapacityUnit AS WorkCenterCapacityUnit,
  availCapa.WorkCenterUtilizationUnit AS WorkCenterUtilizationUnit,
  cast (availCapa.ValidityBeginDate as datub) AS ValidityBeginDate,
  availCapa.CalendarMonth AS CalendarMonth,
  availCapa.CalendarYear AS CalendarYear,
  availCapa.CalendarWeek AS CalendarWeek,
  cast (availCapa.workdays as int4) AS WorkDays,
  cast (availCapa.ShiftName as char4) AS ShiftName,
  availCapa.ShiftDefinition AS ShiftDefinition,
  _Text[1:Language=$session.system_language].ShiftDefinitionName AS ShiftDefinitionName,
  availCapa.ShiftGrouping AS ShiftGrouping,
  cast (availCapa.WorkDayRule as kapfabtag) AS WorkDayRule,
  availCapa.FactoryCalendar AS FactoryCalendar,
  cast (availCapa.CapacityStartTime as kapbegzt) AS CapacityStartTime,
  cast( availCapa.CapacityEndTime as kapendzt) AS CapacityEndTime,
  availCapa.CapacityNumberOfCapacities AS CapacityNumberOfCapacities,
  availCapa.CapacityPlanUtilizationPercent AS CapacityPlanUtilizationPercent,
  cast(round(fltp_to_dec(availCapa.TotOperatingDurationInHours as abap.dec(10,5)),2) as kapazit_eh) AS TotOperatingDurationInHours
FROM P_WorkCenterAvailableCapacity AS availCapa
LEFT OUTER JOIN I_ShiftDefinitionText AS _Text ON ShiftDefinition = _Text.ShiftDefinition AND ShiftGrouping = _Text.ShiftGrouping  -- association [0..*]
LEFT OUTER JOIN I_Capacity AS _Capacity ON CapacityInternalID = _Capacity.CapacityInternalID  -- association [1..1]
;