I_MaintenanceOrderDEX

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_MaintenanceOrderDEX.
-- 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 I_MaintenanceOrderDEX AS
SELECT
  MaintenanceOrder,
  MaintOrderRoutingNumber,
  MaintenanceOrderType,
  MaintenanceOrderDesc,
  MaintOrdBasicStartDate,
  MaintOrdBasicStartTime,
  MaintOrdBasicEndDate,
  MaintOrdBasicEndTime,
  ScheduledBasicStartDate,
  ScheduledBasicStartTime,
  ScheduledBasicEndDate,
  ScheduledBasicEndTime,
  MaintOrderReferenceDate,
  MaintOrderReferenceTime,
  MainWorkCompletedDateTime,
  MaintenanceNotification,
  OrdIsNotSchedldAutomatically,
  ControllingArea,
  WorkCenterInternalID AS MainWorkCenterInternalID,
  WorkCenterTypeCode AS MainWorkCenterTypeCode,
  MainWorkCenter,
  MainWorkCenterPlant,
  _LocationAccountAssignment.WorkCenterInternalID AS WorkCenterInternalID,
  _LocationAccountAssignment.WorkCenterTypeCode AS WorkCenterTypeCode,
  _LocationAccountAssignment._WorkCenter.WorkCenter AS WorkCenter,
  MaintenancePlanningPlant,
  MaintenancePlant,
  Assembly,
  MaintOrdProcessPhaseCode,
  MaintOrdProcessSubPhaseCode,
  BusinessArea,
  CompanyCode,
  _LocationAccountAssignment.CostCenter AS CostCenter,
  CostingSheet,
  ReferenceElement,
  FunctionalArea,
  AdditionalDeviceData,
  Equipment,
  _Equipment._EquipmentText[1:Language=$session.system_language].EquipmentName AS EquipmentName,
  cast ( _LocationAccountAssignment.FunctionalLocation as vdm_eam_tplnr ) AS FunctionalLocation,
  MaintenanceOrderPlanningCode,
  MaintenancePlannerGroup,
  MaintenanceActivityType,
  MaintPriority,
  MaintPriorityType,
  OrderProcessingGroup,
  ProfitCenter,
  ResponsibleCostCenter,
  Currency,
  MaintenanceRevision,
  SerialNumber,
  Material AS Product,
  SuperiorProjectNetwork,
  OperationSystemCondition,
  _WBSElement.WBSElementExternalID AS WBSElement,
  WBSElementInternalID,
  cast( ProjectInternalID as ps_s4_proj_pspnr ) AS ProjectInternalID,
  ControllingObjectClass,
  MaintenanceOrderInternalID,
  MaintenanceItemObjectList AS MaintenanceObjectList,
  MaintObjectLocAcctAssgmtNmbr,
  _LocationAccountAssignment.AssetLocation AS AssetLocation,
  _LocationAccountAssignment.AssetRoom AS AssetRoom,
  _LocationAccountAssignment.PlantSection AS PlantSection,
  _LocationAccountAssignment.ABCIndicator AS ABCIndicator,
  _LocationAccountAssignment.MaintObjectFreeDefinedAttrib AS MaintObjectFreeDefinedAttrib,
  BasicSchedulingType,
  LatestAcceptableCompletionDate,
  MaintOrdPersonResponsible,
  LastChangeByUser,
  cast( LastChangeDateTime as rslastchangedat preserving type ) AS LastChangeDateTime,
  CreatedByUser,
  OrderHasLongText,
  MaintenanceOrderOverheadCode,
  PlannedCostsCostingVariant,
  ActualCostsCostingVariant,
  MaintenancePlan,
  MaintenanceCall,
  MaintenanceItem,
  LeadingOrder,
  TaskListType,
  TaskListGroup,
  TaskListGroupCounter,
  _LocationAccountAssignment._WBSElementBasicData.WBSElementExternalID AS LocAcctAssgmtWBSElement,
  cast ( _LocationAccountAssignment.WBSElementInternalID as ps_s4_pspnr preserving type ) AS LocAcctAssgmtWBSElmntIntID,
  _CtrlgObjectSettlementRule.ControllingSettlementProfile AS ControllingSettlementProfile,
  _LocationAccountAssignment.BusinessArea AS LocAcctAssgmtBusinessArea,
  _LocationAccountAssignment.ControllingArea AS LocAcctAssgmtControllingArea,
  _LocationAccountAssignment.CompanyCode AS LocAcctAssgmtCompanyCode,
  MaintOrderProcessingContext
FROM I_MaintenanceOrder AS MaintenanceOrder
LEFT OUTER JOIN I_FunctionalLocationData AS _FunctionalLocation ON FunctionalLocation = _FunctionalLocation.FunctionalLocation  -- association [0..1]
LEFT OUTER JOIN E_MaintenanceOrder AS _MaintenanceOrderExtension ON MaintenanceOrder = _MaintenanceOrderExtension.MaintenanceOrder  -- association [0..1]
;