I_MAINTENANCENOTIFICATIONCAUSE
Maintenance Notification Cause
I_MAINTENANCENOTIFICATIONCAUSE is a CDS View in S/4HANA. Maintenance Notification Cause. It contains 16 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_MaintNotifCauseTechObj | view | from | COMPOSITE | Maint. Notification Cause /w Tech. Obj. |
Fields (16)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | MaintenanceNotification | MaintenanceNotification | 1 |
| KEY | MaintenanceNotificationCause | MaintenanceNotificationCause | 1 |
| KEY | MaintenanceNotificationItem | MaintenanceNotificationItem | 1 |
| _IsDeleted | _IsDeleted | 1 | |
| _MaintenanceNotification | _MaintenanceNotification | 1 | |
| _MaintNotifCauseCodeCatalog | _MaintNotifCauseCodeCatalog | 1 | |
| _MaintNotifCauseCodeGroup | _MaintNotifCauseCodeGroup | 1 | |
| _MaintNotificationCauseCode | _MaintNotificationCauseCode | 1 | |
| IsDeleted | IsDeleted | 1 | |
| LastChangeDateTime | LastChangeDateTime | 1 | |
| MaintNotifCauseCodeCatalog | MaintNotifCauseCodeCatalog | 1 | |
| MaintNotifCauseCodeGroup | MaintNotifCauseCodeGroup | 1 | |
| MaintNotifCauseSortNumber | MaintNotifCauseSortNumber | 1 | |
| MaintNotifCauseText | MaintNotifCauseText | 1 | |
| MaintNotificationCauseCode | MaintNotificationCauseCode | 1 | |
| MaintNotificationRootCause | MaintNotificationRootCause | 1 |
@AbapCatalog.sqlViewName: 'IMAINTNOTIFCAUSE'
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #NOT_REQUIRED
--@Analytics: { dataCategory: #DIMENSION }
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Maintenance Notification Cause'
@ObjectModel.representativeKey: 'MaintenanceNotificationCause'
@ObjectModel.semanticKey: ['MaintenanceNotification','MaintenanceNotificationItem','MaintenanceNotificationCause']
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #L
@VDM.viewType: #BASIC
define view I_MaintenanceNotificationCause
as select from qmur
association [1..1] to I_MaintenanceNotification as _MaintenanceNotification on $projection.MaintenanceNotification = _MaintenanceNotification.MaintenanceNotification
association [1..1] to I_MaintenanceNotificationItem as _MaintenanceNotificationItem on _MaintenanceNotificationItem.MaintenanceNotification = $projection.MaintenanceNotification
and _MaintenanceNotificationItem.MaintenanceNotificationItem = $projection.MaintenanceNotificationItem
association [0..1] to I_Indicator as _IsDeleted on $projection.IsDeleted = _IsDeleted.IndicatorValue
// Cause Coding
association [0..1] to I_InspectionCode as _MaintNotificationCauseCode on $projection.MaintNotificationCauseCode = _MaintNotificationCauseCode.InspectionCode
and $projection.MaintNotifCauseCodeCatalog = _MaintNotificationCauseCode.InspectionCatalog
and $projection.MaintNotifCauseCodeGroup = _MaintNotificationCauseCode.InspectionCodeGroup
association [0..1] to I_Inspectioncatalog as _MaintNotifCauseCodeCatalog on $projection.MaintNotifCauseCodeCatalog = _MaintNotifCauseCodeCatalog.InspectionCatalog
association [0..1] to I_InspectionCodeGroup as _MaintNotifCauseCodeGroup on $projection.MaintNotifCauseCodeGroup = _MaintNotifCauseCodeGroup.InspectionCodeGroup
and $projection.MaintNotifCauseCodeCatalog = _MaintNotifCauseCodeGroup.InspectionCatalog
association [0..1] to I_EAMRootCause as _MaintNotificationRootCause on $projection.MaintNotificationRootCause = _MaintNotificationRootCause.MaintNotificationRootCause
{
key qmur.urnum as MaintenanceNotificationCause,
@ObjectModel.foreignKey.association: '_MaintenanceNotification'
key qmur.qmnum as MaintenanceNotification,
@ObjectModel.foreignKey.association: '_MaintenanceNotificationItem'
key qmur.fenum as MaintenanceNotificationItem,
@Semantics.text: true
qmur.urtxt as MaintNotifCauseText,
qmur.qurnum as MaintNotifCauseSortNumber,
@ObjectModel.foreignKey.association: '_MaintNotificationCauseCode'
cast( qmur.urcod as eam_cause_code ) as MaintNotificationCauseCode,
@ObjectModel.foreignKey.association: '_MaintNotifCauseCodeGroup'
cast( qmur.urgrp as eam_cause_code_group ) as MaintNotifCauseCodeGroup,
@ObjectModel.foreignKey.association: '_MaintNotifCauseCodeCatalog'
cast( qmur.urkat as eam_cause_code_catalog ) as MaintNotifCauseCodeCatalog,
@ObjectModel.foreignKey.association: '_IsDeleted'
qmur.kzloesch as IsDeleted,
@ObjectModel.foreignKey.association: '_MaintNotificationRootCause'
qmur.rootcause as MaintNotificationRootCause,
qmur.erdat as CreationDate,
qmur.erzeit as TimeOfCreation,
@Semantics.systemDateTime.lastChangedAt: true
qmur.changeddatetime as LastChangeDateTime,
qmur.aedat as LastChangeDate,
qmur.aezeit as LastChangeTime,
// Associations
_MaintenanceNotification,
_MaintNotifCauseCodeCatalog,
_MaintNotificationCauseCode,
_MaintNotifCauseCodeGroup,
_MaintenanceNotificationItem,
_IsDeleted,
_MaintNotificationRootCause
} where
// Only show PM & CS relevant Causes
_MaintenanceNotification.NotificationOrigin = '01' or // General Maintenance Notification
_MaintenanceNotification.NotificationOrigin = '02' or // Malfunction Report
_MaintenanceNotification.NotificationOrigin = '03' or // Activity Report
_MaintenanceNotification.NotificationOrigin = '04' or // Problem notification
_MaintenanceNotification.NotificationOrigin = '05' or // Activity report (service)
_MaintenanceNotification.NotificationOrigin = '06' // General notification (service)
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_MAINTENANCENOTIFICATION",
"QMUR"
],
"ASSOCIATED":
[
"I_EAMROOTCAUSE",
"I_INDICATOR",
"I_INSPECTIONCATALOG",
"I_INSPECTIONCODE",
"I_INSPECTIONCODEGROUP",
"I_MAINTENANCENOTIFICATION",
"I_MAINTENANCENOTIFICATIONITEM"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/