I_MaintOrderOperationData

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_MaintOrderOperationData.
-- 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: IPMORDOPERDATA

CREATE VIEW I_MaintOrderOperationData AS
SELECT
  MaintenanceOrder,
  cast( MaintOrderOperationCounter as operationinternalid preserving type ) AS MaintOrderOperationCounter,
  MaintOrderRoutingNumber,
  _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,
  MaintenanceOrderOperation,
  MaintenanceOrderSubOperation,
  OperationPersonResponsible,
  OperationControlKey,
  OperationDescription,
  _WorkCenter.WorkCenter AS 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,
  cast( case when _StatusObjectActiveStatus[ StatusCode = 'I0013' ].StatusCode is not null then 'X' else ' ' end as eam_is_deleted preserving type ) AS IsDeleted,
  _MaintenanceOrder._Order.CreationDate AS CreationDate,
  _MaintenanceOrder.LastChangeDateTime AS LastChangeDateTime,
  MaintOrderConfirmation,
  MaintOrderOperationInternalID,
  SuperiorOperationInternalID,
  OperationWorkCenterInternalID,
  OperationWorkCenterTypeCode,
  _OperationPlanningValues._PlannedWorkUnitOfMeasure AS _PlannedWorkUnitOfMeasure,
  _OperationPlanningValues._OperationQtyUnitOfMeasure AS _OperationQtyUnitOfMeasure
FROM I_MaintOrderOperAndSubOper
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]
;