P_RSHSmltdOpCapacity

DDL: P_RSHSMLTDOPCAPACITY SQL: PRSHSMLTDOPCAP Type: view CONSUMPTION Package: RSH_CDS_MAINT_SCHED_SIM
53 Fields 4 Data Sources

Simulated Operation Capacity

P_RSHSmltdOpCapacity is a Consumption CDS View that provides data about "Simulated Operation Capacity" in SAP S/4HANA. It reads from 4 data sources (P_RSHSmltdOpInSeconds, P_RSHWCCapPerWorkDayForPeriod, P_RSHSmltdOpInSeconds, I_RSHAssignedWorkCenters) and exposes 53 fields with key fields MaintSchedSimlnUUID, MaintenanceOrder, MaintenanceOrderOperation, MaintenanceOrderSubOperation, CalendarDate. Part of development package RSH_CDS_MAINT_SCHED_SIM.

Data Sources (4)

SourceAliasJoin Type
P_RSHSmltdOpInSeconds OperationDetails union_all
P_RSHWCCapPerWorkDayForPeriod P_RSHWCCapPerWorkDayForPeriod inner
P_RSHSmltdOpInSeconds SimulatedOperations from
I_RSHAssignedWorkCenters WorkCenterDetails inner

Parameters (2)

NameTypeDefault
P_StartDate datum
P_EndDate datum

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName PRSHSMLTDOPCAP view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.private true view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (53)

KeyFieldSource TableSource FieldDescription
KEY MaintSchedSimlnUUID P_RSHSmltdOpInSeconds MaintSchedSimlnUUID UUID
KEY MaintenanceOrder P_RSHSmltdOpInSeconds MaintenanceOrder Order
KEY MaintenanceOrderOperation P_RSHSmltdOpInSeconds MaintenanceOrderOperation Suboperation
KEY MaintenanceOrderSubOperation P_RSHSmltdOpInSeconds MaintenanceOrderSubOperation Suboperation
KEY CalendarDate WorkCenterCapacity CalendarDate
KEY CapacityStartTime WorkCenterCapacity CapacityStartTime
WorkCenterInternalId P_RSHSmltdOpInSeconds WorkCenterInternalID Work Center
CapacityInternalID WorkCenterCapacity CapacityInternalID Capacity ID
WorkCenter WorkCenterCapacity WorkCenter Work Center
WorkCenterCategoryCode WorkCenterCapacity WorkCenterCategoryCode
WorkCenterTypeCode WorkCenterCapacity WorkCenterTypeCode Object Type
Plant WorkCenterCapacity Plant Valuation Area
OperationPlannedWork OperationPlannedWork
OperationDuration OperationDuration
MaintOrdOpSimulatedStartDate MaintOrdOpSimulatedStartDate Simulated Start Date
MaintOrdOpSimulatedEndDate MaintOrdOpSimulatedEndDate Simulated End Date
ProcessingStatus ProcessingStatus Worklist Status
MaintPriority MaintPriority Priority
MaintPriorityType MaintPriorityType PriorityType
MaintPriorityColorCode MaintPriorityColorCode
OrderType OrderType Order Type
ActivityType ActivityType Activity Type
OperationControlKey P_RSHSmltdOpInSeconds OperationControlKey Control Key
MaintOrdOpSimulationStatus MaintOrdOpSimulationStatus Technical Status
NumberOfCapacities P_RSHSmltdOpInSeconds NumberOfCapacities Number
TotOperatingDurationInSeconds WorkCenterCapacity TotOperatingDurationInSeconds
MaintSchedSimlnUUID UUID
KEY MaintenanceOrder P_RSHSmltdOpInSeconds MaintenanceOrder Order
KEY MaintenanceOrderOperation P_RSHSmltdOpInSeconds MaintenanceOrderOperation Suboperation
KEY MaintenanceOrderSubOperation P_RSHSmltdOpInSeconds MaintenanceOrderSubOperation Suboperation
KEY CalendarDate P_RSHSmltdOpInSeconds ConsumingStartDate
KEY CapacityStartTime 0
WorkCenterInternalId P_RSHSmltdOpInSeconds WorkCenterInternalID Work Center
CapacityInternalID I_RSHAssignedWorkCenters CapacityInternalID Capacity ID
WorkCenter I_RSHAssignedWorkCenters WorkCenter Work Center
WorkCenterCategoryCode I_RSHAssignedWorkCenters WorkCenterCategoryCode
WorkCenterTypeCode I_RSHAssignedWorkCenters WorkCenterTypeCode Object Type
Plant I_RSHAssignedWorkCenters Plant Valuation Area
OperationPlannedWork OperationPlannedWork
OperationDuration OperationDuration
MaintOrdOpSimulatedStartDate MaintOrdOpSimulatedStartDate Simulated Start Date
MaintOrdOpSimulatedEndDate MaintOrdOpSimulatedEndDate Simulated End Date
ProcessingStatus ProcessingStatus Worklist Status
MaintPriority MaintPriority Priority
MaintPriorityType MaintPriorityType PriorityType
MaintPriorityColorCode MaintPriorityColorCode
OrderType OrderType Order Type
ActivityType ActivityType Activity Type
OperationControlKey OperationControlKey Control Key
MaintOrdOpSimulationStatus MaintOrdOpSimulationStatus Technical Status
NumberOfCapacities P_RSHSmltdOpInSeconds NumberOfCapacities Number
TotOperatingDurationInSeconds 0
CalCapacityInParallel

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
-- Parameters: P_StartDate : datum, P_EndDate : datum

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,
  cast ( OperationPlannedWork as abap.fltp ) AS CalCapacityInParallel
FROM P_RSHSmltdOpInSeconds AS SimulatedOperations
INNER JOIN P_RSHWCCapPerWorkDayForPeriod 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
;

Learn More