R_QualityNotificationItemTP

DDL: R_QUALITYNOTIFICATIONITEMTP Type: view_entity TRANSACTIONAL

Quality Notification Item

R_QualityNotificationItemTP 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 39 fields with key fields QualityNotification, NotificationItem. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_QualityNotificationItem I_QualityNotificationItem from

Associations (3)

CardinalityTargetAliasCondition
[1..1] E_NotificationItem _Extension $projection.QualityNotification = _Extension.Notification and $projection.NotificationItem = _Extension.NotificationItem
[0..*] R_QltyNotifItemLongTextTP _QltyNotifItemLongText
[0..*] R_QltyNotificationItemCauseTP _QltyNotificationItemCause

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Quality Notification Item view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.representativeKey NotificationItem view
Metadata.ignorePropagatedAnnotations true view

Fields (39)

KeyFieldSource TableSource FieldDescription
KEY QualityNotification I_QualityNotificationItem QualityNotification
KEY NotificationItem I_QualityNotificationItem NotificationItem
NotificationItemExternalID I_QualityNotificationItem NotificationItemExternalID
NotificationItemText I_QualityNotificationItem NotificationItemText
MasterLanguage
Assembly I_QualityNotificationItem Assembly
DefectClass I_QualityNotificationItem DefectClass
NumberOfDefects I_QualityNotificationItem NumberOfDefects
InspPlanOperationInternalID I_QualityNotificationItem InspPlanOperationInternalID
InspectionCharacteristic I_QualityNotificationItem InspectionCharacteristic
InspectionSubsetInternalID I_QualityNotificationItem InspectionSubsetInternalID
MaterialSample I_QualityNotificationItem MaterialSample
DefectiveSingleUnit I_QualityNotificationItem DefectiveSingleUnit
WorkCenterTypeCode I_QualityNotificationItem WorkCenterTypeCode
MainWorkCenterInternalID I_QualityNotificationItem MainWorkCenterInternalID
MainWorkCenter I_QualityNotificationItem MainWorkCenter
MainWorkCenterPlant I_QualityNotificationItem MainWorkCenterPlant
DefectOrigin I_QualityNotificationItem DefectOrigin
ReferencedDefect I_QualityNotificationItem ReferencedDefect
IsDeleted I_QualityNotificationItem IsDeleted
DefectCodeCatalog I_QualityNotificationItem DefectCodeCatalog
DefectCodeGroup I_QualityNotificationItem DefectCodeGroup
DefectCode I_QualityNotificationItem DefectCode
NotifItmObjectPartCodeCtlg I_QualityNotificationItem NotifItmObjectPartCodeCtlg
NotifItmObjectPartCodeGroup I_QualityNotificationItem NotifItmObjectPartCodeGroup
NotifItmObjectPartCode I_QualityNotificationItem NotifItmObjectPartCode
ExternalDefectiveQuantity I_QualityNotificationItem ExternalDefectiveQuantity
InternalDefectiveQuantity I_QualityNotificationItem InternalDefectiveQuantity
DefectiveQuantityUnit I_QualityNotificationItem DefectiveQuantityUnit
CreatedByUser I_QualityNotificationItem CreatedByUser
CreationDate I_QualityNotificationItem CreationDate
CreationTime I_QualityNotificationItem CreationTime
LastChangedByUser I_QualityNotificationItem LastChangedByUser
LastChangeDate I_QualityNotificationItem LastChangeDate
LastChangeTime I_QualityNotificationItem LastChangeTime
_QltyNotification _QltyNotification
_QltyNotifItemLongText _QltyNotifItemLongText
_QltyNotificationItemCause _QltyNotificationItemCause
_Notification I_QualityNotificationItem _Notification
@AbapCatalog.viewEnhancementCategory: [#PROJECTION_LIST]
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Quality Notification Item'

@VDM: {
  viewType: #TRANSACTIONAL,
  lifecycle.contract.type: #SAP_INTERNAL_API
}

@ObjectModel: {
  usageType: {
    serviceQuality: #C,
    sizeCategory: #L,
    dataClass: #TRANSACTIONAL
  },
  representativeKey: 'NotificationItem'
}

@Metadata.ignorePropagatedAnnotations: true

define view entity R_QualityNotificationItemTP
  as select from I_QualityNotificationItem

    association to parent R_QltyNotificationTP as _QltyNotification on $projection.QualityNotification = _QltyNotification.QualityNotification

    // Compositions to child nodes

    composition [0..*] of R_QltyNotifItemLongTextTP     as _QltyNotifItemLongText
    composition [0..*] of R_QltyNotificationItemCauseTP as _QltyNotificationItemCause

    // Extension

    association [1..1] to E_NotificationItem   as _Extension        on  $projection.QualityNotification = _Extension.Notification
                                                                    and $projection.NotificationItem    = _Extension.NotificationItem

{
      @ObjectModel.foreignKey.association: '_QltyNotification'
  key I_QualityNotificationItem.QualityNotification,
  key I_QualityNotificationItem.NotificationItem,

      I_QualityNotificationItem.NotificationItemExternalID,

      @Semantics.text: true
      I_QualityNotificationItem.NotificationItemText,
      cast( I_QualityNotificationItem.MasterLanguage as vdm_j_masterlanguage ) as MasterLanguage,
//      I_QualityNotificationItem.MasterLanguage,


      I_QualityNotificationItem.Assembly,
      I_QualityNotificationItem.DefectClass,
      I_QualityNotificationItem.NumberOfDefects,
      I_QualityNotificationItem.InspPlanOperationInternalID,
      I_QualityNotificationItem.InspectionCharacteristic,
      I_QualityNotificationItem.InspectionSubsetInternalID,
      I_QualityNotificationItem.MaterialSample,
      I_QualityNotificationItem.DefectiveSingleUnit,
      I_QualityNotificationItem.WorkCenterTypeCode,
      I_QualityNotificationItem.MainWorkCenterInternalID,
      I_QualityNotificationItem.MainWorkCenter,
      I_QualityNotificationItem.MainWorkCenterPlant,
      I_QualityNotificationItem.DefectOrigin,

      I_QualityNotificationItem.ReferencedDefect,

      @Semantics.booleanIndicator: true
      I_QualityNotificationItem.IsDeleted,

      // Codes

      I_QualityNotificationItem.DefectCodeCatalog,
      I_QualityNotificationItem.DefectCodeGroup,
      I_QualityNotificationItem.DefectCode,
      I_QualityNotificationItem.NotifItmObjectPartCodeCtlg,
      I_QualityNotificationItem.NotifItmObjectPartCodeGroup,
      I_QualityNotificationItem.NotifItmObjectPartCode,

      // Quantities

      @Semantics.quantity.unitOfMeasure: 'DefectiveQuantityUnit'
      I_QualityNotificationItem.ExternalDefectiveQuantity,
      @Semantics.quantity.unitOfMeasure: 'DefectiveQuantityUnit'
      I_QualityNotificationItem.InternalDefectiveQuantity,
//      @Semantics.quantity.unitOfMeasure: 'DefectiveQuantityUnit'

//      I_QualityNotificationItem.DefectiveQuantity,   // Only used by Defect application

      I_QualityNotificationItem.DefectiveQuantityUnit, // semantics annotation for UoM not allowed in view entities  



      // Admin Data

      @Semantics.user.createdBy: true
      I_QualityNotificationItem.CreatedByUser,
      @Semantics.systemDate.createdAt: true
      I_QualityNotificationItem.CreationDate,
      @Semantics.time: true
      I_QualityNotificationItem.CreationTime,
      @Semantics.user.lastChangedBy: true
      I_QualityNotificationItem.LastChangedByUser,
      @Semantics.systemDate.lastChangedAt: true
      I_QualityNotificationItem.LastChangeDate,
      @Semantics.time: true
      I_QualityNotificationItem.LastChangeTime,
      // I_QualityNotificationItem.ChangedDateTime,    // Only used by Defect application


      // Associations

      _QltyNotification,
      _QltyNotifItemLongText,
      _QltyNotificationItemCause,
      
      // For auth check mapping role

      I_QualityNotificationItem._Notification
}