3213204 - Workflow data details for Purchase Orders , Purchase requisitions , Supplier Invoice

A report with details about the approval process is needed, which can't be found on the Procurement Apps.

SAP S/4HANA Cloud

The query can be created with several tables :

from Invoice I_Supplierinvoiceapi01

from Purchase order I_Purchaseorderapi01

from Purchase Requisition I_Purchaserequistionapi01

For flexible workflow, here are the 3 CDS views using which the details of the approvers can be fetched for any business object:

• I_WorkflowStatusOverview
• I_WorkflowStatusDetails
• I_WorkflowRecipients

A Join conditions should be defined to access the tables on the Customer Query: 

I_WORKFLOWSTATUSOVERVIEW (IWRKFLWSTTSVW)

use the field APBUSINESSOBJECTNODEKEY1 with the purchase order number 

use the field APBUSINESSOBJECTNODEKEY1 with the purchase requisition number

use the field APBUSINESSOBJECTNODEKEY1 with the Invoice number and SAPBUSINESSOBJECTNODEKEY2 the year.

Purchase Orders, I_Purchaseorderapi01, Purchase requisitions, I_Purchaserequistionapi01, Supplier Invoice, I_Supplierinvoiceapi01, Flexible workflow, I_WorkflowStatusOverview, I_WorkflowStatusDetails, I_WorkflowRecipients, Customer Query, CDS views, business object , KBA , MM-FIO-PUR-PO-WFL , Purchase Order Workflow , MM-FIO-PUR-REL , Fiori UI for Purchasing Approval , Problem