I_QualityNotificationItem_TP

@AbapCatalog.sqlViewName: 'IQLTYNTFITMTP'
@AbapCatalog.preserveKey: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Quality Notification Item'
@VDM: {
    viewType: #TRANSACTIONAL,
    lifecycle.contract.type: #SAP_INTERNAL_API
}
@AccessControl.authorizationCheck: #CHECK
@ObjectModel: {
    usageType: {
        dataClass: #TRANSACTIONAL,
        sizeCategory: #S, // Relevant is I_NotificationItem, not I_Notification

        serviceQuality: #A },
    representativeKey: 'NotificationItem'
}

define view I_QualityNotificationItem_TP as select from I_QualityNotificationItem   

   association [0..1] to I_Defect_TP           as _ReferencedDefect            on  $projection.ReferencedDefect = _ReferencedDefect.DefectInternalID

{
   
   @ObjectModel: { foreignKey.association: '_Notification' , readOnly: 'EXTERNAL_CALCULATION' }
   key I_QualityNotificationItem.QualityNotification, 
   @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
   key I_QualityNotificationItem.NotificationItem, 
   
       @ObjectModel.readOnly: true
       I_QualityNotificationItem.CreatedByUser,
       @ObjectModel.readOnly: true 
       I_QualityNotificationItem.CreationDate, 
       @ObjectModel.readOnly: true
       I_QualityNotificationItem.LastChangedByUser, 
       @ObjectModel.readOnly: true
       I_QualityNotificationItem.LastChangeDate, 
       @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
       I_QualityNotificationItem.NotificationItemText, 
       @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
       I_QualityNotificationItem.DefectCodeCatalog, 
       @ObjectModel: { readOnly: 'EXTERNAL_CALCULATION' , foreignKey.association: '_DefectCodeGroup' }
       I_QualityNotificationItem.DefectCodeGroup, 
       @ObjectModel: { readOnly: 'EXTERNAL_CALCULATION' , foreignKey.association: '_DefectCode' }
       I_QualityNotificationItem.DefectCode, 
       @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
       I_QualityNotificationItem.NotifItmObjectPartCodeCtlg, 
       @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
       I_QualityNotificationItem.NotifItmObjectPartCodeGroup, 
       @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
       I_QualityNotificationItem.NotifItmObjectPartCode, 
       @ObjectModel.readOnly: true
       I_QualityNotificationItem.CreationTime, 
       @ObjectModel.readOnly: true
       I_QualityNotificationItem.LastChangeTime, 
       @ObjectModel.readOnly: true
       I_QualityNotificationItem.IsDeleted, 
       @ObjectModel: { foreignKey.association: '_ReferencedDefect' , readOnly: true }
       I_QualityNotificationItem.ReferencedDefect,
       @ObjectModel.readOnly: true
       I_QualityNotificationItem.ChangedDateTime,

       /* Associations */
       I_QualityNotificationItem._QltyNotification,
       @VDM.lifecycle: { status: #DEPRECATED, successor: '_QltyNotification' }
       I_QualityNotificationItem._Notification, 
       I_QualityNotificationItem._DefectCode, 
       I_QualityNotificationItem._DefectCodeCatalog, 
       I_QualityNotificationItem._DefectCodeGroup, 
       I_QualityNotificationItem._NotifItmObjectPartCodeCtlg,
       I_QualityNotificationItem._NotifItmObjectPartCodeGroup,
       I_QualityNotificationItem._NotifItmObjectPartCode,
       _ReferencedDefect
}