I_MaintenanceOrder

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_MaintenanceOrder.
-- 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_MaintenanceOrder AS
SELECT
  afih.aufnr AS MaintenanceOrder,
  afih.artpr AS MaintPriorityType,
  afih.akknz AS MaintenanceOrderCreationMode,
  afih.priok AS MaintPriority,
  afih.iphas AS MaintenanceProcessingPhase,
  afih.iloan AS MaintObjectLocAcctAssgmtNmbr,
  afih.qmnum AS MaintenanceNotification,
  afih.equnr AS Equipment,
  afih.bautl AS Assembly,
  afih.serialnr AS SerialNumber,
  afih.iwerk AS MaintenancePlanningPlant,
  afih.ingpr AS MaintenancePlannerGroup,
  afih.revnr AS MaintenanceRevision,
  afih.warpl AS MaintenancePlan,
  afih.wapos AS MaintenanceItem,
  cast( afih.ilart as eam_maint_activity_type preserving type ) AS MaintenanceActivityType,
  afih.gewrk AS WorkCenterInternalID,
  afih.pm_objty AS WorkCenterTypeCode,
  afih.addat AS MaintOrderReferenceDate,
  afih.aduhr AS MaintOrderReferenceTime,
  afih.mainworkcompleteddatetime AS MainWorkCompletedDateTime,
  afih.plknz AS MaintenanceOrderPlanningCode,
  afih.anlzu AS OperationSystemCondition,
  afih.adpsp AS ReferenceElement,
  afih.obknr AS MaintenanceItemObjectList,
  cast(afih.obknr as objknr) AS MaintenanceOrderObjectList,
  afih.aning AS PersonnelNumber,
  afih.maintordprocmtintegscenario AS MaintOrdProcmtIntegScenario,
  afih.sermat AS Material,
  afko.aufpl AS MaintOrderRoutingNumber,
  aufk.gsber AS BusinessArea,
  aufk.func_area AS FunctionalArea,
  aufk.auart AS MaintenanceOrderType,
  aufk.autyp AS MaintenanceOrderCategory,
  aufk.ktext AS MaintenanceOrderDesc,
  aufk.kokrs AS ControllingArea,
  aufk.bukrs AS CompanyCode,
  cast(aufk.kostv as pph_kostl preserving type) AS ResponsibleCostCenter,
  aufk.prctr AS ProfitCenter,
  cast(aufk.scope as pph_scope preserving type) AS ControllingObjectClass,
  aufk.idat2 AS TechnicalCompletionDate,
  afko.terkz AS BasicSchedulingType,
  afko.nauterm AS OrdIsNotSchedldAutomatically,
  afko.gstrp AS MaintOrdBasicStartDate,
  afko.gsuzp AS MaintOrdBasicStartTime,
  afko.gltrp AS MaintOrdBasicEndDate,
  afko.gluzp AS MaintOrdBasicEndTime,
  afko.gstrs AS ScheduledBasicStartDate,
  afko.gsuzs AS ScheduledBasicStartTime,
  afko.gltrs AS ScheduledBasicEndDate,
  afko.gluzs AS ScheduledBasicEndTime,
  afko.gstri AS MaintOrderActualStartDate,
  afko.gsuzi AS MaintOrderActualStartTime,
  afko.gltri AS MaintOrderActualFinishDate,
  afko.geuzi AS MaintOrderActualFinishTime,
  afih.maintordpersonresponsible AS MaintOrdPersonResponsible,
  aufk.objnr AS MaintenanceOrderInternalID,
  cast(afko.plnnr as billofoperations preserving type) AS TaskListGroup,
  cast(afko.plnty as billofoperationstype preserving type) AS TaskListType,
  cast(afko.plnal as billofoperationsvariant preserving type) AS TaskListGroupCounter,
  aufk.sowrk AS MaintenancePlant,
  aufk.erdat AS CreationDate,
  aufk.erfzeit AS CreationTime,
  aufk.ernam AS CreatedByUser,
  aufk.aenam AS LastChangeByUser,
  afih.changeddatetime AS LastChangeDateTime,
  afih.deviceid AS AdditionalDeviceData,
  cast( aufk.pspel as vdm_wbs_element_internal preserving type ) AS WBSElementInternalID
