C_ObjPgMaintOrderOperation

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_ObjPgMaintOrderOperation.
-- 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: COBJPGMAINTORDOP

CREATE VIEW C_ObjPgMaintOrderOperation AS
SELECT
  _MaintenanceOrderOperation.MaintenanceOrder AS MaintenanceOrder,
  _MaintenanceOrderOperation.MaintenanceOrderOperation AS MaintenanceOrderOperation,
  _MaintenanceOrderOperation.MaintenanceOrderSubOperation AS MaintenanceOrderSubOperation,
  _MaintenanceOrderOperation.OperationDescription AS OperationDescription,
  _MaintenanceOrderOperation.OperationControlKey AS OperationControlKey,
  _MaintenanceOrderOperation._OperationControlKey._Text[1:Language = $session.system_language].OperationControlProfileName AS OperationControlProfileName,
  _MaintenanceOrderOperation._OperationControlKey.OperationExternalProcessing AS OperationExternalProcessing,
  _MaintenanceOrderOperation._OperationControlKey._OperationExternalProcessing._Text[1:Language = $session.system_language].OperationExternalProcName AS OperationExternalProcName,
  _MaintenanceOrderOperation._WorkCenter.WorkCenter AS WorkCenter,
  _MaintenanceOrderOperation._WorkCenter._Text[1:Language = $session.system_language].WorkCenterText AS WorkCenterText,
  _MaintenanceOrderOperation.Plant AS Plant,
  _MaintenanceOrderOperation._Plant.PlantName AS PlantName,
  _MaintenanceOrderOperation._OperationPlanningValues.OperationPlannedWork AS OperationPlannedWork,
  _MaintenanceOrderOperation._OperationPlanningValues.OperationPlannedWorkUnit AS OperationPlannedWorkUnit,
  _MaintenanceOrderOperation.OperationPersonResponsible AS OperationPersonResponsible,
  _MaintenanceOrderOperation._PersonResponsible.PersonFullName AS OperationPersonRespName,
  cast (' ' as abap.sstring( 1333 )) AS MaintOrderOperationLongText,
  _MaintenanceOrderOperation.OperationHasLongText AS OperationHasLongText,
  _MaintenanceOrderOperation._TechnicalObject.TechnicalObjectLabel AS TechnicalObjectLabel,
  _MaintenanceOrderOperation._TechnicalObject._TechnicalObjectText[1:Language = $session.system_language].TechnicalObjectDescription AS TechnicalObjectDescription,
  _MaintenanceOrderOperation.TechObjIsEquipOrFuncnlLoc AS TechObjIsEquipOrFuncnlLoc,
  _MaintenanceOrderOperation._TechObjIsEquipOrFuncnlLoc._Text[1:Language=$session.system_language].TechObjIsEquipOrFuncnlLocDesc AS TechObjIsEquipOrFuncnlLocDesc,
  _MaintOrderTechObj.MaintenanceOrderType AS MaintenanceOrderType,
  _MaintOrderTechObj.MaintOrderProcessingContext AS MaintOrderProcessingContext,
  _MaintOrderTechObj._MaintOrderProcessingContext._Text[1:Language = $session.system_language].MaintOrdProcessingContextText AS MaintOrdProcessingContextText,
  _MaintOrderTechObj._Order._OrderType._Text[1:Language = $session.system_language].OrderTypeName AS OrderTypeName,
  _MaintOrderTechObj._Order._OrderTypeDetails.AcctAssgmtIsDfndAtOpLvl AS AcctAssgmtIsDfndAtOpLvl,
  _MaintenanceOrderOperation.OperationDuration AS OperationDuration,
  _MaintenanceOrderOperation.OperationDurationUnit AS OperationDurationUnit,
  _MaintenanceOrderOperation.OperationPurgInfoRecdSearchTxt AS OperationPurgInfoRecdSearchTxt,
  _MaintenanceOrderOperation.OperationRequisitionerName AS OperationRequisitionerName,
  _MaintenanceOrderOperation.OperationGoodsRecipientName AS OperationGoodsRecipientName,
  _MaintenanceOrderOperation.OpExternalProcessingPrice AS OpExternalProcessingPrice,
  _MaintenanceOrderOperation.OpExternalProcessingCurrency AS OpExternalProcessingCurrency,
  _MaintenanceOrderOperation.OpExternalProcessingPriceUnit AS OpExternalProcessingPriceUnit,
  _MaintenanceOrderOperation.OperationTrackingNumber AS OperationTrackingNumber,
  _MaintenanceOrderOperation.PurchaseRequisition AS PurchaseRequisition,
  _MaintenanceOrderOperation.PurchaseRequisitionItem AS PurchaseRequisitionItem,
  _MaintenanceOrderOperation.OperationPurchasingInfoRecord AS OperationPurchasingInfoRecord,
  _MaintenanceOrderOperation.OperationUnloadingPointName AS OperationUnloadingPointName,
  _MaintenanceOrderOperation.OpPurchaseOutlineAgreement AS OpPurchaseOutlineAgreement,
  _MaintenanceOrderOperation.OpPurchaseOutlineAgreementItem AS OpPurchaseOutlineAgreementItem,
  _MaintenanceOrderOperation.PurchasingGroup AS PurchasingGroup,
  _MaintenanceOrderOperation.PurchasingOrganization AS PurchasingOrganization,
  _MaintenanceOrderOperation.OperationSupplier AS OperationSupplier,
  _MaintenanceOrderOperation._Supplier.SupplierName AS SupplierName,
  _MaintenanceOrderOperation.Assembly AS Assembly,
  _MaintenanceOrderOperation._Assembly._Text[1:Language = $session.system_language].MaterialName AS MaterialName,
  _MaintenanceOrderOperation.MaterialGroup AS MaterialGroup,
  _MaintenanceOrderOperation._MaterialGroup._Text[1:Language = $session.system_language].MaterialGroupName AS MaterialGroupName,
  _MaintenanceOrderOperation.CostElement AS CostElement,
  _MaintenanceOrderOperation._CostElement._Text[1:Language = $session.system_language].CostElementName AS CostElementName,
  _MaintenanceOrderOperation.OperationSystemCondition AS OperationSystemCondition,
  _MaintenanceOrderOperation._OperationSystemCondition._Text[1:Language = $session.system_language].OperationSystemConditionText AS OperationSystemConditionText,
  _MaintenanceOrderOperation.CostCtrActivityType AS CostCtrActivityType,
  _MaintenanceOrderOperation.ControllingArea AS ControllingArea,
  _CostCenterActivityTypeText[1:Language = $session.system_language].CostCtrActivityTypeName AS CostCtrActivityTypeName,
  _MaintenanceOrderOperation.OperationCalculationControl AS OperationCalculationControl,
  _MaintenanceOrderOperation._OperationCalculationControl._Text[1:Language = $session.system_language].OperationCalcControlDesc AS OperationCalcControlDesc,
  _MaintenanceOrderOperation.OperationWorkPercent AS OperationWorkPercent,
  _MaintenanceOrderOperation.NumberOfCapacities AS NumberOfCapacities,
  MaintOrdOpProcessPhaseCode,
  MaintOrdOpProcessSubPhaseCode,
  cast('0' as abap.int2) AS MaintObjNmbrOfPhaseCtrlCodes,
  cast('' as eams_ime_active preserving type) AS MaintOrdTypeHasActvPhaseModel,
  cast( '' as char1 ) AS IsCloudSystem,
  _MaintenanceOrderOperation._OperationPlanningValues.OperationQuantity AS OperationQuantity,
  _MaintenanceOrderOperation._OperationPlanningValues.OperationQuantityUnit AS OperationQuantityUnit,
  _MaintenanceOrderOperation._OperationPlanningValues.OpPlndDeliveryDurationInDays AS OpPlndDeliveryDurationInDays,
  _MaintenanceOrderOperation._OperationPlanningValues.OpErlstSchedldExecStrtDte AS OpErlstSchedldExecStrtDte,
  _MaintenanceOrderOperation._OperationPlanningValues.OpErlstSchedldExecStrtTme AS OpErlstSchedldExecStrtTme,
  _MaintenanceOrderOperation._OperationPlanningValues.OpErlstSchedldExecEndDte AS OpErlstSchedldExecEndDte,
  _MaintenanceOrderOperation._OperationPlanningValues.OpErlstSchedldExecEndTme AS OpErlstSchedldExecEndTme,
  _MaintenanceOrderOperation._OperationPlanningValues.OpLtstSchedldExecStrtDte AS OpLtstSchedldExecStrtDte,
  _MaintenanceOrderOperation._OperationPlanningValues.OpLtstSchedldExecStrtTme AS OpLtstSchedldExecStrtTme,
  _MaintenanceOrderOperation._OperationPlanningValues.OpLtstSchedldExecEndDte AS OpLtstSchedldExecEndDte,
  _MaintenanceOrderOperation._OperationPlanningValues.OpLtstSchedldExecEndTme AS OpLtstSchedldExecEndTme,
  _MaintenanceOrderOperation._OperationPlanningValues.OpActualExecutionStartDate AS OpActualExecutionStartDate,
  _MaintenanceOrderOperation._OperationPlanningValues.OpActualExecutionStartTime AS OpActualExecutionStartTime,
  _MaintenanceOrderOperation._OperationPlanningValues.OpActualExecutionEndDate AS OpActualExecutionEndDate,
  _MaintenanceOrderOperation._OperationPlanningValues.OpActualExecutionEndTime AS OpActualExecutionEndTime,
  _MaintenanceOrderOperation._OperationPlanningValues.ConfirmationTotalQuantity AS ConfirmationTotalQuantity,
  _MaintenanceOrderOperation._MaintOrderOperObjectListLink._MaintenanceItemObject.MaintenanceNotification AS MaintenanceNotification,
  _MaintenanceOrderOperation._MaintOrderOperObjectListLink._MaintenanceItemObject._MaintenanceNotification.NotificationText AS MaintenanceNotificationText,
  _MaintOpExecStageCodeText[1:LanguageCode = $session.system_language].MaintOpExecutionStageName AS MaintOpExecutionStageName,
  _MaintOpExecStageCodeText[1:LanguageCode = $session.system_language].MaintOpExecStageShortText AS MaintOpExecStageShortText,
  _MaintenanceOrderOperation._WorkCenter.WorkCenter AS OperationWorkCenter,
  _MaintenanceOrderOperation.MaintOrderOperationInternalID AS MaintOrderOperationInternalID,
  _MaintenanceOrderOperation.MaintOrderRoutingNumber AS MaintOrderRoutingNumber,
  _MaintenanceOrderOperation.MaintOrderOperationCounter AS MaintOrderOperationCounter,
  _MaintenanceOrderOperation.CapacityRequirement AS CapacityRequirement,
  _MaintenanceOrderOperation.CapacityRequirementItem AS CapacityRequirementItem,
  _MaintenanceOrderOperation.TechnicalObject AS TechnicalObject,
  _MaintenanceOrderOperation.MaintOperationExecStageCode AS MaintOperationExecStageCode,
  _MaintOrderOpCostAggrg.MaintOrderTotalActualCost AS MaintOrderTotalActualCost,
  _MaintOrderOpCostAggrg.Currency AS Currency,
  _MaintenanceOrderOperation._PersonResponsible AS _PersonResponsible,
  _MaintenanceOrderOperation._Supplier AS _Supplier
