P_DefectAffcdObjActnParam

DDL: P_DEFECTAFFCDOBJACTNPARAM SQL: PDEFAOACTNPARAM Type: view COMPOSITE Package: VDM_QM_NOTIFICATION

Relation Quality Task to Affected Object

P_DefectAffcdObjActnParam is a Composite CDS View that provides data about "Relation Quality Task to Affected Object" in SAP S/4HANA. It reads from 2 data sources (I_QltyTaskFllwUpActionParam, I_QualityTask) and exposes 9 fields with key fields DefectInternalID, DefectAffectedObject. Part of development package VDM_QM_NOTIFICATION.

2 data source(s) 9 fields

Data Sources (2)

SourceAliasJoin Type
I_QltyTaskFllwUpActionParam I_QltyTaskFllwUpActionParam from
I_QualityTask I_QualityTask inner

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PDEFAOACTNPARAM view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
VDM.private true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.representativeKey DefectAffectedObject view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY DefectInternalID I_QualityTask DefectInternalID
KEY DefectAffectedObject I_QltyTaskFllwUpActionParam DefectAffectedObject
QualityTaskInternalId I_QualityTask QualityTaskInternalId
QualityTask I_QualityTask QualityTask
ChangedDateTime I_QualityTask ChangedDateTime
QltyTaskFollowUpAction I_QualityTask QltyTaskFollowUpAction
QltyTaskFllwUpActionSts I_QualityTask QltyTaskFllwUpActionSts
_QltyTaskFollowUpAction _QltyTaskFollowUpAction
_QltyTaskFllwUpActionSts _QltyTaskFllwUpActionSts 
@AbapCatalog.sqlViewName: 'PDEFAOACTNPARAM'
@AbapCatalog.preserveKey: true
@AbapCatalog.compiler.compareFilter:true

@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM: {
    viewType: #COMPOSITE,
    private: true
}
@AccessControl.authorizationCheck: #NOT_REQUIRED

@ObjectModel: {
    usageType: {
        dataClass: #TRANSACTIONAL,
        sizeCategory: #M,
        serviceQuality: #A },
    representativeKey: 'DefectAffectedObject'
}

define view P_DefectAffcdObjActnParam 
//  as select from P_QltyTaskActionFllwUpParam

  as select from I_QltyTaskFllwUpActionParam
     inner join I_QualityTask
//        on P_QltyTaskActionFllwUpParam.QualityTaskInternalId = I_QualityTask.QualityTaskInternalId

        on I_QltyTaskFllwUpActionParam.QualityTaskInternalId = I_QualityTask.QualityTaskInternalId
{
      @ObjectModel.foreignKey.association: [ { exclude } ]
  key I_QualityTask.DefectInternalID,
//  key P_QltyTaskActionFllwUpParam.DefectAffectedObject,

  key I_QltyTaskFllwUpActionParam.DefectAffectedObject,
  
      I_QualityTask.QualityTaskInternalId,
      I_QualityTask.QualityTask,
      I_QualityTask.ChangedDateTime,
      I_QualityTask.QltyTaskFollowUpAction,
      I_QualityTask.QltyTaskFllwUpActionSts,

// Associations

      _QltyTaskFollowUpAction,
      _QltyTaskFllwUpActionSts

}
where I_QualityTask.IsDeleted is initial and
      I_QltyTaskFllwUpActionParam.DefectAffectedObject is not initial and
      I_QltyTaskFllwUpActionParam.DefectAffectedObjIsAddlParam <> 'X'

Learn More