I_MaintenanceItemTechObj

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_MaintenanceItemTechObj.
-- 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: IMAINTITEMTO

CREATE VIEW I_MaintenanceItemTechObj AS
SELECT
  MaintenanceItem,
  Equipment,
  FunctionalLocation,
  cast ( 'EAMS_FL' as eams_tec_obj_type_value ) AS TechObjIsEquipOrFuncnlLoc,
  cast ( FunctionalLocation as eams_tec_obj ) AS TechnicalObject,
  cast ( _FunctionalLocationLabel.FunctionalLocationLabelName as eams_tech_obj_conv ) AS TechnicalObjectLabel,
  cast ( _FunctionalLocationText[1:Language = $session.system_language].FunctionalLocationName as eams_tec_obj_des ) AS TechnicalObjectDescription,
  MaintObjectLocAcctAssgmtNmbr,
  MaintenancePlannerGroup,
  MaintenancePlanningPlant,
  TaskListType,
  TaskListGroup,
  TaskListGroupCounter,
  MaintenanceItemDescription,
  MaintenancePlan,
  MaintenanceItemIsInactive,
  MaintenanceStrategy,
  MaintenancePlanCategory,
  NotificationType,
  MaintenanceNotification,
  MaintPriorityType,
  MaintPriority,
  MaintenanceOrder,
  BusinessArea,
  MainWorkCenterInternalID,
  WorkCenterTypeCode,
  Assembly,
  CreationDate,
  CreatedByUser,
  LastChangeDate,
  LastChangedByUser,
  MaintenancePlanItemPosition,
  MaintenanceActivityType,
  MaintenanceOrderType,
  SerialNumber,
  Material,
  MaintenanceItemObjectList,
  ImmediateReleaseIsBlocked,
  OperationSystemCondition,
  NumberOfTaskListExecutions,
  ObjectInternalID,
  MaintObjectCategory,
  SalesDocument,
  PurchaseOrder,
  PurchaseOrderItem,
  SettlementOrder,
  LastChangeDateTime,
  MaintPlanLastChangeDateTime,
  CycleSetSequence,
  ReferenceElement,
  ServiceDocumentType,
  ServiceContract,
  ServiceContractItem,
  ServiceOrderTemplate,
  Product,
  ServiceDocumentPriority
FROM I_MaintenanceItem
LEFT OUTER JOIN I_TechObjIsEquipOrFuncnlLoc AS _TechObjIsEquipOrFuncnlLoc ON _TechObjIsEquipOrFuncnlLoc.TechObjIsEquipOrFuncnlLoc = TechObjIsEquipOrFuncnlLoc  -- association [0..1]
LEFT OUTER JOIN I_TechnicalObject AS _TechnicalObject ON _TechnicalObject.TechnicalObject = TechnicalObject AND _TechnicalObject.TechObjIsEquipOrFuncnlLoc = TechObjIsEquipOrFuncnlLoc  -- association [0..1]
LEFT OUTER JOIN I_MaintItemObjListTechObj AS _ObjectList ON _ObjectList.MaintenanceItemObjectList = MaintenanceItemObjectList  -- association [0..*]
LEFT OUTER JOIN I_FunctionalLocationLabel AS _FunctionalLocationLabel ON _FunctionalLocationLabel.FunctionalLocation = FunctionalLocation  -- association [0..1]
LEFT OUTER JOIN I_FunctionalLocationText AS _FunctionalLocationText ON _FunctionalLocationText.FunctionalLocation = FunctionalLocation  -- association [0..*]
LEFT OUTER JOIN I_EquipmentText AS _EquipmentText ON _EquipmentText.Equipment = Equipment  -- association [0..*]
-- UNION ALL with additional select branch(es): I_MaintenanceItem
;