I_MaintenanceItemObject

DDL: I_MAINTENANCEITEMOBJECT SQL: IMTITMOBJ Type: view BASIC
21 Fields 1 Data Sources 9 Associations

Maintenance Item Object List

I_MaintenanceItemObject is a Basic CDS View that provides data about "Maintenance Item Object List" in SAP S/4HANA. It reads from 1 data source (objk) and exposes 21 fields with key fields MaintenanceItemObjectList, MaintenanceItemObject. It has 9 associations to related views.

Data Sources (1)

SourceAliasJoin Type
objk objk from

Associations (9)

CardinalityTargetAliasCondition
[0..1] I_MaintenanceItem _MaintenanceItem _MaintenanceItem.MaintenanceItemObjectList = $projection.MaintenanceItemObjectList
[0..1] I_LocationAccountAssignment _LocationAccountAssignment _LocationAccountAssignment.MaintObjectLocAcctAssgmtNmbr = $projection.MaintObjectLocAcctAssgmtNmbr
[0..1] I_PMNotifMaintenanceData _PMNotifMaintenanceData _PMNotifMaintenanceData.MaintenanceNotification = $projection.MaintenanceNotification
[0..1] I_MaintenanceNotification _MaintenanceNotification _MaintenanceNotification.MaintenanceNotification = $projection.MaintenanceNotification
[0..1] I_Equipment _Equipment _Equipment.Equipment = $projection.Equipment
[0..1] I_FunctionalLocation _FunctionalLocation _FunctionalLocation.FunctionalLocation = $projection.FunctionalLocation
[0..1] I_Material _Assembly _Assembly.Material = $projection.Assembly
[0..1] I_Material _Material _Material.Material = $projection.Material
[0..1] I_Product _Product $projection.Product = _Product.Product

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName IMTITMOBJ view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Maintenance Item Object List view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
VDM.viewType #BASIC view

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY MaintenanceItemObjectList objk obknr Object list
KEY MaintenanceItemObject objk obzae Object counters
Equipment
FunctionalLocation
Assembly
SerialNumber objk sernr Serial Number
Material objk matnr Vehicle Model
MaintenanceNotification objk ihnum Notification
MaintObjectLocAcctAssgmtNmbr objk iloan Loc/AccAssmt
SortField objk sortf Sort string
CreationDate objk datum Valid to
MaintObjListEntryIsProcessed objk bearb ProcessIndic.
Product objk product Product Sold
_MaintenanceItem _MaintenanceItem
_Assembly _Assembly
_Equipment _Equipment
_FunctionalLocation _FunctionalLocation
_LocationAccountAssignment _LocationAccountAssignment
_MaintenanceNotification _MaintenanceNotification
_Material _Material
_Product _Product

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_MaintenanceItemObject.
-- 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: IMTITMOBJ

CREATE VIEW I_MaintenanceItemObject AS
SELECT
  objk.obknr AS MaintenanceItemObjectList,
  objk.obzae AS MaintenanceItemObject,
  coalesce( _PMNotifMaintenanceData.Equipment, objk.equnr ) AS Equipment,
  coalesce( _LocationAccountAssignment.FunctionalLocation, _PMNotifMaintenanceData._LocationAccountAssignment.FunctionalLocation ) AS FunctionalLocation,
  coalesce( _PMNotifMaintenanceData.Assembly, objk.bautl ) AS Assembly,
  objk.sernr AS SerialNumber,
  objk.matnr AS Material,
  objk.ihnum AS MaintenanceNotification,
  objk.iloan AS MaintObjectLocAcctAssgmtNmbr,
  objk.sortf AS SortField,
  objk.datum AS CreationDate,
  objk.bearb AS MaintObjListEntryIsProcessed,
  objk.product AS Product
FROM objk
LEFT OUTER JOIN I_MaintenanceItem AS _MaintenanceItem ON _MaintenanceItem.MaintenanceItemObjectList = MaintenanceItemObjectList  -- association [0..1]
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_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_FunctionalLocation AS _FunctionalLocation ON _FunctionalLocation.FunctionalLocation = FunctionalLocation  -- association [0..1]
LEFT OUTER JOIN I_Material AS _Assembly ON _Assembly.Material = Assembly  -- association [0..1]
LEFT OUTER JOIN I_Material AS _Material ON _Material.Material = Material  -- association [0..1]
LEFT OUTER JOIN I_Product AS _Product ON Product = _Product.Product  -- association [0..1]
;

Learn More