I_QltyNotificationLongText

DDL: I_QLTYNOTIFICATIONLONGTEXT SQL: IQNOTIFLT Type: view BASIC

Quality Notification Longtext

I_QltyNotificationLongText is a Basic CDS View that provides data about "Quality Notification Longtext" in SAP S/4HANA. It reads from 1 data source (qmelltext) and exposes 12 fields with key fields QualityNotification, ItemCounter, Language. It has 2 associations to related views.

1 data source(s) 12 fields

Data Sources (1)

SourceAliasJoin Type
qmelltext qmelltext from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_QltyNotification _QltyNotification $projection.QualityNotification = _QltyNotification.QualityNotification
[1..1] I_Language _Language $projection.Language = _Language.Language

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName IQNOTIFLT view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #BASIC view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.representativeKey ItemCounter view
ObjectModel.dataCategory #TEXT view
EndUserText.label Quality Notification Longtext view
Metadata.ignorePropagatedAnnotations true view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY QualityNotification qmnum
KEY ItemCounter counter
KEY Language langu
LongTextID textid
QltyNotificationLongText content
LongTextCreatedByUser created_by
LongTextCreatedAt created_at
LongTextLastChangedByUser changed_by
LongTextLastChangedAt changed_at
MimeType mimetype
_QltyNotification _QltyNotification
_Language _Language 
@AbapCatalog.sqlViewName: 'IQNOTIFLT'

@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@VDM.viewType: #BASIC
@ObjectModel:
    { usageType: {
        dataClass: #TRANSACTIONAL,
        sizeCategory: #L,
        serviceQuality: #C
    },
    representativeKey: 'ItemCounter',
    supportedCapabilities: [ #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE ],    
    dataCategory: #TEXT
}
@EndUserText.label: 'Quality Notification Longtext'
@Metadata.ignorePropagatedAnnotations:true
define view I_QltyNotificationLongText
  as select from qmelltext

  association [1..1] to I_QltyNotification as _QltyNotification on $projection.QualityNotification = _QltyNotification.QualityNotification
  association [1..1] to I_Language         as _Language         on $projection.Language = _Language.Language

{
      @ObjectModel.foreignKey.association: '_QltyNotification'
  key qmnum      as QualityNotification,
  key counter    as ItemCounter,

      @ObjectModel.foreignKey.association: '_Language'
      @Semantics.language: true
  key langu      as Language,

      textid     as LongTextID,

      @EndUserText:{  label: 'Detailed Description',
                      quickInfo: 'Detailed Description of Quality Notification'
      }/* normally you should build a vdm_q* data element and cast the field to it to get the label, but casting of STRING is not allowed */
      @Semantics.text: true
      content    as QltyNotificationLongText,

      created_by as LongTextCreatedByUser,
      created_at as LongTextCreatedAt,
      changed_by as LongTextLastChangedByUser,
      changed_at as LongTextLastChangedAt,
      mimetype   as MimeType,

      //    //field necessary for authorization check

      //    @Consumption.hidden: true

      //    _QltyNotification.NotificationType,

      //    @Consumption.hidden: true

      //    _QltyNotification.Plant,

      //    @Consumption.hidden: true

      //    _QltyNotification.IsBusinessPurposeCompleted,


      _QltyNotification,
      _Language

}
where textid = 'LTQM'

Learn More