SAP Knowledge Base Article - Public

3310618 - Purchase Order Approver Details not Shown in the Custom Report

Symptom

You have created a custom report to see the approver details, however the report does not show the approver.

Environment

SAP Business ByDesign

Reproducing the Issue

  1. Go to Business Analytics work center
  2. Go to Design Reports view
  3. Select the custom report which you created for purchase order
  4. Edit with Web Browser
  5. Enter the Purchase Order IDs
  6. System shows # value

Cause

System shows the Approver details if you remove the Purchase Order Status filter. The purchase order status will be filtered by default with status 1- In Preparation, 3-In Approval, 2-In Revision.

Resolution

You need to remove the Purchase Order Status filter and then system will show the approver details. For purchase orders which are in In Preparation status, system does not show the approver details. Despite system shows the approver details in the purchase order document, it is just a proposal from the system but actual determination happens when the Approval tasks gets generated.

Note:

You can make use of Data Source Approval Task details - BTMAPPV01.

The data source “Approval Task details” should always be used as a join 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 enabled for MSA, then the report will never work.

You have to create a joined data source from Business Analytics work center -> Design Data Sources view -> Create a join Data Source -> Add Supplier Invoice Header Data and Data source BTMAPPV01 (Approval Task Details) -> Make sure to add the Business Document UUID and Supplier Invoice ID -> Then Save the data source and Create a report from this data source.

This way you will be able to see the current approver details when the document is in In Approval & this gives the overview of pending approval details per document. You can use the data source Approval Task details for shopping carts, purchase order, goods receipts as well.

See Also

2599498 - Errors in Approval Task Details Data Source

Keywords

Data Source Approval Task details - BTMAPPV01; Purchase Order approver details; Supplier Invoice approver details , KBA , SRD-SRM-PRO , Purchase Requests and Orders , Problem

Product

SAP Business ByDesign 2211 ; SAP Business ByDesign 2302 ; SAP Business ByDesign 2305