I_MaintOrderOperation_DEX

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 I_MaintOrderOperation_DEX.
-- 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: IPMORDOPERDEX

CREATE VIEW I_MaintOrderOperation_DEX AS
SELECT
  MaintOrderRoutingNumber,
  cast( MaintenanceOrderRoutingNode as operationinternalid preserving type ) AS MaintenanceOrderRoutingNode,
  MaintenanceOrder,
  BillOfOperationsApplication,
  _MaintenanceOrder._LocationAccountAssignment.FunctionalLocation AS FunctionalLocation,
  _MaintenanceOrder.Equipment AS Equipment,
  _MaintenanceOrder.Assembly AS Assembly,
  _MaintenanceOrder.MaintenanceActivityType AS MaintenanceActivityType,
  _MaintenanceOrder.MaintenancePlannerGroup AS MaintenancePlannerGroup,
  _MaintenanceOrder.MaintenancePlanningPlant AS MaintenancePlanningPlant,
  _MaintenanceOrder.MaintenanceOrderType AS MaintenanceOrderType,
  _MaintenanceOrder.MaintenancePlant AS MaintenancePlant,
  _MaintenanceOrder.MaintObjectLocAcctAssgmtNmbr AS MaintObjectLocAcctAssgmtNmbr,
  _MaintenanceOrder._Order.CreationDate AS CreationDate,
  _MaintenanceOrder.LastChangeDateTime AS LastChangeDateTime,
  _MaintenanceOrder.MaintOrdProcessPhaseCode AS MaintOrdProcessPhaseCode,
  _MaintenanceOrder.MaintOrdProcessSubPhaseCode AS MaintOrdProcessSubPhaseCode,
  _MaintenanceOrder.LatestAcceptableCompletionDate AS LatestAcceptableCompletionDate,
  _MaintenanceOrder.PrevLtstAccptblCompletionDate AS PrevLtstAccptblCompletionDate,
  _MaintenanceOrder.MaintOrderProcessingContext AS MaintOrderProcessingContext,
  MaintenanceOrderOperation,
  MaintenanceOrderSubOperation,
  OperationPersonResponsible,
  OperationControlKey,
  OperationDescription,
  _WorkCenter.WorkCenter AS WorkCenter,
  _WorkCenter.Plant AS WorkCenterPlant,
  _OperationPlanningValues.OperationPlannedWork AS OperationPlannedWork,
  _OperationPlanningValues.OperationPlannedWorkUnit AS OperationPlannedWorkUnit,
  _OperationPlanningValues.ConfirmationTotalQuantity AS ConfirmationTotalQuantity,
  _OperationPlanningValues.OperationQuantity AS OperationQuantity,
  _OperationPlanningValues.OperationQuantityUnit AS OperationQuantityUnit,
  Assembly AS OperationAssembly,
  CostCtrActivityType,
  CostElement,
  MaterialGroup,
  OperationUnloadingPointName,
  PurchaseRequisition,
  MaintOrderConfirmation,
  MaintOrdOperationStatusObject,
  SuperiorOperationInternalID,
  OperationWorkCenterInternalID,
  OperationWorkCenterTypeCode,
  MaintOrdOpProcessPhaseCode,
  MaintOrdOpProcessSubPhaseCode,
  MaintOperationExecStageCode,
  Plant,
  OperationStandardTextCode,
  Language,
  NumberOfTimeTickets,
  OperationPurgInfoRecdSearchTxt,
  OperationSupplier,
  OpExternalProcessingPrice,
  OpExternalProcessingPriceUnit,
  OpExternalProcessingCurrency,
  OperationPurchasingInfoRecord,
  PurchasingOrganization,
  PurchasingGroup,
  OpPurchaseOutlineAgreement,
  OpPurchaseOutlineAgreementItem,
  OperationRequisitionerName,
  OperationTrackingNumber,
  NumberOfCapacities,
  OperationWorkPercent,
  OperationCalculationControl,
  CostCtrActivityType AS ActivityType,
  OperationSystemCondition,
  OperationGoodsRecipientName,
  _OperationPlanningValues.OpPlndDeliveryDurationInDays AS DeliveryTimeInDays,
  _OperationPlanningValues.OperationDuration AS MaintOrderOperationDuration,
  _OperationPlanningValues.OperationDurationUnit AS MaintOrdOperationDurationUnit,
  _OperationPlanningValues.OpErlstSchedldExecStrtDte AS OpErlstSchedldExecStrtDte,
  _OperationPlanningValues.OpErlstSchedldExecStrtTme AS OpErlstSchedldExecStrtTme,
  _OperationPlanningValues.OpErlstSchedldExecEndDte AS OpErlstSchedldExecEndDte,
  _OperationPlanningValues.OpErlstSchedldExecEndTme AS OpErlstSchedldExecEndTme,
  _OperationPlanningValues.OpLtstSchedldExecStrtDte AS OpLtstSchedldExecStrtDte,
  _OperationPlanningValues.OpLtstSchedldExecStrtTme AS OpLtstSchedldExecStrtTme,
  _OperationPlanningValues.OpLtstSchedldExecEndDte AS OpLtstSchedldExecEndDte,
  _OperationPlanningValues.OpLtstSchedldExecEndTme AS OpLtstSchedldExecEndTme,
  _OperationPlanningValues.OpActualExecutionStartDate AS OpActualExecutionStartDate,
  _OperationPlanningValues.OpActualExecutionStartTime AS OpActualExecutionStartTime,
  _OperationPlanningValues.OpActualExecutionEndDate AS OpActualExecutionEndDate,
  _OperationPlanningValues.OpActualExecutionEndTime AS OpActualExecutionEndTime,
  _OperationPlanningValues.ActyConfFcstdEndDate AS ActyConfFcstdEndDate,
  _OperationPlanningValues.ActyConfFcstdEndTime AS ActyConfFcstdEndTime,
  _OperationPlanningValues.OpBscStartDateConstraintType AS OpBscStartDateConstraintType,
  _OperationPlanningValues.OpBscEndDateConstraintType AS OpBscEndDateConstraintType,
  _OperationPlanningValues.OperationPlannedWork AS MaintOrdOperationWorkDuration,
  _OperationPlanningValues.OperationPlannedWorkUnit AS MaintOrdOpWorkDurationUnit,
  _OperationPlanningValues.ConstraintDateForBscStartDate AS ConstraintDateForBscStartDate,
  _OperationPlanningValues.ConstraintTimeForBscStartTime AS ConstraintTimeForBscStartTime,
  _OperationPlanningValues.ConstraintDateForBscFinishDate AS ConstraintDateForBscFinishDate,
  _OperationPlanningValues.ConstraintTimeForBscFinishTime AS ConstraintTimeForBscFinishTime,
  _OperationPlanningValues.MaintOrdOperationExecutionRate AS MaintOrdOperationExecutionRate,
  BusinessArea,
  ProfitCenter,
  CostingSheet,
  TaxJurisdiction,
  FunctionalArea,
  MaintControllingObjectClass,
  WrkCtrIntCapRqmtsDistr,
  MaintOrdOperationOverheadCode,
  _OperationPlanningValues.OperationQuantity AS MaintOrderOperationQuantity,
  _OperationPlanningValues.OperationQuantityUnit AS MaintOrdOperationQuantityUnit,
  MaintOrdOpAssgdWBSElmntInt,
  IsMarkedForDeletion,
  PurchaseRequisitionItem,
  AllMaintOrdCompCmtdQtsAreKept,
  MaintOrderConfCntrValue,
  MaintOrdOpHasNoRemainingWork,
  MaintOrdOpHasLeanServices,
  TaskListType,
  _MaintenanceOrder.ControllingArea AS ControllingArea,
  MaintOrdOpDelivDateAdjustment,
  TaskListGroup,
  TaskListGroupCounter,
  _OperationPlanningValues._PlannedWorkUnitOfMeasure AS _PlannedWorkUnitOfMeasure,
  _OperationPlanningValues._OperationQtyUnitOfMeasure AS _OperationQtyUnitOfMeasure
FROM I_MaintOrderOpAndSubOp_2
LEFT OUTER JOIN I_LogisticsOrder AS _Order ON _Order.OrderID = MaintenanceOrder  -- association [0..1]
LEFT OUTER JOIN I_LocationAccountAssignment AS _LocationAccountAssignment ON MaintObjectLocAcctAssgmtNmbr = _LocationAccountAssignment.MaintObjectLocAcctAssgmtNmbr  -- association [0..1]
LEFT OUTER JOIN I_Equipment AS _Equipment ON Equipment = _Equipment.Equipment  -- association [0..1]
LEFT OUTER JOIN E_MaintenanceOrder AS _MaintenanceOrderExtension ON MaintenanceOrder = _MaintenanceOrderExtension.MaintenanceOrder  -- association [0..1]
;