P_MYSINGLEPRESENTDIALOGITEM

CDS View

P_MYSINGLEPRESENTDIALOGITEM is a CDS View in S/4HANA. It contains 2 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_WorkflowMyDecisionStatus view from COMPOSITE Current User Decision Status

Fields (2)

KeyField CDS FieldsUsed in Views
KEY WorkItem WorkItem 1
Workflow Workflow 1
@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

define view P_MySinglePresentDialogItem
  as select from P_WorkflowMyPresentDialogItem
{

  key max(WorkItem) as WorkItem,

      Workflow
}
group by
  Workflow
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_WORKFLOWMYPRESENTDIALOGITEM"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/