C_RSHMaintOperationAssignment

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 C_RSHMaintOperationAssignment.
-- 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: CRSHOPERASG

CREATE VIEW C_RSHMaintOperationAssignment AS
SELECT
  _RSHMaintOperationAssgmtTP.MaintOrderRoutingNumber AS MaintOrderRoutingNumber,
  _RSHMaintOperationAssgmtTP.MaintOrderOperationCounter AS MaintOrderOperationCounter,
  _RSHMaintOperationAssgmtTP.MaintOrderConfirmation AS MaintOrderConfirmation,
  _Operations.MaintenanceOrder AS MaintenanceOrder,
  _Operations.MaintenanceOrderOperation AS MaintenanceOrderOperation,
  _Operations.MaintenanceOrderSubOperation AS MaintenanceOrderSubOperation,
  _Operations.MaintOrderOperationInternalID AS MaintOrderOperationInternalID,
  _Operations.MaintenanceOrderDesc AS MaintenanceOrderDesc,
  _Operations.OrderType AS MaintenanceOrderType,
  _Operations.MaintenanceActivityType AS MaintenanceActivityType,
  _Operations.MaintenanceActivityTypeName AS MaintenanceActivityTypeName,
  _Operations.MaintPriority AS MaintPriority,
  _Operations.MaintPriorityType AS MaintPriorityType,
  _Operations.MaintPriorityDesc AS MaintPriorityDesc,
  _Operations.OperationHasLongText AS OperationHasLongText,
  _Operations.OperationHasLongTextDesc AS OperationHasLongTextDesc,
  _Operations.OperationHasSubOperations AS OperationHasSubOperations,
  _Operations.MaintenanceNotification AS MaintenanceNotification,
  _Operations.NotificationText AS NotificationText,
  _Operations.Equipment AS Equipment,
  _Operations._Equipment._EquipmentText[ 1: Language = $session.system_language ].EquipmentName AS EquipmentName,
  _Operations.FunctionalLocation AS FunctionalLocation,
  cast( _Operations._LocationAccountAssignment._FunctionalLocation._FunctionalLocationText[ 1: Language = $session.system_language ].FunctionalLocationName as rsh_eam_func_location_name preserving type ) AS FunctionalLocationName,
  _Operations.TechnicalObjectLabel AS TechnicalObjectLabel,
  _Operations.TechnicalObjectDescription AS TechnicalObjectDescription,
  _Operations.TechObjIsEquipOrFuncnlLoc AS TechObjIsEquipOrFuncnlLoc,
  _Operations._TechObjIsEquipOrFuncnlLoc._Text[1:Language=$session.system_language].TechObjIsEquipOrFuncnlLocDesc AS TechObjIsEquipOrFuncnlLocDesc,
  _Operations.OrderSystemCondition AS OrderSystemCondition,
  _Operations.OrderSystemConditionText AS OrderSystemConditionText,
  _Operations.OperationEquipment AS OperationEquipment,
  _Operations.OperationEquipmentName AS OperationEquipmentName,
  _Operations.OperationFunctionalLocation AS OperationFunctionalLocation,
  _Operations.OpFunctionalLocationName AS OpFunctionalLocationName,
  _Operations.OperationTechnicalObjectLabel AS OperationTechnicalObjectLabel,
  _Operations.OperationTechnicalObjectDesc AS OperationTechnicalObjectDesc,
  _Operations.OpTechObjEquipOrFuncnlLoc AS OpTechObjEquipOrFuncnlLoc,
  _Operations._OperationTechObjIsEquip._Text[1:Language=$session.system_language].TechObjIsEquipOrFuncnlLocDesc AS OpTechObjEquipOrFuncnlLocDesc,
  _Operations.OperationSystemCondition AS OperationSystemCondition,
  _Operations.OperationSystemConditionText AS OperationSystemConditionText,
  _Operations.MaintenancePlannerGroup AS MaintenancePlannerGroup,
  _Operations.MaintenanceRevision AS MaintenanceRevision,
  _Operations.AssetRoom AS AssetRoom,
  _Operations.AssetLocation AS AssetLocation,
  _Operations.PlantSection AS PlantSection,
  _Operations.MaintenancePlan AS MaintenancePlan,
  _Operations.SuperiorProjectNetwork AS SuperiorProjectNetwork,
  _Operations.MainWorkCenter AS MainWorkCenter,
  _Operations.MainWorkCenterPlant AS MainWorkCenterPlant,
  _Operations.OperationControlKey AS OperationControlKey,
  _Operations.OperationDescription AS OperationDescription,
  _Operations.SubOperationText AS SubOperationText,
  _Operations.LatestAcceptableCompletionDate AS LatestAcceptableCompletionDate,
  _RSHMaintOperationAssgmtTP.OperationPersonResponsibleID AS OperationPersonResponsibleID,
  cast ( _PersonResponsible.PersonFullName as rsh_eam_person_resp_name) AS OperationPersonRespName,
  _Operations.WorkCenter AS WorkCenter,
  _Operations.WorkCenterInternalID AS WorkCenterInternalID,
  _Operations.WorkCenterTypeCode AS WorkCenterTypeCode,
  _Operations.Plant AS Plant,
  _Operations.OperationPlannedWork AS OperationPlannedWork,
  _Operations.OperationPlannedWorkUnit AS OperationPlannedWorkUnit,
  _Operations.OperationDuration AS OperationDuration,
  _Operations.OperationDurationUnit AS OperationDurationUnit,
  cast('' as abap.char( 1333 )) AS MaintOrderOperationLongText,
  _Operations.MaintOrderProcessingContext AS MaintOrderProcessingContext,
  _Operations._MaintOrderProcessingContextVH.MaintOrdProcessingContextText AS MaintOrdProcessingContextText,
  _Operations.ServiceDocument AS ServiceDocument,
  _Operations.ServiceDocumentDescription AS ServiceDocumentDescription,
  _Operations.ServiceDocumentItem AS ServiceDocumentItem,
  _Operations.ServiceDocumentItemDescription AS ServiceDocumentItemDescription,
  _Operations.ServiceDocumentType AS ServiceDocumentType,
  _Operations.SoldToParty AS SoldToParty,
  _Operations.BusinessPartnerFullName AS BusinessPartnerFullName,
  _Operations.SalesOrganization AS SalesOrganization,
  _Operations.SalesOrganizationName AS SalesOrganizationName,
  _Operations.Product AS Product,
  _Operations.ProductName AS ProductName,
  _Operations.OpErlstSchedldExecStrtDte AS OpErlstSchedldExecStrtDte,
  _Operations.OpErlstSchedldExecStrtTme AS OpErlstSchedldExecStrtTme,
  _Operations.OpErlstSchedldExecEndDte AS OpErlstSchedldExecEndDte,
  _Operations.OpErlstSchedldExecEndTme AS OpErlstSchedldExecEndTme,
  _Operations.OpLtstSchedldExecStrtDte AS OpLtstSchedldExecStrtDte,
  _Operations.OpLtstSchedldExecStrtTme AS OpLtstSchedldExecStrtTme,
  _Operations.OpLtstSchedldExecEndDte AS OpLtstSchedldExecEndDte,
  _Operations.OpLtstSchedldExecEndTme AS OpLtstSchedldExecEndTme,
  _Operations.SchedulingIsPerformedBackward AS SchedulingIsPerformedBackward,
  _Operations.SchedulingType AS SchedulingType,
  _Operations.SchedulingTypeName AS SchedulingTypeName,
  _Operations.NumberOfCapacities AS NumberOfCapacities,
  _Operations.PeriodType AS PeriodType,
  _Operations.ProcessingStatus AS ProcessingStatus,
  _Operations.ProcessingStatusText AS ProcessingStatusText,
  _Operations.ProcessingStatusColorCode AS ProcessingStatusColorCode,
  _Operations.MaterialStatus AS MaterialStatus,
  _Operations.MaterialStatusCode AS MaterialStatusCode,
  _Operations.MaterialStatusColorCode AS MaterialStatusColorCode,
  _Operations.MaterialStatusText AS MaterialStatusText,
  _Operations.HasCrossOrderRelationship AS HasCrossOrderRelationship,
  _Operations.AuthorizationGroup AS AuthorizationGroup,
  _Operations.MaintenancePlant AS MaintenancePlant,
  _Operations.ControllingArea AS ControllingArea,
  _RSHMaintOperationAssgmtTP.MaintOperationAssignTechStatus AS MaintOperationAssignTechStatus,
  _TechnicalStatusVH.MaintOpAssignTechStatusText AS MaintOpAssignTechStatusText,
  _RSHMaintOperationAssgmtTP.MaintOperationAssignmentStatus AS MaintOperationAssignmentStatus,
  _AssignedStatusVH.MaintOpAssignmentStatusText AS MaintOpAssignmentStatusText,
  cast(_Operations.ResponsibleCostCenter as rsh_eam_resp_cost_center) AS ResponsibleCostCenter,
  _Operations.MaintenancePlanningPlant AS MaintenancePlanningPlant,
  _Operations.MaintObjectLocAcctAssgmtNmbr AS MaintObjectLocAcctAssgmtNmbr,
  _Operations._MaintOperationExecStageCode.SequenceNumber AS SortSequence,
  _Operations.MaintOperationExecStageCode AS MaintOperationExecStageCode,
  _Operations._MaintOpExecStageCodeText[1:LanguageCode = $session.system_language].MaintOpExecutionStageName AS MaintOpExecutionStageName,
  _Operations._MaintOpExecStageCodeText[1:LanguageCode = $session.system_language].MaintOpExecStageShortText AS MaintOpExecStageShortText,
  _Operations.MaintOrdProcessPhaseCode AS MaintOrdProcessPhaseCode
