I_NotifItemAffectedObject

DDL: I_NOTIFITEMAFFECTEDOBJECT SQL: INTFIAFFCDOBJ Type: view BASIC

Object Affected by Notification Item

I_NotifItemAffectedObject is a Basic CDS View that provides data about "Object Affected by Notification Item" in SAP S/4HANA. It reads from 1 data source (qmfe_affctd_obj) and exposes 12 fields with key fields Notification, NotificationItem, DefectAffectedObject. It has 4 associations to related views.

1 data source(s) 12 fields

Data Sources (1)

SourceAliasJoin Type
qmfe_affctd_obj qmfe_affctd_obj from

Associations (4)

CardinalityTargetAliasCondition
[1..1] I_Notification _Notification $projection.Notification = _Notification.Notification
[1..1] I_NotificationItem _NotificationItem $projection.Notification = _NotificationItem.Notification and $projection.NotificationItem = _NotificationItem.NotificationItem
[0..1] I_Product _Product $projection.Material = _Product.Product
[0..1] I_UnitOfMeasure _DefectAffcdObjQuantityUnit $projection.DefectAffcdObjQuantityUnit = _DefectAffcdObjQuantityUnit.UnitOfMeasure

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName INTFIAFFCDOBJ view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Object Affected by Notification Item view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.representativeKey DefectAffectedObject view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY Notification qmnum
KEY NotificationItem fenum
KEY DefectAffectedObject objcounter
DefectAffectedObjectType objtype
Material material
DefectAffectedObjectQuantity quantity
DefectAffcdObjQuantityUnit quantityunit
Batch batch
_Notification _Notification
_NotificationItem _NotificationItem
_Product _Product
_DefectAffcdObjQuantityUnit _DefectAffcdObjQuantityUnit 
@AbapCatalog.sqlViewName: 'INTFIAFFCDOBJ'
@AbapCatalog.preserveKey: true
@AbapCatalog.compiler.compareFilter:true

@ClientHandling.algorithm: #SESSION_VARIABLE
@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' ]
}

define view 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,

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

      batch        as Batch,

      //    Associations

      _Notification,
      _NotificationItem,
      _Product,
      _DefectAffcdObjQuantityUnit

}
where
  qmnum not like '$%'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"QMFE_AFFCTD_OBJ"
],
"ASSOCIATED":
[
"I_NOTIFICATION",
"I_NOTIFICATIONITEM",
"I_PRODUCT",
"I_UNITOFMEASURE"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More