C_ProbSolvingProcStepQltyTask

DDL: C_PROBSOLVINGPROCSTEPQLTYTASK Type: view_entity CONSUMPTION Package: ODATA_QM_PROBSOLVINGPROC

Quality Tasks of a Problem-Solving Process Step

C_ProbSolvingProcStepQltyTask is a Consumption CDS View that provides data about "Quality Tasks of a Problem-Solving Process Step" in SAP S/4HANA. It reads from 1 data source (I_QualityTaskTP) and exposes 37 fields with key field QualityTaskInternalId. It has 4 associations to related views. Part of development package ODATA_QM_PROBSOLVINGPROC.

Data Sources (1)

SourceAliasJoin Type
I_QualityTaskTP I_QualityTaskTP from

Associations (4)

CardinalityTargetAliasCondition
[0..1] I_QualityTaskLongText _QualityTaskDetailedDesc $projection.QualityTaskInternalId = _QualityTaskDetailedDesc.QualityTaskInternalId and $projection.MasterLanguage = _QualityTaskDetailedDesc.Language and _QualityTaskDetailedDesc.LongTextInternalNumber = 2 and _QualityTaskDetailedDesc.LongTextID = 'LTXT'
[0..1] C_ProbSolvingProcExect _ProbSolvingProc $projection.ProbSolvingProc = _ProbSolvingProc.ProbSolvingProc
[0..1] C_ProbSolvingProcStepExect _ProbSolvingProcStep $projection.ProbSolvingProc = _ProbSolvingProcStep.ProbSolvingProc and $projection.ProbSolvingProcStp = _ProbSolvingProcStep.ProbSolvingProcStp
[0..1] C_ProbSolvingProcCause _ProbSolvingProcCause $projection.ProbSolvingProc = _ProbSolvingProcCause.ProbSolvingProc and $projection.ProbSolvingProcCause = _ProbSolvingProcCause.ProbSolvingProcCause

Annotations (15)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Quality Tasks of a Problem-Solving Process Step view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.representativeKey QualityTaskInternalId view
ObjectModel.compositionRoot false view
ObjectModel.transactionalProcessingDelegated true view
ObjectModel.draftEnabled false view
ObjectModel.createEnabled false view
ObjectModel.updateEnabled false view
ObjectModel.deleteEnabled false view
Analytics.technicalName CPRSOLPROCQTSK view
Metadata.allowExtensions true view

Fields (37)

KeyFieldSource TableSource FieldDescription
KEY QualityTaskInternalId QualityTaskInternalId
QualityTask QualityTask
QualityTaskOrigin QualityTaskOrigin
MasterLanguage MasterLanguage
QualityTaskText QualityTaskText
QualityTaskCode QualityTaskCode
QualityTaskCodeGroup QualityTaskCodeGroup
QualityTaskLifecycleStatus QualityTaskLifecycleStatus
QualityTaskProcessor QualityTaskProcessor
NotifTaskTimeZone NotifTaskTimeZone
NotifTaskPlannedEndDate NotifTaskPlannedEndDate
NotifTaskPlannedEndTime NotifTaskPlannedEndTime
NotifTaskCompletionDate NotifTaskCompletionDate
NotifTaskCompletionTime NotifTaskCompletionTime
ProbSolvingProc ProbSolvingProc
ProbSolvingProcStp ProbSolvingProcStp
ProbSolvingProcCause ProbSolvingProcCause
PredecessorQltyTaskIntNumber PredecessorQltyTaskIntNumber
PredecessorQltyTask
PredecessorQltyTaskText
CreatedByUser CreatedByUser
CreationDate CreationDate
CreationTime CreationTime
LastChangedByUser LastChangedByUser
LastChangeDate LastChangeDate
LastChangeTime LastChangeTime
_QualityTaskStatus _QualityTaskStatus
_QltyTskCodeGroup _QltyTskCodeGroup
_QltyTskCode _QltyTskCode
_QualityTaskProcessor _QualityTaskProcessor
_QualityTaskDetailedDesc _QualityTaskDetailedDesc
_ProbSolvingProc _ProbSolvingProc
_ProbSolvingProcStep _ProbSolvingProcStep
_ProbSolvingProcCause _ProbSolvingProcCause
_PredecessorQualityTask _PredecessorQualityTask
_CreatedByUserContactCard _CreatedByUserContactCard
_LastChangedByUserContactCard _LastChangedByUserContactCard
@AccessControl.authorizationCheck: #CHECK

