I_QualityTaskLongText

DDL: I_QUALITYTASKLONGTEXT SQL: IQTSKLT Type: view BASIC

Quality Task Long Text

I_QualityTaskLongText is a Basic CDS View that provides data about "Quality Task Long Text" in SAP S/4HANA. It reads from 1 data source (qtaskltext) and exposes 12 fields with key fields QualityTaskInternalId, Language, LongTextInternalNumber. It has 2 associations to related views.

1 data source(s) 12 fields

Data Sources (1)

SourceAliasJoin Type
qtaskltext qtaskltext from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_QualityTask _QualityTask $projection.QualityTaskInternalId = _QualityTask.QualityTaskInternalId
[1..1] I_Language _Language $projection.Language = _Language.Language

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName IQTSKLT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
ObjectModel.modelingPattern #NONE view
ObjectModel.dataCategory #TEXT view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.representativeKey LongTextInternalNumber view
EndUserText.label Quality Task Long Text view
Metadata.ignorePropagatedAnnotations true view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY QualityTaskInternalId qmnum
KEY Language langu
KEY LongTextInternalNumber counter
LongTextID textid
QualityTaskLongText content
LongTextCreatedByUser created_by
LongTextCreatedAt
LongTextLastChangedByUser changed_by
LongTextLastChangedAt
MimeType
_QualityTask _QualityTask
_Language _Language 
@AbapCatalog.sqlViewName: 'IQTSKLT'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #MANDATORY
@VDM: { 
  viewType: #BASIC,
  lifecycle.contract.type: #PUBLIC_LOCAL_API
}
@ObjectModel.supportedCapabilities: 
    [ #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE, #CDS_MODELING_ASSOCIATION_TARGET ]
@ObjectModel.modelingPattern: #NONE
@ObjectModel: {
    dataCategory: #TEXT,
    usageType: {
        dataClass: #TRANSACTIONAL,
        sizeCategory: #L,
        serviceQuality: #C
    },
    representativeKey: 'LongTextInternalNumber'
}
@EndUserText.label: 'Quality Task Long Text'
@Metadata.ignorePropagatedAnnotations: true

define view I_QualityTaskLongText as select from qtaskltext 

    association [1..1] to I_QualityTask         as _QualityTask         on $projection.QualityTaskInternalId = _QualityTask.QualityTaskInternalId    
    association [1..1] to I_Language            as _Language            on $projection.Language = _Language.Language
{
    @ObjectModel.foreignKey.association: '_QualityTask'
    key qmnum                                                       as QualityTaskInternalId,   
    
    @ObjectModel.foreignKey.association: '_Language'
    @Semantics.language: true
    key langu                                                       as Language,
    
    key counter                                                     as LongTextInternalNumber,
    
    textid                                                          as LongTextID,
    
    @Semantics.text
    content                                                         as QualityTaskLongText,
    
    created_by                                                      as LongTextCreatedByUser,
    cast( created_at as qlt_longtext_created_at preserving type )   as LongTextCreatedAt,
    changed_by                                                      as LongTextLastChangedByUser,
    cast( changed_at as qlt_longtext_changed_at preserving type )   as LongTextLastChangedAt,
    cast( mimetype as w3conttype )                                  as MimeType,
    
    /* Association */
    _QualityTask,
    _Language
        
} where qtaskltext.qmnum like '$%'
    and qtaskltext.manum = '0000'

Learn More