R_QltyNotificationItemCauseTP

DDL: R_QLTYNOTIFICATIONITEMCAUSETP Type: view_entity TRANSACTIONAL

Quality Notification Item Cause

R_QltyNotificationItemCauseTP is a Transactional CDS View that provides data about "Quality Notification Item Cause" in SAP S/4HANA. It reads from 1 data source (I_QltyNotificationCause) and exposes 21 fields with key fields QualityNotification, NotificationItem, NotificationCauseID. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_QltyNotificationCause I_QltyNotificationCause from

Associations (2)

CardinalityTargetAliasCondition
[1..1] R_QltyNotificationTP _QltyNotification $projection.QualityNotification = _QltyNotification.QualityNotification
[1..1] E_NotificationCause _Extension $projection.QualityNotification = _Extension.Notification and $projection.NotificationItem = _Extension.NotificationItem and $projection.NotificationCauseID = _Extension.NotificationCauseID

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Quality Notification Item Cause 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 NotificationCauseID view
Metadata.ignorePropagatedAnnotations true view

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY QualityNotification I_QltyNotificationCause QualityNotification
KEY NotificationItem I_QltyNotificationCause NotificationItem
KEY NotificationCauseID I_QltyNotificationCause NotificationCauseID
NotificationCauseSortNumber I_QltyNotificationCause NotificationCauseSortNumber
MasterLanguage I_QltyNotificationCause MasterLanguage
NotificationCauseText I_QltyNotificationCause NotificationCauseText
NotificationCauseCodeCatalog I_QltyNotificationCause NotificationCauseCodeCatalog
NotificationCauseCodeGroup I_QltyNotificationCause NotificationCauseCodeGroup
NotificationCauseCode I_QltyNotificationCause NotificationCauseCode
NotificationRootCause I_QltyNotificationCause NotificationRootCause
IsDeleted I_QltyNotificationCause IsDeleted
IsBusinessPurposeCompleted I_QltyNotificationCause IsBusinessPurposeCompleted
CreatedByUser I_QltyNotificationCause CreatedByUser
CreationDate I_QltyNotificationCause CreationDate
CreationTime I_QltyNotificationCause CreationTime
LastChangedByUser I_QltyNotificationCause LastChangedByUser
LastChangeDate I_QltyNotificationCause LastChangeDate
LastChangeTime I_QltyNotificationCause LastChangeTime
_QltyNotification _QltyNotification
_QualityNotificationItem _QualityNotificationItem
_Notification I_QltyNotificationCause _Notification
@AbapCatalog.viewEnhancementCategory: [#PROJECTION_LIST]
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Quality Notification Item Cause'

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

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

@Metadata.ignorePropagatedAnnotations: true

define view entity R_QltyNotificationItemCauseTP
  as select from I_QltyNotificationCause

    association [1..1] to  R_QltyNotificationTP        as _QltyNotification        on  $projection.QualityNotification = _QltyNotification.QualityNotification
    association to parent  R_QualityNotificationItemTP as _QualityNotificationItem on  $projection.QualityNotification = _QualityNotificationItem.QualityNotification
                                                                                   and $projection.NotificationItem    = _QualityNotificationItem.NotificationItem

  //Extension

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

    // Compositions to child nodes

    

{
      @ObjectModel.foreignKey.association: '_QltyNotification'
  key I_QltyNotificationCause.QualityNotification,
      @ObjectModel.foreignKey.association: '_QualityNotificationItem'
  key I_QltyNotificationCause.NotificationItem,
  key I_QltyNotificationCause.NotificationCauseID,
  
      I_QltyNotificationCause.NotificationCauseSortNumber,
      I_QltyNotificationCause.MasterLanguage,

      @Semantics.text: true
      I_QltyNotificationCause.NotificationCauseText,
      
      // Codes

      I_QltyNotificationCause.NotificationCauseCodeCatalog,
      I_QltyNotificationCause.NotificationCauseCodeGroup,
      I_QltyNotificationCause.NotificationCauseCode,
      
      I_QltyNotificationCause.NotificationRootCause,
      
      @Semantics.booleanIndicator: true
      I_QltyNotificationCause.IsDeleted,

      @Semantics.booleanIndicator: true
      I_QltyNotificationCause.IsBusinessPurposeCompleted, // used in the DCL

      
//      I_QltyNotificationCause.ChangedDateTime,

      
      // Admin Data

      @Semantics.user.createdBy: true
      I_QltyNotificationCause.CreatedByUser,
      @Semantics.systemDate.createdAt: true
      I_QltyNotificationCause.CreationDate,
      @Semantics.time: true
      I_QltyNotificationCause.CreationTime,
      @Semantics.user.lastChangedBy: true
      I_QltyNotificationCause.LastChangedByUser,
      @Semantics.systemDate.lastChangedAt: true
      I_QltyNotificationCause.LastChangeDate,
      @Semantics.time: true
      I_QltyNotificationCause.LastChangeTime,
      
      // Associations

      _QltyNotification,
      _QualityNotificationItem,

        // For auth check mapping role

      I_QltyNotificationCause._Notification
// //      I_QltyNotificationCause._NotificationItem


}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_QLTYNOTIFICATIONCAUSE"
],
"ASSOCIATED":
[
"I_QLTYNOTIFICATION",
"R_QLTYNOTIFICATIONTP",
"R_QUALITYNOTIFICATIONITEMTP"
],
"BASE":
[
"I_QLTYNOTIFICATIONCAUSE"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/