P_RSHOperationsForKPI

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

CREATE VIEW P_RSHOperationsForKPI AS
SELECT
  iop.MaintenanceOrder AS MaintenanceOrder,
  iop.MaintenanceOrderOperation AS MaintenanceOrderOperation,
  iop.MaintenanceOrderSubOperation AS MaintenanceOrderSubOperation,
  iorder.MaintPriority AS MaintPriority,
  iorder.MaintenanceActivityType AS MaintenanceActivityType,
  iorder.MaintenanceOrderType AS MaintenanceOrderType,
  iop.OperationWorkCenterInternalID AS WorkCenterInternalID,
  iop.OperationWorkCenterTypeCode AS WorkCenterTypeCode,
  iop.Plant AS Plant,
  iorder._Order.ControllingArea AS ControllingArea,
  iorder.MaintenancePlannerGroup AS MaintenancePlannerGroup,
  iorder._LocationAccountAssignment.MaintenancePlant AS MaintenancePlant,
  iorder._Order.ResponsibleCostCenter AS ResponsibleCostCenter,
  iorder._Equipment.AuthorizationGroup AS AuthorizationGroup,
  iorder._LocationAccountAssignment.FunctionalLocation AS FunctionalLocation,
  iorder._LocationAccountAssignment._FunctionalLocation._FunctionalLocationLabel.FunctionalLocationLabelName AS FunctionalLocationLabelName,
  iorder.Equipment AS Equipment,
  iorder.MaintenanceRevision AS MaintenanceRevision,
  iop.OperationControlKey AS OperationControlKey
FROM I_MaintOrderOperAndSubOper AS iop
INNER JOIN I_MaintenanceOrder AS iorder ON /* join condition not captured in parsed metadata */
INNER JOIN I_MaintOrderOperPlanningValues ON /* join condition not captured in parsed metadata */
INNER JOIN I_RSHAssignedWorkCenters AS user_var ON /* join condition not captured in parsed metadata */
INNER JOIN I_OperationControlProfile AS operation_controlprofile ON /* join condition not captured in parsed metadata */
INNER JOIN I_StatusObjectStatusBasic AS incl_status ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_StatusObjectStatusBasic AS excl_status ON /* join condition not captured in parsed metadata */
;