I_MaintenanceObjectListItem

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_MaintenanceObjectListItem.
-- 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: IMTOBJLTITM

CREATE VIEW I_MaintenanceObjectListItem AS
SELECT
  obknr AS MaintenanceObjectList,
  obzae AS MaintenanceObjectListItem,
  objvw AS MaintenanceObjectListUsageCode,
  equnr AS Equipment,
  ihnum AS MaintenanceNotification,
  bautl AS Assembly,
  iloan AS MaintObjectLocAcctAssgmtNmbr,
  matnr AS Material,
  sernr AS SerialNumber,
  uii AS UniqueItemIdentifier,
  datum AS CreationDate,
  sortf AS MaintObjectListItemSequence,
  cast( objk.bearb as xfeld preserving type ) AS MaintObjListEntryIsProcessed,
  product AS ServiceReferenceProduct
FROM objk
LEFT OUTER JOIN I_LocationAccountAssignment AS _LocationAccountAssignment ON _LocationAccountAssignment.MaintObjectLocAcctAssgmtNmbr = MaintObjectLocAcctAssgmtNmbr  -- association [0..1]
LEFT OUTER JOIN I_PMNotifMaintenanceData AS _PMNotifMaintenanceData ON _PMNotifMaintenanceData.MaintenanceNotification = MaintenanceNotification  -- association [0..1]
LEFT OUTER JOIN I_Equipment AS _Equipment ON _Equipment.Equipment = Equipment  -- association [0..1]
LEFT OUTER JOIN I_Equipment AS _SerialNumber ON _SerialNumber.Material = Material AND _SerialNumber.SerialNumber = SerialNumber  -- association [0..1]
LEFT OUTER JOIN I_Equipment AS _UniqueItemIdentifier ON _UniqueItemIdentifier.UniqueItemIdentifier = UniqueItemIdentifier  -- association [0..1]
LEFT OUTER JOIN I_Material AS _Assembly ON _Assembly.Material = Assembly  -- association [0..1]
LEFT OUTER JOIN I_Product AS _Product ON _Product.Product = Material  -- association [0..1]
LEFT OUTER JOIN I_Product AS _ServiceReferenceProduct ON _ServiceReferenceProduct.Product = ServiceReferenceProduct  -- association [0..1]
;