C_QltyTskProcProcsrNotes

DDL: C_QLTYTSKPROCPROCSRNOTES SQL: CQLTYTSKPROCPN Type: view CONSUMPTION

Quality Task Processor Notes

C_QltyTskProcProcsrNotes 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.

Data Sources (1)

SourceAliasJoin Type
I_QualityTaskLongTextTP I_QualityTaskLongTextTP from

Associations (1)

CardinalityTargetAliasCondition
[1..1] C_QualityTaskProcess _QualityTaskProcess $projection.QualityTaskInternalId = _QualityTaskProcess.QualityTaskInternalId

Annotations (18)

NameValueLevelField
AbapCatalog.sqlViewName CQLTYTSKPROCPN view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
VDM.viewType #CONSUMPTION view
EndUserText.label Quality Task Processor Notes view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.dataCategory #TEXT view
ObjectModel.representativeKey QualityTaskInternalId view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.compositionRoot false view
ObjectModel.transactionalProcessingDelegated true view
ObjectModel.draftEnabled true view
ObjectModel.createEnabled false view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled false 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
_QualityTaskProcess _QualityTaskProcess
@AbapCatalog.sqlViewName: 'CQLTYTSKPROCPN'
@AbapCatalog.compiler.compareFilter: true

@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #NOT_REQUIRED

@VDM.viewType: #CONSUMPTION

@EndUserText.label: 'Quality Task Processor Notes'
@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel: {
    dataCategory: #TEXT,
    representativeKey: 'QualityTaskInternalId',
    usageType: {
        dataClass: #MIXED,
        sizeCategory: #L,
        serviceQuality: #C },
// Begin Draft 2.0

    compositionRoot: false,
    transactionalProcessingDelegated: true,
    draftEnabled:  true,
    createEnabled: false,
    updateEnabled: true,
    deleteEnabled: false    
}

define view C_QltyTskProcProcsrNotes as select from I_QualityTaskLongTextTP 

    association [1..1] to C_QualityTaskProcess as _QualityTaskProcess on $projection.QualityTaskInternalId = _QualityTaskProcess.QualityTaskInternalId

{
//=== Key Fields

        @UI.hidden: true 
        @ObjectModel: { foreignKey.association: '_QualityTaskProcess' }
        key QualityTaskInternalId, 
        @UI.hidden: true 
        key Language, 
        @UI.hidden: true 
        key ItemCounter,
        
//=== Common Fields

        @UI.hidden: true 
        LongTextID, 
        
        @UI.multiLineText: true
        @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,

//=== Administrative Fields        

        @UI.hidden: true 
        LongTextCreatedByUser, 
        @UI.hidden: true 
        LongTextCreatedAt, 
        @UI.hidden: true 
        LongTextLastChangedByUser, 
        @UI.hidden: true        
        LongTextLastChangedAt, 
        
//=== Expose associations

        _Language, 
        @ObjectModel.association.type:  [ #TO_COMPOSITION_PARENT, #TO_COMPOSITION_ROOT ]
        _QualityTaskProcess     
           
}   where ItemCounter = 1 and LongTextID = 'LTPN'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_QUALITYTASKLONGTEXTTP"
],
"ASSOCIATED":
[
"C_QUALITYTASKPROCESS",
"I_LANGUAGE"
],
"BASE":
[
"I_QUALITYTASKLONGTEXTTP"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/