I_MAINTENANCEITEM
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)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| 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)
| Key | Field | CDS Fields | Used 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":""
}
}*/