P_RSHWCCapacityDefinition

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_RSHWCCapacityDefinition.
-- 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: PRSHWCCAPDEF

CREATE VIEW P_RSHWCCapacityDefinition AS
SELECT
  header_and_interval.CapacityInternalID AS CapacityInternalID,
  case when (shift_def.ShiftDefinition is not null and shift_def.ShiftEndDate < header_and_interval.ValidityEndDate ) then shift_def.ShiftEndDate else header_and_interval.ValidityEndDate end as ValidityEndDate AS ValidityEndDateendasValidityEndDate,
  coalesce( right( shift.WeekDay, 1), '1' ) AS WeekDay,
  coalesce( shift.AvailableCapacityShift, '' ) AS AvailableCapacityShift,
  coalesce( coalesce( shift_def.CapacityStartTimeID, shift.CapacityStartTimeID ), header_and_interval.CapacityStartTime ) as CapacityStartTime AS CapacityStartTimeasCapacityStartTime,
  coalesce( coalesce( shift_def.CapacityEndTimeID, shift.CapacityEndTimeID ), header_and_interval.CapacityEndTime) as CapacityEndTime AS CapacityEndTimeasCapacityEndTime,
  header_and_interval.AvailableCapacityIntervalDurn AS AvailableCapacityIntervalDurn,
  header_and_interval.WorkDayRule AS WorkDayRule,
  coalesce( shift.CapacityNumberOfCapacities, header_and_interval.CapacityNumberOfCapacities) AS CapacityNumberOfCapacities,
  coalesce( shift.CapacityPlanUtilizationPercent, header_and_interval.CapacityPlanUtilizationPercent) AS CapacityPlanUtilizationPercent,
  header_and_interval.WorkCenterInternalID AS WorkCenterInternalID,
  header_and_interval.WorkCenter AS WorkCenter,
  header_and_interval.WorkCenterCategoryCode AS WorkCenterCategoryCode,
  header_and_interval.WorkCenterTypeCode AS WorkCenterTypeCode,
  header_and_interval.Plant AS Plant,
  header_and_interval.FactoryCalendar AS FactoryCalendar,
  header_and_interval.CapacityActiveVersion AS CapacityActiveVersion,
  header_and_interval.IntervalValidityEndDate AS IntervalValidityEndDate,
  shift.ValidityEndDate AS ShiftValidityEndDate,
  shift_def.ShiftDefinition AS ShiftDefinition,
  shift_def.ShiftDefinitionName AS ShiftDefinitionName
FROM P_RshWCCapacityIntervalDetails AS header_and_interval
LEFT OUTER JOIN I_AvailableCapacityShift AS shift ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_RSHShiftDefinition AS shift_def ON /* join condition not captured in parsed metadata */
;