P_DEFECTAFFCDOBJACTNPARAM

CDS View

Relation Quality Task to Affected Object

P_DEFECTAFFCDOBJACTNPARAM is a CDS View in S/4HANA. Relation Quality Task to Affected Object. It contains 7 fields. 3 CDS views read from this table.

Used by 3 CDS view(s) 7 fields

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_DefectAffectedObjLastTask view inner COMPOSITE Data of Latest Follow-up Action for Affected Object
P_DefectAffcdObjLastActnChg view_entity from COMPOSITE Last Changed Quality Task per Affcd.Obj.
P_DefectAffcdObjLastEWMActnChg view_entity from COMPOSITE Last Changed EWM related Quality Task per Affcd.Obj.

Fields (7)

KeyField CDS FieldsUsed in Views
KEY DefectAffectedObject DefectAffectedObject 2
KEY DefectInternalID DefectInternalID 2
ChangedDateTime ChangedDateTime 1
QltyTaskFllwUpActionSts QltyTaskFllwUpActionSts 1
QltyTaskFollowUpAction QltyTaskFollowUpAction 1
QualityTask QualityTask 1
QualityTaskInternalId QualityTaskInternalId 1 
@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