@AbapCatalog.sqlViewName: 'PFIVERMYSPDIA'
@AbapCatalog.compiler.compareFilter: true@AccessControl.authorizationCheck: #NOT_REQUIRED@ObjectModel.usageType.serviceQuality: #D@ObjectModel.usageType.sizeCategory: #XL@ObjectModel.usageType.dataClass: #MIXED@ClientHandling.algorithm: #SESSION_VARIABLE@VDM.private:true@VDM.viewType: #COMPOSITE// to avoid scenario that one user has both dialog approved and to be approved
// two entry will come from P_WorkflowMyPresentDialogItem
defineview P_MySinglePresentDialogItem
asselectfrom P_WorkflowMyPresentDialogItem
{
key max(WorkItem) as WorkItem,
Workflow
}
groupby
Workflow
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_WORKFLOWMYPRESENTDIALOGITEM"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/