I_NotifItemAffectedObjLastTask

DDL: I_NOTIFITEMAFFECTEDOBJLASTTASK Type: view_entity COMPOSITE Package: VDM_QM_NOTIFICATION

Last Task for affected object

I_NotifItemAffectedObjLastTask is a Composite CDS View that provides data about "Last Task for affected object" in SAP S/4HANA. It reads from 3 data sources (I_NotificationTask, P_NotifItemAffcdObjLastActnChg, I_NotifItemAffectedObject) and exposes 11 fields with key fields Notification, NotificationItem, DefectAffectedObject, NotificationTask. Part of development package VDM_QM_NOTIFICATION.

3 data source(s) 11 fields

Data Sources (3)

SourceAliasJoin Type
I_NotificationTask _NotificationTask inner
P_NotifItemAffcdObjLastActnChg _NotifItemAffcdObjLastActnChg inner
I_NotifItemAffectedObject I_NotifItemAffectedObject from

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Last Task for affected object view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #B view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY Notification I_NotifItemAffectedObject Notification
KEY NotificationItem I_NotifItemAffectedObject NotificationItem
KEY DefectAffectedObject I_NotifItemAffectedObject DefectAffectedObject
KEY NotificationTask I_NotificationTask NotificationTask
NotificationTaskCatalog I_NotificationTask NotificationTaskCatalog
NotificationTaskCodeGroup I_NotificationTask NotificationTaskCodeGroup
NotificationTaskCode I_NotificationTask NotificationTaskCode
QltyTaskFollowUpAction I_NotificationTask QltyTaskFollowUpAction
QltyTaskFllwUpActionSts I_NotificationTask QltyTaskFllwUpActionSts
ChangedDateTime I_NotificationTask ChangedDateTime
_Notification I_NotifItemAffectedObject _Notification 
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Last Task for affected object'
@VDM: {
    viewType: #COMPOSITE
}
@ObjectModel: {
    usageType: {
        dataClass: #TRANSACTIONAL,
        sizeCategory: #M,
        serviceQuality: #B }
}
define view entity I_NotifItemAffectedObjLastTask as select from I_NotifItemAffectedObject 
  inner join P_NotifItemAffcdObjLastActnChg as _NotifItemAffcdObjLastActnChg 
          on  I_NotifItemAffectedObject.Notification = _NotifItemAffcdObjLastActnChg.Notification
          and I_NotifItemAffectedObject.NotificationItem  = _NotifItemAffcdObjLastActnChg.NotificationItem
          and I_NotifItemAffectedObject.DefectAffectedObject = _NotifItemAffcdObjLastActnChg.DefectAffectedObject
       
  inner join I_NotificationTask as _NotificationTask
          on  I_NotifItemAffectedObject.Notification = _NotificationTask.Notification
          and I_NotifItemAffectedObject.NotificationItem  = _NotificationTask.NotificationItem
          and _NotifItemAffcdObjLastActnChg.LastChangedDateTime = _NotificationTask.ChangedDateTime
{
  key I_NotifItemAffectedObject.Notification,
  key I_NotifItemAffectedObject.NotificationItem,
  key I_NotifItemAffectedObject.DefectAffectedObject,
  key _NotificationTask.NotificationTask,
  _NotificationTask.NotificationTaskCatalog,
  _NotificationTask.NotificationTaskCodeGroup,
  _NotificationTask.NotificationTaskCode,
  _NotificationTask.QltyTaskFollowUpAction,
  _NotificationTask.QltyTaskFllwUpActionSts,
  _NotificationTask.ChangedDateTime,
  //Associations

  I_NotifItemAffectedObject._Notification
}

Learn More