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
- Go to Business Analytics work center
- Go to Design Reports view
- Select the custom report which you created for purchase order
- Edit with Web Browser
- Enter the Purchase Order IDs
- 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