I_QLTYNOTIFICATIONTASKLONGTEXT

CDS View

Quality Notification Task Long Text

I_QLTYNOTIFICATIONTASKLONGTEXT is a CDS View in S/4HANA. Quality Notification Task Long Text. It contains 11 fields. 1 CDS views read from this table.

Used by 1 CDS view(s) 11 fields

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_QltyNotifTaskLongTextTP view_entity from TRANSACTIONAL Quality Notification Task Long Text - TP

Fields (11)

KeyField CDS FieldsUsed in Views
KEY ItemCounter LongTextInternalNumber 1
KEY Language Language 1
KEY NotificationTask NotificationTask 1
KEY QualityNotification QualityNotification 1
_Language _Language 1
LongTextCreatedAt LongTextCreatedAt 1
LongTextCreatedByUser LongTextCreatedByUser 1
LongTextID LongTextID 1
LongTextLastChangedAt LongTextLastChangedAt 1
LongTextLastChangedByUser LongTextLastChangedByUser 1
QltyNotificationTaskLongText QltyNotificationTaskLongText 1 
@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

Learn More