Symptom
You need to create a report with details about the approval process, which can´t be found on the Procurement Apps.
Environment
SAP S/4 HANA Cloud 2202
Resolution
You can create the query with several tables :
from Invoice you would have 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
You need to define the Join conditions accessing the tables on the Customer Query:
I_WORKFLOWSTATUSOVERVIEW (IWRKFLWSTTSVW)
you can use the field APBUSINESSOBJECTNODEKEY1 with the purchase order number
you can use the field APBUSINESSOBJECTNODEKEY1 with the purchase requisition number
you can use the field APBUSINESSOBJECTNODEKEY1 with the Invoice number and SAPBUSINESSOBJECTNODEKEY2 the year.
Keywords
KBA , MM-FIO-PUR-PO-WFL , Purchase Order Workflow , MM-FIO-PUR-REL , Fiori UI for Purchasing Approval , Problem