FROM I_RSHMaintOperationAssgmtTP AS _RSHMaintOperationAssgmtTP
LEFT OUTER JOIN C_RSHOperations AS _Operations ON _RSHMaintOperationAssgmtTP.MaintOrderRoutingNumber = _Operations.MaintOrderRoutingNumber AND _RSHMaintOperationAssgmtTP.MaintOrderOperationCounter = _Operations.MaintOrderOperationCounter AND _RSHMaintOperationAssgmtTP.MaintOrderConfirmation = _Operations.MaintOrderConfirmation  -- association [1..1]
LEFT OUTER JOIN C_RSHAssgmtTechStatusTxt AS _TechnicalStatusVH ON _TechnicalStatusVH.MaintOperationAssignTechStatus = _RSHMaintOperationAssgmtTP.MaintOperationAssignTechStatus  -- association [1..1]
LEFT OUTER JOIN C_RSHOpAssgmtStatusText AS _AssignedStatusVH ON _AssignedStatusVH.MaintOperationAssignmentStatus = _RSHMaintOperationAssgmtTP.MaintOperationAssignmentStatus  -- association [1..1]
LEFT OUTER JOIN I_WorkAssignment AS _PersonResponsible ON _PersonResponsible.WorkAssignment = _RSHMaintOperationAssgmtTP.OperationPersonResponsibleID  -- association [1..1]
LEFT OUTER JOIN C_ObjPgMaintObjPhaseControl AS _ObjPgMaintObjPhaseControl ON _ObjPgMaintObjPhaseControl.StatusObject = maintenanceorderinternalid AND _ObjPgMaintObjPhaseControl.EAMBlockerCodeEntityType = 'ORI' AND _ObjPgMaintObjPhaseControl.MaintenanceOrderType = MaintenanceOrderType  -- association [0..*]
LEFT OUTER JOIN C_ObjPgMaintObjPhaseControl AS _ObjPgMaintObjOrdOpPhaseCntrl ON _ObjPgMaintObjOrdOpPhaseCntrl.StatusObject = maintorderoperationinternalid AND _ObjPgMaintObjOrdOpPhaseCntrl.EAMBlockerCodeEntityType = 'OVG' AND _ObjPgMaintObjOrdOpPhaseCntrl.MaintenanceOrderType = MaintenanceOrderType  -- association [0..*]
LEFT OUTER JOIN I_RSHOrderUserStatus AS _MaintOrdActiveUserStatus ON _MaintOrdActiveUserStatus.StatusObject = maintenanceorderinternalid  -- association [0..*]
LEFT OUTER JOIN I_RSHOperationUserStatus AS _MaintOrdOpActiveUserStatus ON _MaintOrdOpActiveUserStatus.StatusObject = maintorderoperationinternalid  -- association [0..*]
LEFT OUTER JOIN I_RSHOperationAssignment AS _AssignedPeople ON _AssignedPeople.MaintOrderRoutingNumber = MaintOrderRoutingNumber AND _AssignedPeople.MaintOrderOperationCounter = MaintOrderOperationCounter  -- association [0..1]
LEFT OUTER JOIN I_EAMProcessPhase AS _MaintOrdProcessPhase ON maintordprocessphasecode = _MaintOrdProcessPhase.EAMProcessPhaseCode  -- association [0..1]
LEFT OUTER JOIN I_EAMProcessSubPhase AS _MaintOrdProcessSubPhase ON maintordprocesssubphasecode = _MaintOrdProcessSubPhase.EAMProcessSubPhaseCode  -- association [0..1]
LEFT OUTER JOIN I_EAMProcessPhase AS _MaintOrdOpProcessPhase ON maintordopprocessphasecode = _MaintOrdOpProcessPhase.EAMProcessPhaseCode  -- association [0..1]
LEFT OUTER JOIN I_EAMProcessSubPhase AS _MaintOrdOpProcessSubPhase ON maintordopprocesssubphasecode = _MaintOrdOpProcessSubPhase.EAMProcessSubPhaseCode  -- association [0..1]
;