@EndUserText.label: 'Quality Tasks of a Problem-Solving Process Step'
@VDM: {
    viewType: #CONSUMPTION
}
@ObjectModel: {
    usageType: {
        dataClass: #TRANSACTIONAL,
        sizeCategory: #M, 
        serviceQuality: #B },
    representativeKey: 'QualityTaskInternalId',
    semanticKey:  [ 'QualityTask' ],

// Begin Draft 2.0

    compositionRoot: false,
    transactionalProcessingDelegated: true,
    draftEnabled:  false,
    createEnabled: false,
    updateEnabled: false,
    deleteEnabled: false  
}
@Analytics.technicalName: 'CPRSOLPROCQTSK'

@Metadata.allowExtensions: true

define view entity C_ProbSolvingProcStepQltyTask as select from I_QualityTaskTP

    association [0..1] to I_QualityTaskLongText as _QualityTaskDetailedDesc    on  $projection.QualityTaskInternalId = _QualityTaskDetailedDesc.QualityTaskInternalId and
                                                                                   $projection.MasterLanguage = _QualityTaskDetailedDesc.Language and
                                                                                   _QualityTaskDetailedDesc.LongTextInternalNumber = 2 and
                                                                                   _QualityTaskDetailedDesc.LongTextID = 'LTXT'

    association [0..1] to C_ProbSolvingProcExect as _ProbSolvingProc           on $projection.ProbSolvingProc = _ProbSolvingProc.ProbSolvingProc
    association [0..1] to C_ProbSolvingProcStepExect as _ProbSolvingProcStep   on  $projection.ProbSolvingProc = _ProbSolvingProcStep.ProbSolvingProc
                                                                               and $projection.ProbSolvingProcStp = _ProbSolvingProcStep.ProbSolvingProcStp
    association [0..1] to C_ProbSolvingProcCause as _ProbSolvingProcCause      on  $projection.ProbSolvingProc = _ProbSolvingProcCause.ProbSolvingProc
                                                                               and $projection.ProbSolvingProcCause = _ProbSolvingProcCause.ProbSolvingProcCause
                                                                                   
{
    key QualityTaskInternalId,
        QualityTask,
        
        QualityTaskOrigin,
        MasterLanguage,
        
        QualityTaskText,
        QualityTaskCode,
        QualityTaskCodeGroup,
        QualityTaskLifecycleStatus,
        QualityTaskProcessor,
        
        NotifTaskTimeZone,
        NotifTaskPlannedEndDate,
        NotifTaskPlannedEndTime, 
        NotifTaskCompletionDate,
        NotifTaskCompletionTime,     
        
        @ObjectModel.foreignKey.association: '_ProbSolvingProc'
        ProbSolvingProc,
        @ObjectModel.foreignKey.association: '_ProbSolvingProcStep'
        ProbSolvingProcStp,
        @ObjectModel.foreignKey.association: '_ProbSolvingProcCause'
        ProbSolvingProcCause,

        @ObjectModel.foreignKey.association: '_PredecessorQualityTask'
        PredecessorQltyTaskIntNumber,
        @ObjectModel.text.element: [ 'PredecessorQltyTaskText']
        cast( I_QualityTaskTP._PredecessorQualityTask.QualityTask     as vdm_predecessorqltytask     preserving type )  as PredecessorQltyTask,
        @Semantics.text: true
        cast( I_QualityTaskTP._PredecessorQualityTask.QualityTaskText as vdm_predecessorqltytaskdesc preserving type )  as PredecessorQltyTaskText,

        CreatedByUser,
        CreationDate,
        CreationTime,
        LastChangedByUser,
        LastChangeDate,
        LastChangeTime,

        _QualityTaskStatus,
        _QltyTskCodeGroup,
        _QltyTskCode,
        _QualityTaskProcessor,
        _QualityTaskDetailedDesc,
        _ProbSolvingProc,
        _ProbSolvingProcStep,
        _ProbSolvingProcCause,
        _PredecessorQualityTask,
        
        _CreatedByUserContactCard,
        _LastChangedByUserContactCard
} 
where     QualityTaskOrigin = '02'
      and IsDeleted         <> 'X'
      and QualityTaskArchivingStatus is initial