I_DefectAffectedObjLastTask

DDL: I_DEFECTAFFECTEDOBJLASTTASK SQL: IDEFAOLASTTASK Type: view COMPOSITE Package: VDM_QM_NOTIFICATION

Data of Latest Follow-up Action for Affected Object

I_DefectAffectedObjLastTask is a Composite CDS View that provides data about "Data of Latest Follow-up Action for Affected Object" in SAP S/4HANA. It reads from 2 data sources (P_DefectAffcdObjActnParam, P_DefectAffcdObjLastActnChg) 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
P_DefectAffcdObjActnParam P_DefectAffcdObjActnParam inner
P_DefectAffcdObjLastActnChg P_DefectAffcdObjLastActnChg from

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName IDEFAOLASTTASK view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Data of Latest Follow-up Action for Affected Object view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
AccessControl.personalData.blocking #NOT_REQUIRED view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.representativeKey DefectAffectedObject view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY DefectInternalID P_DefectAffcdObjLastActnChg DefectInternalID
KEY DefectAffectedObject P_DefectAffcdObjLastActnChg DefectAffectedObject
QualityTaskInternalId P_DefectAffcdObjActnParam QualityTaskInternalId
QualityTask P_DefectAffcdObjActnParam QualityTask
QltyTaskFollowUpAction P_DefectAffcdObjActnParam QltyTaskFollowUpAction
QltyTaskFllwUpActionSts P_DefectAffcdObjActnParam QltyTaskFllwUpActionSts
ChangedDateTime P_DefectAffcdObjActnParam ChangedDateTime
_QltyTaskFllwUpActionSts _QltyTaskFllwUpActionSts
_QltyTaskFollowUpAction _QltyTaskFollowUpAction 
@AbapCatalog.sqlViewName: 'IDEFAOLASTTASK'
@AbapCatalog.preserveKey: true
@AbapCatalog.compiler.compareFilter:true

@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Data of Latest Follow-up Action for Affected Object'
@VDM: {
    viewType: #COMPOSITE
}
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@AccessControl.personalData.blocking: #NOT_REQUIRED

@ObjectModel: {
    usageType: {
        dataClass: #TRANSACTIONAL,
        sizeCategory: #M,
        serviceQuality: #C },
    representativeKey: 'DefectAffectedObject',
    semanticKey:  [ 'DefectInternalID', 'DefectAffectedObject' ]
}

define view I_DefectAffectedObjLastTask
  as select from P_DefectAffcdObjLastActnChg
    inner join P_DefectAffcdObjActnParam
      on  P_DefectAffcdObjActnParam.DefectInternalID     = P_DefectAffcdObjLastActnChg.DefectInternalID
      and P_DefectAffcdObjActnParam.DefectAffectedObject = P_DefectAffcdObjLastActnChg.DefectAffectedObject
      and P_DefectAffcdObjActnParam.ChangedDateTime      = P_DefectAffcdObjLastActnChg.LastChangedDateTime

{
    key P_DefectAffcdObjLastActnChg.DefectInternalID,
    key P_DefectAffcdObjLastActnChg.DefectAffectedObject,

        P_DefectAffcdObjActnParam.QualityTaskInternalId,
        P_DefectAffcdObjActnParam.QualityTask,
        P_DefectAffcdObjActnParam.QltyTaskFollowUpAction,
        P_DefectAffcdObjActnParam.QltyTaskFllwUpActionSts,
        P_DefectAffcdObjActnParam.ChangedDateTime,

// Associations

        _QltyTaskFllwUpActionSts,
        _QltyTaskFollowUpAction
}

Learn More