P_RSHSmltdOpCapacity

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_RSHSmltdOpCapacity.
-- 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: PRSHSMLTDOPCAP

CREATE VIEW P_RSHSmltdOpCapacity AS
SELECT
  SimulatedOperations.MaintSchedSimlnUUID AS MaintSchedSimlnUUID,
  SimulatedOperations.MaintenanceOrder AS MaintenanceOrder,
  SimulatedOperations.MaintenanceOrderOperation AS MaintenanceOrderOperation,
  SimulatedOperations.MaintenanceOrderSubOperation AS MaintenanceOrderSubOperation,
  WorkCenterCapacity.CalendarDate AS CalendarDate,
  WorkCenterCapacity.CapacityStartTime AS CapacityStartTime,
  SimulatedOperations.WorkCenterInternalID AS WorkCenterInternalId,
  WorkCenterCapacity.CapacityInternalID AS CapacityInternalID,
  WorkCenterCapacity.WorkCenter AS WorkCenter,
  WorkCenterCapacity.WorkCenterCategoryCode AS WorkCenterCategoryCode,
  WorkCenterCapacity.WorkCenterTypeCode AS WorkCenterTypeCode,
  WorkCenterCapacity.Plant AS Plant,
  OperationPlannedWork,
  OperationDuration,
  MaintOrdOpSimulatedStartDate,
  MaintOrdOpSimulatedEndDate,
  ProcessingStatus,
  MaintPriority,
  MaintPriorityType,
  MaintPriorityColorCode,
  OrderType,
  ActivityType,
  SimulatedOperations.OperationControlKey AS OperationControlKey,
  MaintOrdOpSimulationStatus,
  SimulatedOperations.NumberOfCapacities AS NumberOfCapacities,
  WorkCenterCapacity.TotOperatingDurationInSeconds AS TotOperatingDurationInSeconds,
  OperationPlannedWork AS CalCapacityInParallel
FROM P_RSHSmltdOpInSeconds AS SimulatedOperations
INNER JOIN P_RSHWCCapacityPerWorkDay AS WorkCenterCapacity ON /* join condition not captured in parsed metadata */
INNER JOIN I_RSHAssignedWorkCenters AS WorkCenterDetails ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): P_RSHSmltdOpInSeconds
;