I_QualityNotificationItem_TP

DDL: I_QUALITYNOTIFICATIONITEM_TP SQL: IQLTYNTFITMTP Type: view TRANSACTIONAL

Quality Notification Item

I_QualityNotificationItem_TP is a Transactional CDS View that provides data about "Quality Notification Item" in SAP S/4HANA. It reads from 1 data source (I_QualityNotificationItem) and exposes 27 fields with key fields QualityNotification, NotificationItem. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_QualityNotificationItem I_QualityNotificationItem from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_Defect_TP _ReferencedDefect $projection.ReferencedDefect = _ReferencedDefect.DefectInternalID

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IQLTYNTFITMTP view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Quality Notification Item view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.representativeKey NotificationItem view

Fields (27)

KeyFieldSource TableSource FieldDescription
KEY QualityNotification I_QualityNotificationItem QualityNotification
KEY NotificationItem I_QualityNotificationItem NotificationItem
CreatedByUser I_QualityNotificationItem CreatedByUser
CreationDate I_QualityNotificationItem CreationDate
LastChangedByUser I_QualityNotificationItem LastChangedByUser
LastChangeDate I_QualityNotificationItem LastChangeDate
NotificationItemText I_QualityNotificationItem NotificationItemText
DefectCodeCatalog I_QualityNotificationItem DefectCodeCatalog
DefectCodeGroup I_QualityNotificationItem DefectCodeGroup
DefectCode I_QualityNotificationItem DefectCode
NotifItmObjectPartCodeCtlg I_QualityNotificationItem NotifItmObjectPartCodeCtlg
NotifItmObjectPartCodeGroup I_QualityNotificationItem NotifItmObjectPartCodeGroup
NotifItmObjectPartCode I_QualityNotificationItem NotifItmObjectPartCode
CreationTime I_QualityNotificationItem CreationTime
LastChangeTime I_QualityNotificationItem LastChangeTime
IsDeleted I_QualityNotificationItem IsDeleted
ReferencedDefect I_QualityNotificationItem ReferencedDefect
ChangedDateTime I_QualityNotificationItem ChangedDateTime
_QltyNotification I_QualityNotificationItem _QltyNotification
_Notification I_QualityNotificationItem _Notification
_DefectCode I_QualityNotificationItem _DefectCode
_DefectCodeCatalog I_QualityNotificationItem _DefectCodeCatalog
_DefectCodeGroup I_QualityNotificationItem _DefectCodeGroup
_NotifItmObjectPartCodeCtlg I_QualityNotificationItem _NotifItmObjectPartCodeCtlg
_NotifItmObjectPartCodeGroup I_QualityNotificationItem _NotifItmObjectPartCodeGroup
_NotifItmObjectPartCode I_QualityNotificationItem _NotifItmObjectPartCode
_ReferencedDefect _ReferencedDefect
@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
}

      

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_QUALITYNOTIFICATIONITEM"
],
"ASSOCIATED":
[
"I_DEFECTCODE",
"I_DEFECTCODEGROUP",
"I_DEFECT_TP",
"I_INSPECTIONCATALOG",
"I_INSPECTIONCODE",
"I_INSPECTIONCODEGROUP",
"I_QLTYNOTIFICATION"
],
"BASE":
[
"I_QUALITYNOTIFICATIONITEM"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/