I_QltyNotificationTaskLongText

DDL: I_QLTYNOTIFICATIONTASKLONGTEXT SQL: IQTNOTIFTSKLT Type: view BASIC

Quality Notification Task Long Text

I_QltyNotificationTaskLongText is a Basic CDS View that provides data about "Quality Notification Task Long Text" in SAP S/4HANA. It reads from 1 data source (qtaskltext) and exposes 14 fields with key fields QualityNotification, NotificationTask, Language, ItemCounter. It has 3 associations to related views.

1 data source(s) 14 fields

Data Sources (1)

SourceAliasJoin Type
qtaskltext qtaskltext from

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_QltyNotification _QltyNotification $projection.QualityNotification = _QltyNotification.QualityNotification
[1..1] I_QltyNotificationTask _QltyNotificationTask $projection.QualityNotification = _QltyNotificationTask.QualityNotification and $projection.NotificationTask = _QltyNotificationTask.NotificationTask
[1..1] I_Language _Language $projection.Language = _Language.Language

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IQTNOTIFTSKLT view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #CHECK view
ObjectModel.dataCategory #TEXT view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.representativeKey NotificationTask view
EndUserText.label Quality Notification Task Long Text view

Fields (14)

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

@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #CHECK
@ObjectModel: {
    dataCategory: #TEXT,
    usageType: {
        dataClass: #TRANSACTIONAL,
        sizeCategory: #L,
        serviceQuality: #C
    },
    representativeKey: 'NotificationTask'
}
@EndUserText.label: 'Quality Notification Task Long Text'
define view I_QltyNotificationTaskLongText as select from qtaskltext

    association [1..1] to I_QltyNotification        as _QltyNotification        on $projection.QualityNotification = _QltyNotification.QualityNotification  
    association [1..1] to I_QltyNotificationTask    as _QltyNotificationTask    on  $projection.QualityNotification = _QltyNotificationTask.QualityNotification and
                                                                                    $projection.NotificationTask    = _QltyNotificationTask.NotificationTask
    association [1..1] to I_Language                as _Language            on $projection.Language = _Language.Language
{
    @ObjectModel.foreignKey.association: '_QltyNotification'
    key qmnum                                                       as QualityNotification,
    
    @ObjectModel.foreignKey.association: '_QltyNotificationTask'
    key manum                                                       as NotificationTask,   
    
    @ObjectModel.foreignKey.association: '_Language'
    @Semantics.language: true
    key langu                                                       as Language,
    
    key counter                                                     as ItemCounter,
    
    textid                                                          as LongTextID,
    
    @Semantics.text
    content     as QltyNotificationTaskLongText,
    
    created_by  as LongTextCreatedByUser,
    created_at  as LongTextCreatedAt,
    changed_by  as LongTextLastChangedByUser,
    changed_at  as LongTextLastChangedAt,
    mimetype    as MimeType,
    
    /* Association */
    _QltyNotification,
    _QltyNotificationTask,
    _Language
        
} where qtaskltext.qmnum not like '$%'
        and qtaskltext.textid = 'LTQM' --ensures that only items of quality notifications are selected
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"QTASKLTEXT"
],
"ASSOCIATED":
[
"I_LANGUAGE",
"I_QLTYNOTIFICATION",
"I_QLTYNOTIFICATIONTASK"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More