I_MAINTENANCEITEM

CDS View

Maintenance Item

I_MAINTENANCEITEM is a CDS View in S/4HANA. Maintenance Item. It contains 14 fields. 15 CDS views read from this table.

CDS Views using this table (15)

ViewTypeJoinVDMDescription
C_TechObjMaintenanceItem view from CONSUMPTION Maintenance Items for Technical Object
C_TechObjMaintenanceItem view union_all CONSUMPTION Maintenance Items for Technical Object
I_MaintenanceItemStdVH view from COMPOSITE Maintenance Item
I_MaintenanceItemTechObj view from COMPOSITE Maintenance Item with Technical Object
I_MaintenanceItemTechObj view union_all COMPOSITE Maintenance Item with Technical Object
I_MaintenanceItemText view from COMPOSITE Maintenance Item Long Text
I_MaintenanceItemTP view from TRANSACTIONAL Maintenance Item (Transactional Processing)
I_TechObjSrvcMaintenanceItem view from COMPOSITE Technical obj in Maint item for service
I_TechObjSrvcMaintenanceItem view union_all COMPOSITE Technical obj in Maint item for service
P_MaintenanceItemSearch view from COMPOSITE
P_RSHMaintAssetBoard view inner CONSUMPTION Maintenance Asset Board
P_RSHMaintAssetBoardShapes view inner CONSUMPTION Maintenance asset board shapes
P_RSHMaintCallOrderProcStatus view inner CONSUMPTION Processing Status for Maint. Call Orders
P_RSHMaintPlanConsumption view inner CONSUMPTION Maintenance Plan Consumption
R_MaintenanceItemTP view_entity from TRANSACTIONAL Maintenance Item

Fields (14)

KeyField CDS FieldsUsed in Views
KEY MaintenanceItem MaintenanceItem 2
KEY MaintenancePlan MaintenancePlan 1
Equipment Equipment 1
MaintenanceActivityType MaintenanceActivityType 1
MaintenanceOrderType OrderType 1
MaintenancePlannerGroup MaintenancePlannerGroup 1
MaintenancePlanningPlant MaintenancePlanningPlant 1
MaintObjectLocAcctAssgmtNmbr MaintObjectLocAcctAssgmtNmbr 1
MaintPriority Priority 1
MaintPriorityType PriorityType 1
ObjectInternalID ObjectInternalID 1
TaskListGroup BillOfOperationsGroup 1
TaskListGroupCounter BillOfOperationsVariant 1
TaskListType BillOfOperationsType 1
@AbapCatalog.sqlViewName: 'IMAINTITEM'
@VDM.viewType: #COMPOSITE
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.privilegedAssociations:['_LocationAccountAssignment']
@EndUserText.label: 'Maintenance Item'

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

