P_RSHWCCapaInterDetails_Cache

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_RSHWCCapaInterDetails_Cache.
-- 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: PRSHWCINDETCACHE

CREATE VIEW P_RSHWCCapaInterDetails_Cache AS
SELECT
  header_w_end.CapacityInternalID AS CapacityInternalID,
  header_w_end.ValidityEndDate AS ValidityEndDate,
  case when header_w_begin.CapacityInternalID is null then cast('00000000' as dats) else max(header_w_begin.ValidityEndDate) end as ValidityBeginDate AS ValidityEndDateendasValidityBeginDate,
  header_w_end.HeaderValidityBeginDate AS HeaderValidityBeginDate,
  header_w_end.HeaderValidityEndDate AS HeaderValidityEndDate,
  header_w_end.IntervalValidityEndDate AS IntervalValidityEndDate,
  header_w_end.WorkCenterInternalID AS WorkCenterInternalID,
  header_w_end.CapacityStartTime AS CapacityStartTime,
  header_w_end.CapacityEndTime AS CapacityEndTime,
  header_w_end.CapacityNumberOfCapacities AS CapacityNumberOfCapacities,
  header_w_end.CapacityPlanUtilizationPercent AS CapacityPlanUtilizationPercent,
  header_w_end.CapacityBreakDuration AS CapacityBreakDuration,
  header_w_end.TotOperatingDurationInSeconds AS TotOperatingDurationInSeconds,
  header_w_end.OperatingDurationInSeconds AS OperatingDurationInSeconds,
  header_w_end.WorkCenter AS WorkCenter,
  header_w_end.WorkCenterCategoryCode AS WorkCenterCategoryCode,
  header_w_end.WorkCenterTypeCode AS WorkCenterTypeCode,
  header_w_end.Plant AS Plant,
  header_w_end.FactoryCalendar AS FactoryCalendar,
  header_w_end.ShiftGroup AS ShiftGroup,
  header_w_end.CapacityActiveVersion AS CapacityActiveVersion,
  header_w_end.AvailableCapacityIntervalDurn AS AvailableCapacityIntervalDurn,
  header_w_end.WorkDayRule AS WorkDayRule,
  header_w_end.StdAvailableCapacityIsValid AS StdAvailableCapacityIsValid,
  header_w_end.AvailableCapacityType AS AvailableCapacityType
FROM P_RSHWCCapaHdrAndIntrval_Cache AS header_w_end
;