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.

"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental." 

SAP S/4HANA Cloud Public Edition

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_V2

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.

Please consider that if you want to get the result of the workitem you can access to I_WORKFLOWSTATUSDETAILS.

This Cds view contains 2 useful  fields,:

"Status" , which will be "COMPLETED"  /"READY"

"Returncode" which will be filled with the result , E.g RELEASED or REJECTED once the Workitem is completed with one final action.

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