@ObjectModel.representativeKey: [ 'MaintenanceItem' ]
@ObjectModel.semanticKey:  [ 'MaintenanceItem']
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.modelingPattern:             #CDS_MODELING_DATA_SOURCE
@ObjectModel.supportedCapabilities:     [ #CDS_MODELING_DATA_SOURCE ]

define view I_MaintenanceItem
  as select from I_MaintenanceItemBasic
  association [0..1] to I_PMNotificationPriority     as _PMNotificationPriority     on  $projection.MaintPriorityType = _PMNotificationPriority.MaintPriorityType
                                                                                    and $projection.MaintPriority     = _PMNotificationPriority.MaintPriority
  association [0..1] to I_PMNotificationPriorityType as _PMNotificationPriorityType on  $projection.MaintPriorityType = _PMNotificationPriorityType.MaintPriorityType

  -- Extensions, do not expose as association:
  association [0..1] to E_MaintenanceItemBasic       as _MaintenanceItemExtension   on  $projection.MaintenanceItem = _MaintenanceItemExtension.MaintenanceItem

{
  key MaintenanceItem,
      MaintObjectLocAcctAssgmtNmbr,
      MaintObjLocAcctAssgmtIsIndiv,
      MaintenancePlannerGroup,
      MaintenancePlanningPlant,
      BusinessArea,
      @Semantics.booleanIndicator
      SettlementRuleIsMaintained,
      MaintenanceItemHasLongText,
      MainWorkCenterInternalID,
      WorkCenterTypeCode,
      TaskListType,
      TaskListGroup,
      TaskListGroupCounter,
      Equipment,
      _LocationAccountAssignment.FunctionalLocation,
      Assembly,
      CreationDate,
      CreatedByUser,
      LastChangeDate,
      LastChangedByUser,
      MaintenanceItemDescription,
      MaintenancePlan,
      MaintenancePlanItemPosition,
      MaintenanceStrategy,
      MaintenancePlanCategory,
      MaintenancePlanCallObject,
      MaintItemCausesAreDisplayed,
      MaintItemReasonsAreDisplayed,
      AdditionalDeviceData,
      NotificationType,
      MaintenanceNotification,
      @ObjectModel.foreignKey.association: '_PMNotificationPriorityType'
      case _MaintenancePlanCatParam.MaintenancePlanCallObject
        when '' then
          _MaintOrderTypeControlParam.MaintPriorityType
        when '2' then
          _PMNotificationType.MaintPriorityType
      end as MaintPriorityType,
      @ObjectModel.foreignKey.association: '_PMNotificationPriority'
      MaintPriority,
      //--[ GENERATED:012:GFBfhxvv7kY4nH9{xKJeWG

      MaintenanceOrder,
      MaintenanceActivityType,
      MaintenanceOrderType,
      SerialNumber,
      Material,
      MaintenanceItemObjectList,
      OperationSystemCondition,
      NumberOfTaskListExecutions,
      MaintenanceItemIsInactive,
      ObjectInternalID,
      MaintObjectCategory,
      SalesDocument,
      PurchaseOrder,
      PurchaseOrderItem,
      SettlementOrder,
      @Semantics.booleanIndicator
      MaintNotifTskIsAutomlyDtmnd,
      @API.element.releaseState: #DEPRECATED
      @API.element.successor: 'MaintPlanLastChangeDateTime'
      LastChangeDateTime,
      MaintPlanLastChangeDateTime,
      ImmediateReleaseIsBlocked,
      CycleSetSequence,
      ReferenceElement,
      ServiceDocumentType,
      ServiceContract,
      ServiceContractItem,
      ServiceOrderTemplate,
      Product,
      ServiceDocumentPriority,
      MaintCmplncCalculationMethod,
      MaintCmplncStrtDteOffsetInDays,
      MaintCmplncEndDateOffsetInDays,

      // Make association public

      _LocationAccountAssignment,
      _MaintenancePlannerGroup,
      _MaintenancePlanningPlant,
      _MaintenancePlan,
      _MaintenancePlanCatParam,
      _MaintenanceStrategy,
      _PMNotificationPriority,
      _PMNotificationPriorityType,
      _Equipment,
      _LocationAccountAssignment._FunctionalLocation,
      _MaintenanceNotification,
      _MaintenanceOrder,
      _MaintenanceTaskList,
      _TaskListType,
      @API.element.releaseState: #DEPRECATED
      @API.element.successor: '_TaskListGroup_2'
      _TaskListGroup,
      _TaskListGroup_2,
      @API.element.releaseState: #DEPRECATED
      @API.element.successor: '_TaskListGroupCounter_2'
      _TaskListGroupCounter,
      _TaskListGroupCounter_2,
      _MaintenanceActivityType,
      _MaintenanceOrderType,
      _MainWorkCenter,
      _WorkCenterType,
      _Assembly,
      _PMNotificationType,
      _Material,
      _SalesDocument,
      _PurchaseOrder,
      _PurchaseOrderItem,
      _SettlementOrder,
      _MaintOperationSystCondition,
      _MaintenanceItemObject,
      _PMReferenceElement,
      _MaintOrderTypeControlParam,
      _BusinessArea,
      _ImmediateReleaseIsBlocked,

      _ServiceDocumentType,
      _Product,
      _ServiceContract,
      _ServiceContractItem

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_LOCATIONACCOUNTASSIGNMENT",
"I_MAINTENANCEITEMBASIC",
"I_MAINTENANCEPLANCATPARAM",
"I_MAINTORDERTYPECONTROLPARAM",
"I_PMNOTIFICATIONTYPE"
],
"ASSOCIATED":
[
"E_MAINTENANCEITEMBASIC",
"I_BILLOFOPERATIONS",
"I_BILLOFOPERATIONSGROUP",
"I_BUSINESSAREA",
"I_EQUIPMENT",
"I_FUNCTIONALLOCATION",
"I_INDICATOR",
"I_LOCATIONACCOUNTASSIGNMENT",
"I_MAINTENANCEACTIVITYTYPE",
"I_MAINTENANCEITEMOBJECT",
"I_MAINTENANCENOTIFICATION",
"I_MAINTENANCEORDER",
"I_MAINTENANCEPLANBASIC",
"I_MAINTENANCEPLANCATPARAM",
"I_MAINTENANCEPLANNERGROUP",
"I_MAINTENANCESTRATEGY",
"I_MAINTENANCETASKLIST",
"I_MAINTENANCETASKLISTGROUP",
"I_MAINTENANCETASKLISTTYPE",
"I_MAINTOPERATIONSYSTCONDITION",
"I_MAINTORDERTYPECONTROLPARAM",
"I_MAINTTASKLISTGROUPCOUNTER",
"I_MATERIAL",
"I_ORDER",
"I_ORDERTYPE",
"I_PLANT",
"I_PMNOTIFICATIONPRIORITY",
"I_PMNOTIFICATIONPRIORITYTYPE",
"I_PMNOTIFICATIONTYPE",
"I_PMREFERENCEELEMENT",
"I_PRODUCT",
"I_PURCHASEORDERAPI01",
"I_PURCHASEORDERITEMAPI01",
"I_SALESDOCUMENT",
"I_SERVICEDOCUMENT",
"I_SERVICEDOCUMENTITEM",
"I_SERVICEDOCUMENTTYPE",
"I_WORKCENTER",
"I_WORKCENTERTYPE"
],
"BASE":
[
"I_LOCATIONACCOUNTASSIGNMENT",
"I_MAINTENANCEITEMBASIC"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/