I_NOTIFITEMAFFECTEDOBJECT

CDS View

Object Affected by Notification Item

I_NOTIFITEMAFFECTEDOBJECT is a CDS View in S/4HANA. Object Affected by Notification Item. It contains 4 fields. 1 CDS views read from this table.

Used by 1 CDS view(s) 4 fields

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_NotifItemAffectedObjLastTask view_entity from COMPOSITE Last Task for affected object

Fields (4)

KeyField CDS FieldsUsed in Views
KEY DefectAffectedObject DefectAffectedObject 1
KEY Notification Notification 1
KEY NotificationItem NotificationItem 1
_Notification _Notification 1 
@EndUserText.label: 'Object Affected by Notification Item'
@VDM: {
    viewType: #BASIC,
    lifecycle.contract.type: #PUBLIC_LOCAL_API
}
@AccessControl.authorizationCheck: #CHECK

@ObjectModel: {
    usageType: {
        dataClass: #TRANSACTIONAL,
        sizeCategory: #M,
        serviceQuality: #A },
    representativeKey: 'DefectAffectedObject',
    semanticKey:  [ 'Notification', 'NotificationItem', 'DefectAffectedObject' ]
}
@Analytics.technicalName: 'INTFIAFFCDOBJ'

define view entity I_NotifItemAffectedObject
  as select from qmfe_affctd_obj

  association [1..1] to I_Notification               as _Notification               on  $projection.Notification = _Notification.Notification
  association [1..1] to I_NotificationItem           as _NotificationItem           on  $projection.Notification     = _NotificationItem.Notification
                                                                                    and $projection.NotificationItem = _NotificationItem.NotificationItem

  association [0..1] to I_Product                    as _Product                    on  $projection.Material = _Product.Product
  association [0..1] to I_UnitOfMeasure              as _DefectAffcdObjQuantityUnit on  $projection.DefectAffcdObjQuantityUnit = _DefectAffcdObjQuantityUnit.UnitOfMeasure

{
  key qmnum        as Notification,
  key fenum        as NotificationItem,
  key objcounter   as DefectAffectedObject,

      //    Not decided yet if they are defined as fixed domain values or if there will be a (customizing) table

      objtype      as DefectAffectedObjectType,

      @ObjectModel.foreignKey.association: '_Product'
      material     as Material,

      @Semantics.quantity.unitOfMeasure: 'DefectAffcdObjQuantityUnit'
      quantity     as DefectAffectedObjectQuantity,

      @ObjectModel.foreignKey.association: '_DefectAffcdObjQuantityUnit'
      quantityunit as DefectAffcdObjQuantityUnit,

      batch        as Batch,

      //    Associations

      _Notification,
      _NotificationItem,
      _Product,
      _DefectAffcdObjQuantityUnit

}
where
  qmnum not like '$%'

Learn More