C_MaintenanceOrderOperationTP

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_MaintenanceOrderOperationTP.
-- 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.

CREATE VIEW C_MaintenanceOrderOperationTP AS
SELECT
  MaintenanceOrder,
  MaintenanceOrderOperation,
  MaintenanceOrderSubOperation,
  MaintOrderOperationForEdit,
  MaintOrderSubOperationForEdit,
  SAPObjectNodeType,
  MaintOrderOpReuseObjectLinkKey,
  _MaintenanceOrder.MaintenanceOrderType AS MaintenanceOrderType,
  ControllingArea,
  AllMaintOrdCompCmtdQtsAreKept,
  _MaintenanceOrder.MaintOrdBasicStartDate AS MaintOrdBasicStartDate,
  MaintOrderOperationInternalID,
  _MaintenanceOrder._ControllingArea.FiscalYearVariant AS FiscalYearVariant,
  OperationDescription,
  OperationControlKey,
  _OperationControlProfileText.OperationControlProfileName : localized AS OperationControlProfileNamelocalized,
  MaintOperationExecStageCode,
  _MaintOpExecStageCodeText.MaintOpExecutionStageName : localized AS MaintOpExecutionStageNamelocalized,
  MaintenanceNotification,
  _MaintenanceNotification.NotificationText AS NotificationText,
  Assembly,
  _AssemblyText.MaterialName as AssemblyName : localized AS MaterialNameasAssemblyNamelocalized,
  Equipment,
  MaintenanceObjectListItem,
  FunctionalLocation,
  _EquipmentText.EquipmentName : localized AS EquipmentNamelocalized,
  _FunctionalLocationLabel.FunctionalLocationLabelName AS FunctionalLocationLabelName,
  _FunctionalLocationText.FunctionalLocationName : localized AS FunctionalLocationNamelocalized,
  virtual TechnicalObject : eams_tec_obj AS virtualTechnicalObjecteams_tec_obj,
  virtual TechnicalObjectLabel : eams_tec_obj AS virtualTechnicalObjectLabeleams_tec_obj,
  virtual MaintOrdOpNmbrOfActvPhseCtrl : abap.int4 AS int4,
  ActivityType,
  _CostCenterActivityTypeText.CostCtrActivityTypeName : localized AS CostCtrActivityTypeNamelocalized,
  OperationSystemCondition,
  _MaintOpSystemConditionText.OperationSystemConditionText : localized AS OperationSystemConditionTextlocalized,
  MaintenanceActivityType,
  _MaintenanceActivityTypeText.MaintenanceActivityTypeName : localized AS MaintenanceActivityTypeNamelocalized,
  WorkCenter,
  _WorkCenterText.WorkCenterText : localized AS WorkCenterTextlocalized,
  Plant,
  _Plant.PlantName AS PlantName,
  OperationPersonResponsible,
  _PersonWorkAgreement.PersonFullName AS PersonFullName,
  MaintOrdOperationWorkDuration,
  MaintOrdOpWorkDurationUnit,
  MaintOrderOperationDuration,
  MaintOrdOperationDurationUnit,
  NumberOfCapacities,
  OperationCalculationControl,
  _OperationCalcControlText.OperationCalcControlDesc : localized AS OperationCalcControlDesclocalized,
  ActualWorkQuantity,
  MaintOrderConfirmation,
  MaintOrderConfCntrValue,
  MaintOrdOpHasNoRemainingWork,
  MaintOrdOpProcessPhaseCode,
  _EAMProcessPhaseText.EAMProcessPhaseCodeDesc : localized AS EAMProcessPhaseCodeDesclocalized,
  MaintOrdOpProcessSubPhaseCode,
  _EAMProcessSubPhaseText.EAMProcessSubPhaseCodeDesc : localized AS EAMProcessSubPhaseCodeDesclocalized,
  OpErlstSchedldExecStrtDteTme,
  OpErlstSchedldExecEndDteTme,
  OpLtstSchedldExecStrtDteTme,
  OpLtstSchedldExecEndDteTme,
  OpActualExecutionStartDateTime,
  OpActualExecutionEndDateTime,
  MaintOrderOperationQuantity,
  MaintOrdOperationQuantityUnit,
  OpExternalProcessingPrice,
  OpExternalProcessingCurrency,
  OpExternalProcessingPriceUnit,
  _OperationControlKey.OperationExternalProcessing AS OperationExternalProcessing,
  _OperationControlKey.OperationIsProcessedExternally AS OperationIsProcessedExternally,
  _OperationControlKey.OperationIsProcessedInternally AS OperationIsProcessedInternally,
  MaterialGroup,
  _MaterialGroupText.MaterialGroupName : localized AS MaterialGroupNamelocalized,
  PurchasingGroup,
  _PurchasingGroup.PurchasingGroupName AS PurchasingGroupName,
  PurchasingOrganization,
  _PurchasingOrganization.PurchasingOrganizationName AS PurchasingOrganizationName,
  OperationSupplier,
  _Supplier.SupplierName AS SupplierName,
  OpPurchaseOutlineAgreement,
  OpPurchaseOutlineAgreementItem,
  EAMPlannedDeliveryDurnInDays,
  OperationPurgInfoRecdSearchTxt,
  _MaintenanceOrder._ControllingArea.ChartOfAccounts AS ChartOfAccounts,
  CostElement,
  _CostElement._Text.CostElementName : localized AS CostElementNamelocalized,
  OperationPurchasingInfoRecord,
  MaintOrdOperationIsMRPRelevant AS PurReqnOrResvnGeneration,
  _PurReqnOrResvnGenerationText.PurReqnOrResvnGenerationName : localized AS PurReqnOrResvnGenerationNamelocalized,
  PurchaseRequisition,
  PurchaseRequisitionItem,
  ExtProcgOperationHasSubcontrg,
  MaintOrdOpDelivDateAdjustment,
  _MaintOrdOpDeliveryDateAdjmtT.MaintOrdOpDelivDateAdjustName : localized AS MaintOrdOpDelivDateAdjustNamelocalized,
  virtual PurchasingDocument : ebeln AS virtualPurchasingDocumentebeln,
  virtual PurchasingDocumentItem : ebelp AS virtualPurchasingDocumentItemebelp,
  virtual NmbrOfPurOrdForPurReqnItem : abap.int2 AS int2,
  virtual ReceivedQuantity : abap.quan(13,3) AS quan133,
  _MaintenanceOrder._MaintOrderTypeControlParam.MaintOrdTypeHasActvPhaseModel AS MaintOrdTypeHasActvPhaseModel,
  virtual SystemStatusText : j_stext AS virtualSystemStatusTextj_stext,
  MaintOrderRoutingNumber,
  MaintenanceOrderRoutingNode,
  MaintOrdOpLongTextLanguage,
  MaintOrdOpCommentLanguage,
  MaintOrdOpRemarkLanguage,
  MaintOrdOperationNoteLanguage,
  MaintenanceJobVerification,
  _MaintJobVerification[ 1: Language = $session.system_language ].MaintJobVerificationText AS MaintJobVerificationText,
  virtual MaintOrdOpRmngWorkDuration : abap.dec(10,2) AS dec102,
  MaintenanceOrderOperationUUID,
  TskPlngElmntAssgmtUUID,
  TaskPlanningElementIdentifier,
  TskPlngElmntAssgmtDescription,
  _FunctionalLocationLabel.FuncnlLocUserLabelName AS FuncnlLocUserLabelName,
  _FunctionalLocationLabel.FuncnlLocPrimaryLabelName AS FuncnlLocPrimaryLabelName,
  _MaintNotificationTechObj._TechnicalObject.TechnicalObjectDescription AS OperationTechnicalObjectDesc,
  MaintOperationalChecklistType,
  _CheckListType[ 1: Language = $session.system_language ].MaintenanceChecklistTypeText AS MaintenanceChecklistTypeText