FROM afih
LEFT OUTER JOIN I_LogisticsOrder AS _Order ON _Order.OrderID = MaintenanceOrder  -- association [0..1]
LEFT OUTER JOIN I_OrderCategory AS _MaintenanceOrderCategory ON MaintenanceOrderCategory = _MaintenanceOrderCategory.OrderCategory  -- association [1..1]
LEFT OUTER JOIN I_OrderType AS _MaintenanceOrderType ON MaintenanceOrderType = _MaintenanceOrderType.OrderType  -- association [1..1]
LEFT OUTER JOIN I_ControllingArea AS _ControllingArea ON ControllingArea = _ControllingArea.ControllingArea  -- association [0..1]
LEFT OUTER JOIN I_ControllingObjectClass AS _ControllingObjectClass ON ControllingObjectClass = _ControllingObjectClass.ControllingObjectClass  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_CostCenter AS _ResponsibleCostCenter ON ControllingArea = _ResponsibleCostCenter.ControllingArea AND ResponsibleCostCenter = _ResponsibleCostCenter.CostCenter  -- association [0..*]
LEFT OUTER JOIN I_ProfitCenter AS _ProfitCenter ON ControllingArea = _ProfitCenter.ControllingArea AND ProfitCenter = _ProfitCenter.ProfitCenter  -- association [0..*]
LEFT OUTER JOIN I_Plant AS _LocationPlant ON MaintenancePlant = _LocationPlant.Plant  -- association [0..1]
LEFT OUTER JOIN I_SchedulingType AS _BasicSchedulingType ON BasicSchedulingType = _BasicSchedulingType.SchedulingType  -- association [0..1]
LEFT OUTER JOIN I_MaintenanceTaskList AS _MaintenanceTaskList ON TaskListType = _MaintenanceTaskList.TaskListType AND TaskListGroup = _MaintenanceTaskList.TaskListGroup AND TaskListGroupCounter = _MaintenanceTaskList.TaskListGroupCounter with default filter _MaintenanceTaskList.ValidityEndDate = '99991231'  -- association [0..1]
LEFT OUTER JOIN I_OrderItem AS _OrderItem ON MaintenanceOrder = _OrderItem.OrderID AND _OrderItem.OrderItem = '0001'  -- association [0..1]
LEFT OUTER JOIN I_MaintenanceOrderOperation AS _MaintenanceOrderOperation ON MaintOrderRoutingNumber = _MaintenanceOrderOperation.MaintOrderRoutingNumber  -- association [0..*]
LEFT OUTER JOIN I_MaintenanceOrderCost AS _MaintenanceOrderCost ON MaintenanceOrderInternalID = _MaintenanceOrderCost.MaintenanceOrderInternalID  -- association [0..*]
LEFT OUTER JOIN I_MaintenanceOrderComponent_2 AS _MaintenanceOrderComponent ON MaintenanceOrder = _MaintenanceOrderComponent.MaintenanceOrder  -- association [0..*]
LEFT OUTER JOIN I_LocationAccountAssignment AS _LocationAccountAssignment ON MaintObjectLocAcctAssgmtNmbr = _LocationAccountAssignment.MaintObjectLocAcctAssgmtNmbr  -- association [0..1]
LEFT OUTER JOIN I_MaintenanceNotification AS _MaintenanceNotification ON MaintenanceNotification = _MaintenanceNotification.MaintenanceNotification  -- association [0..1]
LEFT OUTER JOIN I_Equipment AS _Equipment ON Equipment = _Equipment.Equipment  -- association [0..1]
LEFT OUTER JOIN I_Material AS _Assembly ON Assembly = _Assembly.Material  -- association [0..1]
LEFT OUTER JOIN I_MaintenancePlanBasic AS _MaintenancePlan ON MaintenancePlan = _MaintenancePlan.MaintenancePlan  -- association [0..1]
LEFT OUTER JOIN I_MaintenanceItem AS _MaintenanceItem ON MaintenanceItem = _MaintenanceItem.MaintenanceItem  -- association [0..1]
LEFT OUTER JOIN I_MaintenanceCall AS _MaintenanceCall ON MaintenancePlan = _MaintenanceCall.MaintenancePlan AND MaintenanceItem = _MaintenanceCall.MaintenanceItem AND MaintenanceCall = _MaintenanceCall.MaintenanceCall  -- association [0..1]
LEFT OUTER JOIN I_MaintenanceOrder AS _LeadingOrder ON LeadingOrder = _LeadingOrder.MaintenanceOrder  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _MaintenancePlanningPlant ON MaintenancePlanningPlant = _MaintenancePlanningPlant.Plant  -- association [0..1]
LEFT OUTER JOIN I_PMNotificationPriorityType AS _MaintenancePriorityType ON MaintPriorityType = _MaintenancePriorityType.MaintPriorityType  -- association [0..1]
LEFT OUTER JOIN I_PMNotificationPriority AS _MaintenancePriority ON MaintPriority = _MaintenancePriority.MaintPriority AND MaintPriorityType = _MaintenancePriority.MaintPriorityType  -- association [0..1]
LEFT OUTER JOIN I_WorkCenter AS _MainWorkCenter ON WorkCenterInternalID = _MainWorkCenter.WorkCenterInternalID AND WorkCenterTypeCode = _MainWorkCenter.WorkCenterTypeCode  -- association [0..1]
LEFT OUTER JOIN I_WorkCenterType AS _WorkCenterType ON WorkCenterTypeCode = _WorkCenterType.WorkCenterTypeCode  -- association [1..1]
LEFT OUTER JOIN I_MaintenanceActivityType AS _MaintenanceActivityType ON MaintenanceActivityType = _MaintenanceActivityType.MaintenanceActivityType  -- association [0..1]
LEFT OUTER JOIN I_PlantMaintenancePartner AS _MaintenancePartner ON MaintenanceOrderInternalID = _MaintenancePartner.MaintObjectInternalID  -- association [0..*]
LEFT OUTER JOIN I_BusinessArea AS _BusinessArea ON BusinessArea = _BusinessArea.BusinessArea  -- association [0..1]
LEFT OUTER JOIN I_FunctionalArea AS _FunctionalArea ON FunctionalArea = _FunctionalArea.FunctionalArea  -- association [0..1]
LEFT OUTER JOIN I_MaintenancePlannerGroup AS _MaintenancePlannerGroup ON MaintenancePlannerGroup = _MaintenancePlannerGroup.MaintenancePlannerGroup AND MaintenancePlanningPlant = _MaintenancePlannerGroup.MaintenancePlanningPlant  -- association [0..1]
LEFT OUTER JOIN I_MaintenanceOrderPhase AS _MaintenanceOrderPhase ON MaintenanceProcessingPhase = _MaintenanceOrderPhase.MaintenanceProcessingPhase  -- association [0..1]
LEFT OUTER JOIN I_StatusObject AS _StatusObject ON MaintenanceOrderInternalID = _StatusObject.StatusObject  -- association [0..1]
LEFT OUTER JOIN I_StatusObjectStatus AS _StatusObjectStatus ON MaintenanceOrderInternalID = _StatusObjectStatus.StatusObject  -- association [1..*]
LEFT OUTER JOIN I_MaintOperationSystCondition AS _OperationSystemCondition ON OperationSystemCondition = _OperationSystemCondition.OperationSystemCondition  -- association [0..1]
LEFT OUTER JOIN I_Indicator AS _OrderHasLongText ON OrderHasLongText = _OrderHasLongText.IndicatorValue  -- association [0..1]
LEFT OUTER JOIN I_MaintOrdPlngDegreeCode AS _MaintOrdPlngDegreeCode ON MaintenanceOrderPlanningCode = _MaintOrdPlngDegreeCode.MaintenanceOrderPlanningCode  -- association [0..1]
LEFT OUTER JOIN I_MaintenanceRevision AS _MaintenanceRevision ON MaintenancePlanningPlant = _MaintenanceRevision.MaintenancePlanningPlant AND MaintenanceRevision = _MaintenanceRevision.MaintenanceRevision  -- association [0..1]
LEFT OUTER JOIN I_MaintOrderTypeControlParam AS _MaintOrderTypeControlParam ON MaintenanceOrderType = _MaintOrderTypeControlParam.OrderType  -- association [0..1]
LEFT OUTER JOIN I_StatusObjectActiveStatus AS _StatusObjectActiveStatus ON MaintenanceOrderInternalID = _StatusObjectActiveStatus.StatusObject  -- association [0..*]
LEFT OUTER JOIN I_User AS _CreatedByUser ON CreatedByUser = _CreatedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_MaintenanceItemObject AS _MaintenanceItemObject ON MaintenanceItemObjectList = _MaintenanceItemObject.MaintenanceItemObjectList  -- association [0..*]
LEFT OUTER JOIN I_MaintenanceOrderObjectList AS _MaintenanceOrderObjectList ON MaintenanceOrderObjectList = _MaintenanceOrderObjectList.MaintenanceOrderObjectList  -- association [0..*]
LEFT OUTER JOIN I_OrderProcessingGroup AS _OrderProcessingGroup ON ControllingArea = _OrderProcessingGroup.ControllingArea AND OrderProcessingGroup = _OrderProcessingGroup.OrderProcessingGroup  -- association [0..1]
LEFT OUTER JOIN I_WBSElementByInternalKey AS _WBSElement ON WBSElementInternalID = _WBSElement.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_ProjectByInternalKey AS _Project ON ProjectInternalID = _Project.ProjectInternalID  -- association [0..1]
LEFT OUTER JOIN I_CostCenterText AS _ResponsibleCostCenterText ON ControllingArea = _ResponsibleCostCenterText.ControllingArea AND ResponsibleCostCenter = _ResponsibleCostCenterText.CostCenter AND _ResponsibleCostCenterText.ValidityStartDate <= $session.system_date AND _ResponsibleCostCenterText.ValidityEndDate >= $session.system_date  -- association [0..*]
LEFT OUTER JOIN I_PMContactCardEmployee AS _PMContactEmployee ON PersonnelNumber = _PMContactEmployee.PersonnelNumber  -- association [0..1]
LEFT OUTER JOIN I_PersonWorkAgreement_1 AS _PersonWorkAgreement ON PersonnelNumber = _PersonWorkAgreement.PersonWorkAgreement  -- association [0..1]
LEFT OUTER JOIN I_MaintOrderHasOpenMainWork AS _MaintOrderHasOpenMainWork ON MaintenanceOrder = _MaintOrderHasOpenMainWork.MaintenanceOrder  -- association [0..1]
LEFT OUTER JOIN E_MaintenanceOrder AS _MaintenanceOrderExtension ON MaintenanceOrder = _MaintenanceOrderExtension.MaintenanceOrder  -- association [0..1]
LEFT OUTER JOIN I_MaintenancePlanPlant AS _MaintenancePlanPlant ON MaintenancePlanningPlant = _MaintenancePlanPlant.MaintenancePlanningPlant  -- association [0..1]
LEFT OUTER JOIN I_EAMProcessPhase AS _EAMProcessPhase ON MaintOrdProcessPhaseCode = _EAMProcessPhase.EAMProcessPhaseCode  -- association [0..1]
LEFT OUTER JOIN I_EAMProcessSubPhase AS _EAMProcessSubPhase ON MaintOrdProcessSubPhaseCode = _EAMProcessSubPhase.EAMProcessSubPhaseCode  -- association [0..1]
LEFT OUTER JOIN I_CtrlgObjectSettlementRule AS _CtrlgObjectSettlementRule ON MaintenanceOrderInternalID = _CtrlgObjectSettlementRule.ControllingObject  -- association [0..1]
LEFT OUTER JOIN I_CostingSheetProcedure AS _CostingSheetProcedure ON ConditionUsage = _CostingSheetProcedure.ConditionUsage AND ConditionApplication = _CostingSheetProcedure.ConditionApplication AND CostingSheet = _CostingSheetProcedure.CostingSheetProcedure  -- association [0..1]
LEFT OUTER JOIN I_InternalOrderOverheadCodeVH AS _OverheadCode ON MaintenanceOrderOverheadCode = _OverheadCode.OverheadCode  -- association [0..1]
LEFT OUTER JOIN I_CostingVariant AS _PlannedCostingVariant ON PlannedCostsCostingVariant = _PlannedCostingVariant.CostingVariant  -- association [1..1]
LEFT OUTER JOIN I_CostingVariant AS _ActualCostingVariant ON ActualCostsCostingVariant = _ActualCostingVariant.CostingVariant  -- association [1..1]
LEFT OUTER JOIN I_BillableControl AS _BillableControl ON AccountingIndicatorCode = _BillableControl.BillableControl  -- association [1..1]
LEFT OUTER JOIN I_WrkPmtMaintOrderRelevance AS _WrkPmtMaintOrderRelevance ON MaintenanceOrderInternalID = _WrkPmtMaintOrderRelevance.MaintenanceOrderInternalID  -- association [0..1]
LEFT OUTER JOIN I_MaintOrderProcessingContext AS _MaintOrderProcessingContext ON MaintOrderProcessingContext = _MaintOrderProcessingContext.MaintOrderProcessingContext  -- association [1..1]
;