SAP Knowledge Base Article - Public

2599498 - Approval Task Details data source

Symptom

When conditions in the approval process step(s) are met, task(s) are created for the employee(s) responsible, which the employee responsible can then approve/reject. You would like to analyze the time it takes at each step to approve a document and explore the possibility to reduce the time taken. Scenarios could include:

  • Who are the approvers who take more time to approve the document ?
  • Who needs a follow-up ?
  • What percentage of approvals get rejected  ?
  • How many approvals get corrected before getting approved ?

This can now be achieved by using the Approval Task Details data source. A report created out of the steps mentioned below would list all the approval tasks corresponding to a business document configured for MSA, from which information can be gathered.

Environment

The data source Approval Task Details should always be used as a joined data source along with application created data source. Application created data source should act as an anchor data source. Approval Task Details data source should never be consumed independently. Also, if the business documents are not enable for Multi-Step Approval process, then the report will never work.

For example:

Purchase order and supplier invoice are registered for Multi-Step Approval and the corresponding data source for the same is listed below, which should be set as an anchor data source.

  • Approval of Purchase orders – Data source available for Purchase order header data.
  • Approval of non-PO invoices – Data source available for Supplier invoice header data.

Cause

The data source “Approval Task Details” should always be used as a joined data source along with application created data source.

Resolution

  1. Go to the Business Analytics work center, Design Data Sources view

1.jpg

  1.  Create a joined data source

2.jpg

  1. Add Purchase Order Header Data source as anchor and select the necessary fields required for constructing the report as shown below

 4.jpg

5.jpg

 

  1. Once the anchor data source is added, add the Approval Task Details data source and choose the necessary fields which must be displayed in the report as shown below

 

6.jpg

7.jpg

8.jpg

  1. Remove the UUID attribute of the Approval Task Details data source

9.jpg

  1. Create a join between the Purchase Order ID (UUID) and the UUID from the Approval Task Details data source:

10.jpg

On the created data source, create a report which will fetch all approval tasks for the purchase order(s).

  1. Go to Business Analytics work center, Design Reports view.
  2. After you have created the new report face (e.g. Purchase Order Approval Task), select all the required key, characteristics and complete the report creation guided activity

14.jpg

15.jpg

  1. Execute the report to fetch the approval tasks for the purchase orders, where you can find all the necessary details

16.jpg

Keywords

Approval Task , KBA , no approval task instances to display , user does not have the relevant authoriz , error reading the data of datasource , SRD-CC-BTM , Business Task Management , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , Product Enhancement

Product

SAP Business ByDesign 1711 ; SAP Business ByDesign 1802 ; SAP Business ByDesign 1805