I_QltyNotificationStatus

DDL: I_QLTYNOTIFICATIONSTATUS SQL: IQLTYNOTIFSTS Type: view COMPOSITE

Quality Notification Status

I_QltyNotificationStatus is a Composite CDS View that provides data about "Quality Notification Status" in SAP S/4HANA. It reads from 1 data source (I_StatusObjectActiveStatus) and exposes 6 fields with key fields StatusObject, StatusCode.

Data Sources (1)

SourceAliasJoin Type
I_StatusObjectActiveStatus I_StatusObjectActiveStatus from

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName IQLTYNOTIFSTS view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label Quality Notification Status view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
ObjectModel.representativeKey StatusCode view
ObjectModel.compositionRoot true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY StatusObject I_StatusObjectActiveStatus StatusObject
KEY StatusCode I_StatusObjectActiveStatus StatusCode
StatusProfile I_StatusObjectActiveStatus StatusProfile
_StatusObject I_StatusObjectActiveStatus _StatusObject
_StatusProfile I_StatusObjectActiveStatus _StatusProfile
_StatusCode I_StatusObjectActiveStatus _StatusCode
@AbapCatalog.sqlViewName: 'IQLTYNOTIFSTS'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true

// Status data shall be protected and read only in context of the object having this status

@AccessControl.authorizationCheck: #PRIVILEGED_ONLY 
@AccessControl.personalData.blocking: #NOT_REQUIRED
@AccessControl.privilegedAssociations: [ '_StatusObject' ]

@EndUserText.label: 'Quality Notification Status'
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #COMPOSITE

@ObjectModel.representativeKey: 'StatusCode'
@ObjectModel.compositionRoot: true
@ObjectModel.usageType: {
    dataClass: #TRANSACTIONAL,
    sizeCategory: #L,
    serviceQuality: #C
}

define view I_QltyNotificationStatus as select from I_StatusObjectActiveStatus {

//=== Key Fields

  key I_StatusObjectActiveStatus.StatusObject,
  key I_StatusObjectActiveStatus.StatusCode,
  
//=== Common Fields

      I_StatusObjectActiveStatus.StatusProfile,

//=== Expose Associations  

      I_StatusObjectActiveStatus._StatusObject,
      I_StatusObjectActiveStatus._StatusProfile,
      I_StatusObjectActiveStatus._StatusCode

}
where     I_StatusObjectActiveStatus.StatusObject like 'QM%'
      and I_StatusObjectActiveStatus.StatusCode = 'I0161'    //Notification (external)