Reporting on completed workflows

[stianbl]

Hi,
We have set up Custom MDF's where there are the following participants of a workflow:
Initiator: The manager initiates a workflow when adding the MDF to his employee.
Approver: This goes to a seperate approver
Employee: The employee is the final step. He/she checks the workflow and approves if all is OK.

That all works as expected of course, but when these workflows are completed, we have a need of picking them up and archiving them. Normally I would just read the data of the MDF from Odata API on custom MDF object of user. But I also need to fetch information about the approvers in the workflow, and at what date they signed/approved the workflow.

I was hoping to be able to do this with the latest release of 1H 2025, but cant seem to figure out how to fetch the participants, and date of approvals.

With only one initiator and one final approver, I can store the user and date in the MDF itself, as the creation of the MDF is triggering a save (so I can populate hidden fields) and the final accept of the workflow is also triggering a save (so I can populate final details). But with an approver in the middle, not changing anything (only approving or sending back), there is no save action, so no way to pick up the user and date of this "middle" approver. Hence the need to access this from API after workflow is completed.

Any tips on this would be great!

See image for reference. This is what I can see when browsing completed workflows from the "Workflow Requests Page". I want to fetch Initiator, Approver and Employee (final approver) as shown here, with userID/name and date of approval.

[Elsa123]

Hi, You can use canvas report to report on data that you need https://me.sap.com/notes/2274688 Report Canvas - Advanced reporting: Workflow Changes Activity log: The Workflow Changes Activity Log report provides details of the Workflow Request history, which is displayed on the activity log section from the Workflow UI. The following information is displayed: Who has initiated the workflow, who has approved a workflow step, who has rejected or sent back the workflow step. Furthermore, following details are displayed: If the workflow step was processed on behalf of somebody or the workflow step was escalated from one employee to another. Best regards, Elsa

[stianbl]

Edit: Double-post.

[stianbl]

Thanks a lot, I will check it out. Do you know if this is also available through Odata API? I've tried to find it, but have had no luck so far. Tried to dig through all the wf* api endpoints and could not yet identify a good way to get approvers (and time/date of approval) of workflow participents for a given MDF object. My need is to archive MDF objects, and for that I need to also include who approved each step, at what date.

[stianbl]

I can use WfRequest to get most of the details it seems, but I have not found a way to get the correct wfRequestId to fetch information from a specific MDF entry's workflow for a user.