P_RSHWCHeaderCapacity_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_RSHWCHeaderCapacity_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: PRSHWCHDCAPCACHE

CREATE VIEW P_RSHWCHeaderCapacity_Cache AS
SELECT
  Capacity.CapacityInternalID AS CapacityInternalID,
  _WorkCenter.WorkCenterInternalID AS WorkCenterInternalID,
  cast('00000000' as dats) AS ValidityBeginDate,
  cast('99991231' as dats) AS ValidityEndDate,
  Capacity.CapacityStartTime AS CapacityStartTime,
  Capacity.CapacityEndTime AS CapacityEndTime,
  Capacity.CapacityNumberOfCapacities AS CapacityNumberOfCapacities,
  Capacity.CapacityPlanUtilizationPercent AS CapacityPlanUtilizationPercent,
  Capacity.CapacityBreakDuration AS CapacityBreakDuration,
  _WorkCenter.WorkCenter AS WorkCenter,
  _WorkCenter.WorkCenterCategoryCode AS WorkCenterCategoryCode,
  _WorkCenter.WorkCenterTypeCode AS WorkCenterTypeCode,
  Capacity.Plant AS Plant,
  case when Capacity.FactoryCalendar = '' then Capacity._Plant.FactoryCalendar else Capacity.FactoryCalendar end as FactoryCalendar AS FactoryCalendarendasFactoryCalendar,
  Capacity.ShiftGroup AS ShiftGroup,
  Capacity.CapacityActiveVersion AS CapacityActiveVersion
FROM I_Capacity AS Capacity
INNER JOIN I_WorkCenter AS _WorkCenter ON /* join condition not captured in parsed metadata */
;