@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'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_QLTYTASKFLLWUPACTIONPARAM",
"I_QUALITYTASK"
],
"ASSOCIATED":
[
"I_QLTYTASKFLLWUPACTIONSTS",
"I_QLTYTASKFOLLOWUPACTION"
],
"BASE":
[
"I_QUALITYTASK"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/