I_MaintenanceItem

DDL: I_MAINTENANCEITEM SQL: IMAINTITEM Type: view COMPOSITE

Maintenance Item

I_MaintenanceItem is a Composite CDS View that provides data about "Maintenance Item" in SAP S/4HANA. It reads from 1 data source (I_MaintenanceItemBasic) and exposes 102 fields with key field MaintenanceItem. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_MaintenanceItemBasic I_MaintenanceItemBasic from

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_PMNotificationPriority _PMNotificationPriority $projection.MaintPriorityType = _PMNotificationPriority.MaintPriorityType and $projection.MaintPriority = _PMNotificationPriority.MaintPriority
[0..1] I_PMNotificationPriorityType _PMNotificationPriorityType $projection.MaintPriorityType = _PMNotificationPriorityType.MaintPriorityType -- Extensions, do not expose as association:
[0..1] E_MaintenanceItemBasic _MaintenanceItemExtension $projection.MaintenanceItem = _MaintenanceItemExtension.MaintenanceItem

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IMAINTITEM view
VDM.viewType #COMPOSITE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Maintenance Item view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.modelingPattern #CDS_MODELING_DATA_SOURCE view

Fields (102)

KeyFieldSource TableSource FieldDescription
KEY MaintenanceItem MaintenanceItem
MaintObjectLocAcctAssgmtNmbr MaintObjectLocAcctAssgmtNmbr
MaintObjLocAcctAssgmtIsIndiv MaintObjLocAcctAssgmtIsIndiv
MaintenancePlannerGroup MaintenancePlannerGroup
MaintenancePlanningPlant MaintenancePlanningPlant
BusinessArea BusinessArea
SettlementRuleIsMaintained SettlementRuleIsMaintained
MaintenanceItemHasLongText MaintenanceItemHasLongText
MainWorkCenterInternalID MainWorkCenterInternalID
WorkCenterTypeCode WorkCenterTypeCode
TaskListType TaskListType
TaskListGroup TaskListGroup
TaskListGroupCounter TaskListGroupCounter
Equipment Equipment
FunctionalLocation _LocationAccountAssignment FunctionalLocation
Assembly Assembly
CreationDate CreationDate
CreatedByUser CreatedByUser
LastChangeDate LastChangeDate
LastChangedByUser LastChangedByUser
MaintenanceItemDescription MaintenanceItemDescription
MaintenancePlan MaintenancePlan
MaintenancePlanItemPosition MaintenancePlanItemPosition
MaintenanceStrategy MaintenanceStrategy
MaintenancePlanCategory MaintenancePlanCategory
MaintenancePlanCallObject MaintenancePlanCallObject
MaintItemCausesAreDisplayed MaintItemCausesAreDisplayed
MaintItemReasonsAreDisplayed MaintItemReasonsAreDisplayed
AdditionalDeviceData AdditionalDeviceData
NotificationType NotificationType
MaintenanceNotification MaintenanceNotification
MaintPriorityTypeendasMaintPriorityType
MaintPriority MaintPriority
MaintenanceOrder MaintenanceOrder
MaintenanceActivityType MaintenanceActivityType
MaintenanceOrderType MaintenanceOrderType
SerialNumber SerialNumber
Material Material
MaintenanceItemObjectList MaintenanceItemObjectList
OperationSystemCondition OperationSystemCondition
NumberOfTaskListExecutions NumberOfTaskListExecutions
MaintenanceItemIsInactive MaintenanceItemIsInactive
ObjectInternalID ObjectInternalID
MaintObjectCategory MaintObjectCategory
SalesDocument SalesDocument
PurchaseOrder PurchaseOrder
PurchaseOrderItem PurchaseOrderItem
SettlementOrder SettlementOrder
MaintNotifTskIsAutomlyDtmnd MaintNotifTskIsAutomlyDtmnd
LastChangeDateTime LastChangeDateTime
MaintPlanLastChangeDateTime MaintPlanLastChangeDateTime
ImmediateReleaseIsBlocked ImmediateReleaseIsBlocked
CycleSetSequence CycleSetSequence
ReferenceElement ReferenceElement
ServiceDocumentType ServiceDocumentType
ServiceContract ServiceContract
ServiceContractItem ServiceContractItem
ServiceOrderTemplate ServiceOrderTemplate
Product Product
ServiceDocumentPriority ServiceDocumentPriority
MaintCmplncCalculationMethod MaintCmplncCalculationMethod
MaintCmplncStrtDteOffsetInDays MaintCmplncStrtDteOffsetInDays
MaintCmplncEndDateOffsetInDays MaintCmplncEndDateOffsetInDays
_LocationAccountAssignment _LocationAccountAssignment
_MaintenancePlannerGroup _MaintenancePlannerGroup
_MaintenancePlanningPlant _MaintenancePlanningPlant
_MaintenancePlan _MaintenancePlan
_MaintenancePlanCatParam _MaintenancePlanCatParam
_MaintenanceStrategy _MaintenanceStrategy
_PMNotificationPriority _PMNotificationPriority
_PMNotificationPriorityType _PMNotificationPriorityType
_Equipment _Equipment
_FunctionalLocation _LocationAccountAssignment _FunctionalLocation
_MaintenanceNotification _MaintenanceNotification
_MaintenanceOrder _MaintenanceOrder
_MaintenanceTaskList _MaintenanceTaskList
_TaskListType _TaskListType
_TaskListGroup _TaskListGroup
_TaskListGroup_2 _TaskListGroup_2
_TaskListGroupCounter _TaskListGroupCounter
_TaskListGroupCounter_2 _TaskListGroupCounter_2
_MaintenanceActivityType _MaintenanceActivityType
_MaintenanceOrderType _MaintenanceOrderType
_MainWorkCenter _MainWorkCenter
_WorkCenterType _WorkCenterType
_Assembly _Assembly
_PMNotificationType _PMNotificationType
_Material _Material
_SalesDocument _SalesDocument
_PurchaseOrder _PurchaseOrder
_PurchaseOrderItem _PurchaseOrderItem
_SettlementOrder _SettlementOrder
_MaintOperationSystCondition _MaintOperationSystCondition
_MaintenanceItemObject _MaintenanceItemObject
_PMReferenceElement _PMReferenceElement
_MaintOrderTypeControlParam _MaintOrderTypeControlParam
_BusinessArea _BusinessArea
_ImmediateReleaseIsBlocked _ImmediateReleaseIsBlocked
_ServiceDocumentType _ServiceDocumentType
_Product _Product
_ServiceContract _ServiceContract
_ServiceContractItem _ServiceContractItem
@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":""
}
}*/