I_WrkCtrCapShiftIntervalTP

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_WrkCtrCapShiftIntervalTP.
-- 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: IWCCAPINTERVALTP

CREATE VIEW I_WrkCtrCapShiftIntervalTP AS
SELECT
  _shiftInterval.WorkCenterInternalID AS WorkCenterInternalID,
  _shiftInterval.WorkCenterTypeCode AS WorkCenterTypeCode,
  _shiftInterval.CapacityCategoryAllocation AS CapacityCategoryAllocation,
  _shiftInterval.CapacityInternalID AS CapacityInternalID,
  cast (_shiftInterval.ValidityEndDate as datub) AS ValidityEndDate,
  cast(_shiftInterval.AvailableCapacityType as kapversakt) AS CapacityActiveVersion,
  cast (_shiftInterval.ValidityEndDate as datub) AS ValidityEndDateForEdit,
  cast (_shiftInterval.ValidityBeginDate as datub) AS ValidityBeginDate,
  cast (_shiftInterval.WorkDayRule as kapfabtag) AS WorkDayRule,
  cast (_shiftInterval.CapacityNumberOfCapacities as kapanzahl) AS CapacityNumberOfCapacities,
  cast (_shiftInterval.AvailableCapacityIntervalDurn as numc2) AS AvailableCapacityIntervalDurn,
  cast (_shiftInterval.CapacityPlanUtilizationPercent as nutzgrad) AS CapacityPlanUtilizationPercent,
  cast (_shiftInterval.StdAvailableCapacityIsValid as kap_kopf) AS StdAvailableCapacityIsValid,
  cast (_shiftInterval.ShiftSequence as schprog) AS ShiftSequence,
  cast ('' as char20 ) AS IntervalStatusText,
  cast ('' as cfs_interval_change_status ) AS IntervalStatusCode
FROM I_WorkCenterCapacityInterval AS _shiftInterval
LEFT OUTER JOIN I_WorkCenterCapOverviewTP AS _workCenterResponsible ON WorkCenterInternalID = _workCenterResponsible.WorkCenterInternalID AND WorkCenterTypeCode = _workCenterResponsible.WorkCenterTypeCode AND CapacityCategoryAllocation = _workCenterResponsible.CapacityCategoryAllocation AND CapacityInternalID = _workCenterResponsible.CapacityInternalID  -- association [1..1]
;