C_DefectQltyTskProcsrNotes

DDL: C_DEFECTQLTYTSKPROCSRNOTES SQL: CQDEFTSKLT Type: view CONSUMPTION

Quality Task Processor Notes

C_DefectQltyTskProcsrNotes is a Consumption CDS View that provides data about "Quality Task Processor Notes" in SAP S/4HANA. It reads from 1 data source (I_QualityTaskLongTextTP) and exposes 12 fields with key fields QualityTaskInternalId, Language, ItemCounter. It has 1 association to related views.

1 data source(s) 12 fields

Data Sources (1)

SourceAliasJoin Type
I_QualityTaskLongTextTP I_QualityTaskLongTextTP from

Associations (1)

CardinalityTargetAliasCondition
[1..1] C_DefectTaskRecord _DefectTaskRecord $projection.QualityTaskInternalId = _DefectTaskRecord.QualityTaskInternalId

Annotations (16)

NameValueLevelField
AbapCatalog.sqlViewName CQDEFTSKLT view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.dataCategory #TEXT view
ObjectModel.draftEnabled false view
ObjectModel.transactionalProcessingDelegated false view
ObjectModel.createEnabled false view
ObjectModel.updateEnabled false view
ObjectModel.deleteEnabled false view
ObjectModel.representativeKey QualityTaskInternalId view
EndUserText.label Quality Task Processor Notes view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY QualityTaskInternalId QualityTaskInternalId
KEY Language Language
KEY ItemCounter ItemCounter
LongTextID LongTextID
QualityTaskProcessorNotes QualityTaskLongText
QualityTaskProcsrNotesPreview
LongTextCreatedByUser LongTextCreatedByUser
LongTextCreatedAt LongTextCreatedAt
LongTextLastChangedByUser LongTextLastChangedByUser
LongTextLastChangedAt LongTextLastChangedAt
_Language _Language
_DefectTaskRecord _DefectTaskRecord 
@AbapCatalog.sqlViewName: 'CQDEFTSKLT'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #CONSUMPTION

@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L

/* Draft 2.0*/
@ObjectModel:{
    dataCategory: #TEXT,
    draftEnabled: false,
    transactionalProcessingDelegated: false,
    createEnabled: false,
    updateEnabled: false,
    deleteEnabled: false,
    representativeKey: 'QualityTaskInternalId'
} 
@EndUserText.label: 'Quality Task Processor Notes'

@UI.presentationVariant.requestAtLeast: [ 'QualityTaskProcessorNotes', 'LongTextLastChangedAt' ]
define view C_DefectQltyTskProcsrNotes as select from I_QualityTaskLongTextTP 

    association [1..1] to C_DefectTaskRecord as _DefectTaskRecord on $projection.QualityTaskInternalId = _DefectTaskRecord.QualityTaskInternalId


{
        @UI.hidden: true 
        @ObjectModel: { foreignKey.association: '_DefectTaskRecord' }
        key QualityTaskInternalId, 
        @UI.hidden: true 
        key Language, 
        @UI.hidden: true 
        key ItemCounter, 
        @UI.hidden: true 
        LongTextID, 
        
        @EndUserText: { label: 'Processor Notes', quickInfo: 'Processor Notes' }        
        //casting is not possible for source type STRING -> define the label via annotation

        QualityTaskLongText as QualityTaskProcessorNotes,
        

        @ObjectModel: {  
            readOnly: true,
            virtualElement: true,
            virtualElementCalculatedBy: 'ABAP:cl_qm_task_proc_calc_exit'
       }
       cast ( ' ' as vdm_qltytaskprocsrnotespreview ) as QualityTaskProcsrNotesPreview,

        
        @UI.hidden: true 
        LongTextCreatedByUser, 
        @UI.hidden: true 
        LongTextCreatedAt, 
        @UI.hidden: true 
        LongTextLastChangedByUser, 
        @UI.hidden: true        
        LongTextLastChangedAt, 
        
        /* Associations */ 
        _Language, 
        _DefectTaskRecord               
}   where ItemCounter = 1 and LongTextID = 'LTPN'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_QUALITYTASKLONGTEXTTP"
],
"ASSOCIATED":
[
"C_DEFECTTASKRECORD",
"I_LANGUAGE"
],
"BASE":
[
"I_QUALITYTASKLONGTEXTTP"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More