FROM P_ObjPgMaintOrderAndOperation AS _MaintenanceOrderOperation
LEFT OUTER JOIN C_ObjPgMaintOrderOpMaterial AS _MaintOrderOpMaterial ON _MaintOrderOpMaterial.MaintenanceOrder = MaintenanceOrder AND _MaintOrderOpMaterial.MaintenanceOrderOperation = MaintenanceOrderOperation  -- association [0..*]
LEFT OUTER JOIN C_ObjPgMaintOrdOpProdnRsceTool AS _MaintOrderOpProdnRsceTool ON _MaintOrderOpProdnRsceTool.OrderInternalBillOfOperations = MaintOrderRoutingNumber AND _MaintOrderOpProdnRsceTool.OrderIntBillOfOperationsItem = MaintOrderOperationCounter  -- association [0..*]
LEFT OUTER JOIN C_ObjPgMaintOrdOpCapReq AS _MaintOrderOpCapReq ON _MaintOrderOpCapReq.CapacityRequirement = CapacityRequirement AND _MaintOrderOpCapReq.CapacityRequirementItem = CapacityRequirementItem AND _MaintOrderOpCapReq.CapacityRequirementSplit != 0  -- association [0..*]
LEFT OUTER JOIN C_ObjPgMaintOrderOperationCost AS _MaintOrderOpCost ON _MaintOrderOpCost.MaintOrderOperationInternalID = MaintOrderOperationInternalID  -- association [0..*]
LEFT OUTER JOIN C_ObjPgMaintOrdOpCostAggrgData AS _MaintOrderOpCostAggrg ON _MaintOrderOpCostAggrg.MaintOrderOperationInternalID = MaintOrderOperationInternalID  -- association [0..1]
LEFT OUTER JOIN I_MaintOrderTechObj AS _MaintOrderTechObj ON _MaintOrderTechObj.MaintenanceOrder = MaintenanceOrder  -- association [0..1]
LEFT OUTER JOIN C_MaintNotificationQuickVw AS _MaintNotificationQuickView ON MaintenanceNotification = _MaintNotificationQuickView.MaintenanceNotification  -- association [0..1]
LEFT OUTER JOIN C_MaintenanceObjectStatus AS _SystemStatus ON _SystemStatus.StatusObject = MaintOrderOperationInternalID AND _SystemStatus.IsUserStatus = ' '  -- association [0..*]
LEFT OUTER JOIN C_MaintenanceObjectStatus AS _UserStatusWthoutStsNmbr ON _UserStatusWthoutStsNmbr.StatusObject = MaintOrderOperationInternalID AND _UserStatusWthoutStsNmbr.StatusSequenceNumber = '00' AND _UserStatusWthoutStsNmbr.IsUserStatus = 'X'  -- association [0..*]
LEFT OUTER JOIN C_MaintObjUserStatusWthStsNmbr AS _UserStatusWithStatusNumber ON _UserStatusWithStatusNumber.StatusObject = MaintOrderOperationInternalID AND _UserStatusWithStatusNumber.StatusSequenceNumber != '00' AND _UserStatusWithStatusNumber.IsUserStatus = 'X'  -- association [0..1]
LEFT OUTER JOIN C_EAMProductQuickVw AS _EAMProductQuickVw ON _EAMProductQuickVw.Material = Assembly  -- association [0..1]
LEFT OUTER JOIN I_MaintOpExecStageCodeText AS _MaintOpExecStageCodeText ON _MaintOpExecStageCodeText.MaintOperationExecStageCode = MaintOperationExecStageCode  -- association [0..*]
LEFT OUTER JOIN I_CostCenterActivityTypeText AS _CostCenterActivityTypeText ON ControllingArea = _CostCenterActivityTypeText.ControllingArea AND CostCtrActivityType = _CostCenterActivityTypeText.CostCtrActivityType AND ValidityStartDate <= $session.system_date AND ValidityEndDate >= $session.system_date  -- association [0..*]
LEFT OUTER JOIN E_MaintenanceOrder AS _MaintenanceOrderExtension ON MaintenanceOrder = _MaintenanceOrderExtension.MaintenanceOrder  -- association [0..1]
LEFT OUTER JOIN E_MaintenanceOrderOperation AS _MaintOrderOperExtension ON MaintOrderRoutingNumber = _MaintOrderOperExtension.MaintOrderRoutingNumber AND MaintOrderOperationCounter = _MaintOrderOperExtension.MaintOrderOperationCounter  -- association [0..1]
LEFT OUTER JOIN C_ObjPgMaintObjPhaseControl AS _ObjPgMaintObjPhaseControl ON _ObjPgMaintObjPhaseControl.StatusObject = MaintOrderOperationInternalID AND _ObjPgMaintObjPhaseControl.EAMBlockerCodeEntityType = 'OVG' AND _ObjPgMaintObjPhaseControl.MaintenanceOrderType = maintenanceordertype  -- association [0..*]
LEFT OUTER JOIN I_EAMProcessPhaseText AS _EAMOrderOpProcessPhase ON _EAMOrderOpProcessPhase.EAMProcessPhaseCode = MaintOrdOpProcessPhaseCode  -- association [0..*]
LEFT OUTER JOIN I_EAMProcessSubPhaseText AS _EAMOrderOpProcessSubPhase ON _EAMOrderOpProcessSubPhase.EAMProcessSubPhaseCode = MaintOrdOpProcessSubPhaseCode  -- association [0..*]
LEFT OUTER JOIN C_MaintOrdProcessingContextVH AS _MaintOrderProcessingContextVH ON _MaintOrderProcessingContextVH.MaintOrderProcessingContext = MaintOrderProcessingContext  -- association [0..1]
LEFT OUTER JOIN C_MaintOrderOpSrvcObjectPage AS _MaintOrderOpService ON MaintenanceOrder = _MaintOrderOpService.MaintenanceOrder AND MaintenanceOrderOperation = _MaintOrderOpService.MaintenanceOrderOperation AND MaintenanceOrderSubOperation = _MaintOrderOpService.MaintenanceOrderSubOperation  -- association [0..*]
;