I_MaintenanceOrderHistory

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_MaintenanceOrderHistory.
-- 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: IMAINTORDERHS

CREATE VIEW I_MaintenanceOrderHistory AS
SELECT
  hiko.aufnr AS MaintenanceOrder,
  hiko.loekz AS IsMarkedForDeletion,
  hiko.erdat AS CreationDate,
  hiko.ernam AS CreatedByUser,
  hiko.aedat AS LastChangeDate,
  hiko.aenam AS LastChangedByUser,
  hiko.waers AS Currency,
  hiko.werks AS Plant,
  hiko.artpr AS MaintPriorityType,
  hiko.priok AS MaintPriority,
  hiko.iphas AS MaintenanceProcessingPhase,
  hiko.iloan AS MaintObjectLocAcctAssgmtNmbr,
  hiko.qmnum AS MaintenanceNotification,
  hiko.lead_aufnr AS LeadingOrder,
  hiko.equnr AS Equipment,
  hiko.wapos AS MaintenanceItem,
  hiko.bautl AS Assembly,
  hiko.serialnr AS SerialNumber,
  hiko.iwerk AS MaintenancePlanningPlant,
  hiko.ingpr AS MaintenancePlannerGroup,
  hiko.revnr AS MaintenanceRevision,
  hiko.warpl AS MaintenancePlan,
  cast( hiko.ilart as eam_maint_activity_type ) AS MaintenanceActivityType,
  hiko.gewrk AS WorkCenterInternalID,
  hiko.pm_objty AS WorkCenterTypeCode,
  hiko.addat AS MaintOrderReferenceDate,
  hiko.plknz AS MaintenanceOrderPlanningCode,
  hiko.pspel AS WBSElementInternalID,
  hiko.anlzu AS OperationSystemCondition,
  hiko.gsber AS BusinessArea,
  hiko.bukrs AS CompanyCode,
  hiko.auart AS MaintenanceOrderType,
  cast(hiko.autyp as pph_autyp) AS MaintenanceOrderCategory,
  cast(hiko.ktext as pph_auftext) AS MaintenanceOrderDesc,
  hiko.gstrp AS MaintOrdBasicStartDate,
  hiko.gltrp AS MaintOrdBasicEndDate,
  hiko.gstri AS ActualStartDate,
  hiko.getri AS ConfirmedEndDate,
  hiko.objnr AS MaintenanceOrderInternalID,
  cast(hiko.plnty as billofoperationstype) AS BillOfOperationsType,
  cast(hiko.plnnr as billofoperations) AS BillOfOperations,
  cast(hiko.plnal as billofoperationsvariant) AS BillOfOperationsVariant,
  hiko.zaehl AS BOOInternalVersionCounter,
  hiko.kokrs AS ControllingArea
FROM hiko
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_User AS _CreatedByUser ON CreatedByUser = _CreatedByUser.UserID  -- association [1..1]
LEFT OUTER JOIN I_OrderItem AS _OrderItem ON MaintenanceOrder = _OrderItem.OrderID  -- association [0..*]
LEFT OUTER JOIN I_User AS _LastChangedByUser ON LastChangedByUser = _LastChangedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _Currency ON Currency = _Currency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [1..1]
LEFT OUTER JOIN I_WBSElementByInternalKey AS _WBSElement ON WBSElementInternalID = _WBSElement.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_BillOfOperationsType AS _BillOfOperationsType ON BillOfOperationsType = _BillOfOperationsType.BillOfOperationsType  -- association [0..1]
LEFT OUTER JOIN I_BillOfOperationsGroup AS _BillOfOperationsGroup ON BillOfOperationsType = _BillOfOperationsGroup.BillOfOperationsType AND BillOfOperations = _BillOfOperationsGroup.BillOfOperationsGroup  -- association [0..1]
LEFT OUTER JOIN I_BillOfOperations AS _BillOfOperations ON BillOfOperationsType = _BillOfOperations.BillOfOperationsType AND BillOfOperations = _BillOfOperations.BillOfOperationsGroup AND BillOfOperationsVariant = _BillOfOperations.BillOfOperationsVariant  -- association [0..1]
LEFT OUTER JOIN I_BillOfOperationsChangeState AS _BillOfOperationsChangeState ON BillOfOperationsType = _BillOfOperationsChangeState.BillOfOperationsType AND BillOfOperations = _BillOfOperationsChangeState.BillOfOperationsGroup AND BillOfOperationsVariant = _BillOfOperationsChangeState.BillOfOperationsVariant AND BOOInternalVersionCounter = _BillOfOperationsChangeState.BOOInternalVersionCounter  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_ControllingArea AS _ControllingArea ON ControllingArea = _ControllingArea.ControllingArea  -- association [0..1]
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_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_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_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_MaintenanceItem AS _MaintenanceItem ON MaintenanceItem = _MaintenanceItem.MaintenanceItem  -- association [0..1]
LEFT OUTER JOIN I_MaintenancePlanPlant AS _MaintenancePlanPlant ON MaintenancePlanningPlant = _MaintenancePlanPlant.MaintenancePlanningPlant  -- association [0..1]
;