SAP Knowledge Base Article - Public

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

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

Product

SAP S/4HANA Cloud 2202