I_AvailableCapacityInterval

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_AvailableCapacityInterval.
-- 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: IPPAVAILCAPINTRV

CREATE VIEW I_AvailableCapacityInterval AS
SELECT
  kazy.kapid AS CapacityInternalID,
  kazy.versn AS AvailableCapacityType,
  kazy.anzhl AS CapacityNumberOfCapacities,
  kazy.anzsh AS CapacityNumberOfShifts,
  cast(kazy.fabtg as workdayrule preserving type) AS WorkDayRule,
  kazy.sprog AS ShiftSequence,
  cast(kazy.anztg as availablecapacityintervaldurn preserving type) AS AvailableCapacityIntervalDurn,
  kazy.ngrad AS CapacityPlanUtilizationPercent,
  kazy.kkopf AS StdAvailableCapacityIsValid
FROM kazy
LEFT OUTER JOIN I_Capacity AS _Capacity ON CapacityInternalID = _Capacity.CapacityInternalID  -- association [1..1]
LEFT OUTER JOIN I_AvailableCapacityType AS _AvailableCapacityType ON AvailableCapacityType = _AvailableCapacityType.AvailableCapacityType  -- association [1..1]
LEFT OUTER JOIN I_CalendarDate AS _EndDate ON ValidityEndDate = _EndDate.CalendarDate  -- association [1..1]
LEFT OUTER JOIN I_WorkDayRule AS _WorkDayRule ON WorkDayRule = _WorkDayRule.WorkDayRule  -- association [0..1]
LEFT OUTER JOIN I_ShiftSequence AS _ShiftSequence ON ShiftSequence = _ShiftSequence.ShiftSequence  -- association [0..*]
;