P_RSHOperations

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_RSHOperations.
-- 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: PRSHOPERATIONS

CREATE VIEW P_RSHOperations AS
SELECT
  MaintenanceOrder,
  cast( MaintenanceOrderOperation as imrc_woobk ) AS MaintenanceOrderOperation,
  MaintenanceOrderSubOperation,
  MaintOrderRoutingNumber,
  MaintOrderOperationCounter,
  MaintOrderConfirmation,
  OperationControlKey,
  OperationDescription,
  OperationPersonResponsible,
  PersonFullName,
  Plant,
  MaintOrderOperationInternalID,
  WorkCenterInternalID,
  WorkCenterTypeCode,
  WorkCenter,
  NumberOfCapacities,
  SuperiorProjectNetwork,
  ControllingArea,
  ResponsibleCostCenter,
  BasicSchedulingType,
  OrdIsNotSchedldAutomatically,
  MainWorkCenter,
  MainWorkCenterPlant,
  OperationHasLongText,
  OrderHasLongText,
  MaintenanceOrderDesc,
  MaintenanceOrderType,
  MaintenanceActivityType,
  MaintOrdBasicStartDate,
  MaintOrdBasicStartTime,
  MaintOrdBasicEndDate,
  MaintOrdBasicEndTime,
  MaintPriority,
  MaintPriorityType,
  MaintenanceNotification,
  Equipment,
  MaintObjectLocAcctAssgmtNmbr,
  MaintenanceOrderInternalID,
  MaintenancePlanningPlant,
  MaintenancePlannerGroup,
  MaintenanceRevision,
  OperationSystemCondition,
  OrderSystemCondition,
  MaintenancePlan,
  coalesce(_Equipment._EquipmentText[ 1: Language = $session.system_language ].EquipmentName,'') AS EquipmentName,
  _Equipment.AuthorizationGroup AS AuthorizationGroup,
  cast(_LocationAccountAssignment.FunctionalLocation as vdm_eam_tplnr) AS FunctionalLocation,
  coalesce(cast( _LocationAccountAssignment._FunctionalLocation._FunctionalLocationText[ 1: Language = $session.system_language ].FunctionalLocationName as rsh_eam_func_location_name preserving type ),'') AS FunctionalLocationName,
  _LocationAccountAssignment.AssetRoom AS AssetRoom,
  _LocationAccountAssignment.AssetLocation AS AssetLocation,
  _LocationAccountAssignment.PlantSection AS PlantSection,
  _LocationAccountAssignment.MaintenancePlant AS MaintenancePlant,
  _LocationAccountAssignment.ABCIndicator AS ABCIndicator,
  _LocationAccountAssignment._ABCIndicator._Text[1:Language = $session.system_language].ABCIndicatorDesc AS ABCIndicatorDesc,
  _Project.Project AS Project,
  _Project.ProjectDescription AS ProjectDescription,
  _WBSElement.WBSElement AS WBSElement,
  _WBSElement.WBSDescription AS WBSDescription,
  OperationPlannedWork,
  OperationPlannedWorkUnit,
  OperationDuration,
  OperationDurationUnit,
  OpErlstSchedldExecStrtDte,
  OpErlstSchedldExecStrtTme,
  OpErlstSchedldExecEndDte,
  OpErlstSchedldExecEndTme,
  OpLtstSchedldExecStrtDte,
  OpLtstSchedldExecStrtTme,
  OpLtstSchedldExecEndDte,
  OpLtstSchedldExecEndTme,
  OpBscStartDateConstraintType,
  ConstraintDateForBscStartDate,
  ConstraintTimeForBscStartTime,
  OpBscEndDateConstraintType,
  ConstraintDateForBscFinishDate,
  ConstraintTimeForBscFinishTime,
  MaintOrderProcessingContext,
  ServiceDocument,
  ServiceDocumentItem,
  ServiceDocumentType,
  ScheduledBasicStartDate,
  ScheduledBasicStartTime,
  ScheduledBasicEndDate,
  ScheduledBasicEndTime,
  SchedulingIsPerformedBackward,
  SchedulingType,
  LatestAcceptableCompletionDate,
  MaintOperationExecStageCode,
  PlannedStartDate,
  PlannedStartTime,
  PlannedEndDate,
  PlannedEndTime,
  ProcessingStatus,
  MaintOrdOpIsDispatched,
  coalesce( _MaterialStatus.MaterialStatus , 30 ) AS MaterialStatus,
  OperationHasSubOperations,
  _OperationPlanningValues.OpActualExecutionStartDate AS OpActualExecutionStartDate,
  _OperationPlanningValues.OpActualExecutionStartTime AS OpActualExecutionStartTime,
  _OperationPlanningValues.OpActualExecutionEndDate AS OpActualExecutionEndDate,
  _OperationPlanningValues.OpActualExecutionEndTime AS OpActualExecutionEndTime,
  MaintOrdProcessPhaseCode,
  MaintOrdProcessSubPhaseCode,
  MaintOrdOpProcessPhaseCode,
  MaintOrdOpProcessSubPhaseCode,
  OperationEquipment,
  _OperationEquipment._EquipmentText[ 1: Language = $session.system_language ].EquipmentName AS OperationEquipmentName,
  RelevantOperationFuncLocation,
  cast(_OperationFuncLocationLabel.FunctionalLocationLabelName as rsh_eams_oper_func_loc preserving type ) AS OperationFunctionalLocation,
  _OperationFunctionalLocation._FunctionalLocationText[ 1: Language = $session.system_language ].FunctionalLocationName AS OpFunctionalLocationName,
  _OperationPlanningValues.ConfirmationTotalQuantity AS ActualWorkQuantity,
  _OperationPlanningValues.OperationPlannedWorkUnit AS ActualWorkQuantityUnit,
  _LocationAccountAssignment.MaintObjectFreeDefinedAttrib AS SortField,
  SuperiorOperationInternalID
FROM P_RSHOperationsBase
LEFT OUTER JOIN C_RSHOpInMaintSchedSimulation AS _MaintSchedSimulation ON MaintOrderRoutingNumber = _MaintSchedSimulation.MaintOrderRoutingNumber AND MaintOrderOperationCounter = _MaintSchedSimulation.MaintOrderOperationCounter  -- association [0..*]
LEFT OUTER JOIN P_RSHMaintOrdOpFirstMaintSched AS _FirstMaintSched ON MaintOrderRoutingNumber = _FirstMaintSched.MaintOrderRoutingNumber AND MaintOrderOperationCounter = _FirstMaintSched.MaintOrderOperationCounter  -- association [1..1]
LEFT OUTER JOIN I_FunctionalLocationLabel AS _OperationFuncLocationLabel ON RelevantOperationFuncLocation = _OperationFuncLocationLabel.FunctionalLocation  -- association [0..1]
LEFT OUTER JOIN I_Equipment AS _OperationEquipment ON _OperationEquipment.Equipment = OperationEquipment  -- association [0..*]
LEFT OUTER JOIN I_FunctionalLocation AS _OperationFunctionalLocation ON _OperationFunctionalLocation.FunctionalLocation = RelevantOperationFuncLocation  -- association [0..*]
;