FROM R_MaintenanceOrderOperationTP
LEFT OUTER JOIN C_MaintNotificationQuickVw AS _MaintNotificationQuickView ON _MaintNotificationQuickView.MaintenanceNotification = MaintenanceNotification  -- association [0..1]
LEFT OUTER JOIN C_MaintenanceObjectStatus AS _MaintenanceOrdOpSystemStatus ON _MaintenanceOrdOpSystemStatus.StatusObject = MaintOrderOperationInternalID AND _MaintenanceOrdOpSystemStatus.IsUserStatus = ''  -- association [0..*]
LEFT OUTER JOIN C_EAMProductQuickVw AS _EAMProductQuickVw ON _EAMProductQuickVw.Material = Assembly  -- association [0..1]
LEFT OUTER JOIN C_MaintOrderOpPhaseControl AS _MaintOrdOpPhaseControl ON _MaintOrdOpPhaseControl.MaintenanceOrder = MaintenanceOrder AND _MaintOrdOpPhaseControl.MaintenanceOrderOperation = MaintenanceOrderOperation AND _MaintOrdOpPhaseControl.MaintenanceOrderSubOperation = MaintenanceOrderSubOperation  -- association [0..*]
LEFT OUTER JOIN C_MaintOrdPurOrderItem AS _PurchaseOrder ON PurchaseRequisition = _PurchaseOrder.PurchaseRequisition AND PurchaseRequisitionItem = _PurchaseOrder.PurchaseRequisitionItem AND _PurchaseOrder.PurchaseRequisition is not initial  -- association [0..*]
LEFT OUTER JOIN C_MaintenanceOrderCheckList AS _CheckListOp ON _CheckListOp.MaintenanceOrder = MaintenanceOrder AND _CheckListOp.MaintenanceOrderOperation = MaintenanceOrderOperation  -- association [0..*]
LEFT OUTER JOIN C_MaintOrdOperationWorkPermit AS _WorkPermitOp ON _WorkPermitOp.MaintenanceOrder = MaintenanceOrder AND _WorkPermitOp.MaintenanceOrderOperation = MaintenanceOrderOperation  -- association [0..*]
;