SAP Knowledge Base Article - Public

3784120 - CDS view to fetch data of a workflow step in status 'planned'

Symptom

  • Requirement to create a custom report to display the entire list of approvals for a Purchase Order (PO) in any status that exist as on date.
  • Using released CDS view I_WorkflowStatusOverview only returns tasks in Ready, Cancelled, and Completed statuses.
  • Need to retrieve especially the Planned status and, ideally, all workflow step statuses.
  • Request for a CDS view (or approach) that retrieves the complete approval history.

Environment

Product: SAP S/4HANA Cloud Public Edition

Reproducing the Issue

  1. Build a custom report based on the released CDS view I_WorkflowStatusOverview for PO approvals.
  2. Execute the report for a PO with multiple workflow steps (for example: one completed, one ready, one planned).
  3. Observe that Planned (and other step-level) statuses are not returned; only Ready, Cancelled, and Completed entries appear.

Cause

 In API.sap.com you can see all the status available for Respective the CDS view

There is no standard released CDS view that exposes individual child/step-level workflow work items with status Planned.

 The released workflow CDS views provide top-level or current work item statuses only.

Resolution

  • Acknowledge the current product limitation: there is no standard released CDS view that surfaces step-level (child) work item statuses for PO approvals.
  • Use the available released workflow CDS views for the data they provide, for example: I_WorkflowStatusDetails, I_WorkflowStatusOverview, I_WorkflowRecipients, I_WorkflowTaskExternalStatus, I_WorkflowExternalStatus, I_WorkflowExternalStatusText.

Please post the new feature requirements over the customer influence forum.

Search and Vote the existing idea or Post new Ideas on Customer influence forum

2963059 - How to Submit Feature Requests for SAP S/4HANA Cloud Public Edition - SAP for Me 

See Also

Keywords

cds view, i_workflowstatusoverview, planned status, po approvals, workflow steps, flexible workflow, purchasing, procurement, step-level status, workflow recipients, workflow status details, s/4hana cloud, approval history, po workflow, planned step , KBA , MM-FIO-PUR-REL-2CL , Fiori UI for Purchasing Approval (Public Cloud) , Problem

Product

SAP S/4HANA Cloud Public Edition all versions