I_MAINTITEMOBJECTLISTITEM

CDS View

Maintenance Item Object List Item

I_MAINTITEMOBJECTLISTITEM is a CDS View in S/4HANA. Maintenance Item Object List Item. It contains 7 fields. 2 CDS views read from this table.

Used by 2 CDS view(s) 7 fields

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_TechObjSrvcMaintItmObjList view inner COMPOSITE Tech obj in maint item obj list for srvc
R_MaintItemObjectListItemTP view_entity from TRANSACTIONAL Maintenance Item Object List Item

Fields (7)

KeyField CDS FieldsUsed in Views
_Equipment _Equipment 1
_FunctionalLocation _FunctionalLocation 1
_LocationAccountAssignment _LocationAccountAssignment 1
ControllingArea ControllingArea 1
CostCenter CostCenter 1
Equipment Equipment 1
MaintObjectLocAcctAssgmtNmbr MaintObjectLocAcctAssgmtNmbr 1 
@AbapCatalog.sqlViewName: 'IMTITMOBJLTITM'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Maintenance Item Object List Item'
@VDM.viewType: #COMPOSITE

@ObjectModel: {
   usageType.serviceQuality: #C,
   usageType.sizeCategory: #L,
   usageType.dataClass: #MASTER
}


define view I_MaintItemObjectListItem
  as select from I_MaintenanceItemBasic      as MaintenanceItem
    inner join   I_MaintenanceObjectListItem as MaintenanceItemObjectListItem on MaintenanceItem.MaintenanceItemObjectList = MaintenanceItemObjectListItem.MaintenanceObjectList
  association [0..1] to I_FunctionalLocation as _FunctionalLocation on $projection.FunctionalLocation = _FunctionalLocation.FunctionalLocation
{

  key MaintenanceItem.MaintenanceItem,
  key MaintenanceItemObjectListItem.MaintenanceObjectList                                                                       as MaintenanceItemObjectList,
  key MaintenanceItemObjectListItem.MaintenanceObjectListItem,

      MaintenanceItemObjectListItem.MaintenanceObjectListUsageCode,

      @ObjectModel.foreignKey.association: '_Equipment'
      MaintenanceItemObjectListItem.Equipment,

      @ObjectModel.foreignKey.association: '_FunctionalLocation'
      cast ( MaintenanceItemObjectListItem._LocationAccountAssignment.FunctionalLocation as tplnr_unconverted preserving type ) as FunctionalLocation,

      @ObjectModel.foreignKey.association: '_PMNotifMaintenanceData'
      MaintenanceItemObjectListItem.MaintenanceNotification,

      @ObjectModel.foreignKey.association: '_Assembly'
      MaintenanceItemObjectListItem.Assembly,

      @ObjectModel.foreignKey.association: '_LocationAccountAssignment'
      MaintenanceItemObjectListItem.MaintObjectLocAcctAssgmtNmbr,

      @ObjectModel.foreignKey.association: '_Product'
      MaintenanceItemObjectListItem.Material,

      MaintenanceItemObjectListItem.SerialNumber,

      MaintenanceItemObjectListItem.UniqueItemIdentifier,

      @Semantics.systemDate.createdAt: true
      MaintenanceItemObjectListItem.CreationDate,

      MaintenanceItemObjectListItem.MaintObjectListItemSequence,

      @Semantics.booleanIndicator: true
      MaintenanceItemObjectListItem.MaintObjListEntryIsProcessed,

      MaintenanceItemObjectListItem.ServiceReferenceProduct,

      /* Auth Field */
      MaintenanceItem.MaintenancePlanCallObject,
      MaintenanceItem.MaintenancePlanningPlant,
      MaintenanceItem.MaintenancePlannerGroup,
      MaintenanceItem._LocationAccountAssignment.MaintenancePlant,
      MaintenanceItem._LocationAccountAssignment.CostCenter,
      MaintenanceItem._LocationAccountAssignment.ControllingArea,

      /* Local Associations */
      _FunctionalLocation,

      /* Associations */
      MaintenanceItem._MaintenancePlanningPlant,
      MaintenanceItemObjectListItem._Assembly,
      MaintenanceItemObjectListItem._Equipment,
      MaintenanceItemObjectListItem._Product,
      MaintenanceItemObjectListItem._LocationAccountAssignment,
      MaintenanceItemObjectListItem._PMNotifMaintenanceData,
      MaintenanceItemObjectListItem._SerialNumber,
      MaintenanceItemObjectListItem._UniqueItemIdentifier

}
where
  MaintenanceItemObjectListItem.MaintenanceObjectListUsageCode = 'W'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_LOCATIONACCOUNTASSIGNMENT",
"I_MAINTENANCEITEMBASIC",
"I_MAINTENANCEOBJECTLISTITEM"
],
"ASSOCIATED":
[
"I_EQUIPMENT",
"I_FUNCTIONALLOCATION",
"I_LOCATIONACCOUNTASSIGNMENT",
"I_MATERIAL",
"I_PLANT",
"I_PMNOTIFMAINTENANCEDATA",
"I_PRODUCT"
],
"BASE":
[
"I_MAINTENANCEITEMBASIC",
"I_MAINTENANCEOBJECTLISTITEM"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More