I_MaintOrderHistTechObj

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_MaintOrderHistTechObj.
-- 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: IMNTORDHISTECOBJ

CREATE VIEW I_MaintOrderHistTechObj AS
SELECT
  I_MaintenanceOrderHistory.MaintenanceOrder AS MaintenanceOrder,
  I_MaintenanceOrderHistory.CreatedByUser AS CreatedByUser,
  I_MaintenanceOrderHistory.CreationDate AS CreationDate,
  I_MaintenanceOrderHistory.LastChangedByUser AS LastChangedByUser,
  I_MaintenanceOrderHistory.LastChangeDate AS LastChangeDate,
  I_MaintenanceOrderHistory.IsMarkedForDeletion AS IsMarkedForDeletion,
  I_MaintenanceOrderHistory.MaintPriorityType AS MaintPriorityType,
  I_MaintenanceOrderHistory.MaintPriority AS MaintPriority,
  I_MaintenanceOrderHistory.MaintenanceProcessingPhase AS MaintenanceProcessingPhase,
  I_MaintenanceOrderHistory.MaintObjectLocAcctAssgmtNmbr AS MaintObjectLocAcctAssgmtNmbr,
  I_MaintenanceOrderHistory.MaintenanceNotification AS MaintenanceNotification,
  I_MaintenanceOrderHistory.LeadingOrder AS LeadingOrder,
  I_MaintenanceOrderHistory.Equipment AS Equipment,
  I_MaintenanceOrderHistory.MaintenanceItem AS MaintenanceItem,
  I_MaintenanceOrderHistory.Assembly AS Assembly,
  I_MaintenanceOrderHistory.SerialNumber AS SerialNumber,
  I_MaintenanceOrderHistory.MaintenancePlanningPlant AS MaintenancePlanningPlant,
  I_MaintenanceOrderHistory.MaintenancePlannerGroup AS MaintenancePlannerGroup,
  I_MaintenanceOrderHistory.MaintenanceRevision AS MaintenanceRevision,
  I_MaintenanceOrderHistory.MaintenancePlan AS MaintenancePlan,
  I_MaintenanceOrderHistory.MaintenanceOrderType AS MaintenanceOrderType,
  I_MaintenanceOrderHistory.MaintenanceOrderCategory AS MaintenanceOrderCategory,
  I_MaintenanceOrderHistory.MaintenanceOrderDesc AS MaintenanceOrderDesc,
  I_MaintenanceOrderHistory.MaintOrdBasicStartDate AS MaintOrdBasicStartDate,
  I_MaintenanceOrderHistory.MaintOrdBasicEndDate AS MaintOrdBasicEndDate,
  I_MaintenanceOrderHistory.ActualStartDate AS ActualStartDate,
  I_MaintenanceOrderHistory.ConfirmedEndDate AS ConfirmedEndDate,
  I_MaintenanceOrderHistory.MaintenanceOrderInternalID AS MaintenanceOrderInternalID,
  I_MaintenanceOrderHistory.BillOfOperationsType AS BillOfOperationsType,
  I_MaintenanceOrderHistory.BillOfOperations AS BillOfOperations,
  I_MaintenanceOrderHistory.BillOfOperationsVariant AS BillOfOperationsVariant,
  I_MaintenanceOrderHistory.WorkCenterInternalID AS WorkCenterInternalID,
  I_MaintenanceOrderHistory.WorkCenterTypeCode AS WorkCenterTypeCode,
  I_MaintenanceOrderHistory.Plant AS Plant,
  I_MaintenanceOrderHistory._MainWorkCenter.WorkCenter AS MaintOrdMainWorkCenter,
  I_MaintenanceOrderHistory._MainWorkCenter.Plant AS MaintOrdMainWorkCenterPlant,
  I_MaintenanceOrderHistory.BusinessArea AS BusinessArea,
  _MaintenancePartner[1: PartnerFunction = 'VW'].Partner AS MaintOrdPersonResponsible,
  I_MaintenanceOrderHistory.MaintOrderReferenceDate AS MaintOrderReferenceDate,
  I_MaintenanceOrderHistory.MaintenanceOrderPlanningCode AS MaintenanceOrderPlanningCode,
  I_MaintenanceOrderHistory.OperationSystemCondition AS OperationSystemCondition,
  I_MaintenanceOrderHistory.MaintenanceActivityType AS MaintenanceActivityType,
  I_MaintenanceOrderHistory.ControllingArea AS ControllingArea,
  I_MaintenanceOrderHistory.AuthorizationGroup AS AuthorizationGroup,
  I_MaintenanceOrderHistory.MaintenancePlant AS MaintenancePlant,
  I_MaintenanceOrderHistory._Equipment AS _Equipment,
  I_MaintenanceOrderHistory._LocationAccountAssignment AS _LocationAccountAssignment,
  I_MaintenanceOrderHistory._MaintenanceNotification AS _MaintenanceNotification,
  I_MaintenanceOrderHistory._MaintenanceOrderCategory AS _MaintenanceOrderCategory,
  I_MaintenanceOrderHistory._MaintenanceOrderType AS _MaintenanceOrderType,
  I_MaintenanceOrderHistory._MaintenanceOrderComponent AS _MaintenanceOrderComponent,
  I_MaintenanceOrderHistory._MaintenanceOrderPhase AS _MaintenanceOrderPhase,
  I_MaintenanceOrderHistory._MaintenancePlan AS _MaintenancePlan,
  I_MaintenanceOrderHistory._MaintenancePriority AS _MaintenancePriority,
  I_MaintenanceOrderHistory._MaintenancePriorityType AS _MaintenancePriorityType,
  I_MaintenanceOrderHistory._StatusObject AS _StatusObject,
  I_MaintenanceOrderHistory._BusinessArea AS _BusinessArea,
  I_MaintenanceOrderHistory._StatusObjectStatus AS _StatusObjectStatus,
  I_MaintenanceOrderHistory._MaintenancePlannerGroup AS _MaintenancePlannerGroup,
  I_MaintenanceOrderHistory._MaintenancePlanningPlant AS _MaintenancePlanningPlant,
  I_MaintenanceOrderHistory._MaintenanceActivityType AS _MaintenanceActivityType,
  I_MaintenanceOrderHistory._Assembly AS _Assembly,
  I_MaintenanceOrderHistory._OperationSystemCondition AS _OperationSystemCondition,
  I_MaintenanceOrderHistory._MaintenanceItem AS _MaintenanceItem
FROM I_MaintenanceOrderHistory
LEFT OUTER JOIN I_MaintOrderOperTechObj AS _MaintenanceOrderOperation ON MaintenanceOrder = _MaintenanceOrderOperation.MaintenanceOrder  -- association [0..*]
LEFT OUTER JOIN I_TechnicalObject AS _TechnicalObject ON _TechnicalObject.TechnicalObject = TechnicalObject AND _TechnicalObject.TechObjIsEquipOrFuncnlLoc = TechObjIsEquipOrFuncnlLoc  -- association [0..1]
LEFT OUTER JOIN I_TechObjIsEquipOrFuncnlLoc AS _TechObjIsEquipOrFuncnlLoc ON _TechObjIsEquipOrFuncnlLoc.TechObjIsEquipOrFuncnlLoc = TechObjIsEquipOrFuncnlLoc  -- association [0..1]
;