I_MaintenanceNotificationCause

@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)