Extracting MDG-M Workflow Data and Processor name

[#1]

Hi

I'm working on a reporting model to understand the best method of assessing where in the process a CR is and who it is currently sat with (user or user group that the next step is assigned to for processing / approval etc).

So far, so good with the following:

• Obtain CR info from USMD120C
• Obtain Workflow ID from USMD2400

From this point I come a bit unstuck - I can see workflow items in SWWWIHEAD but not sure how to identify the current active step and then how to identify the users or groups of users assigning to processing that step.

Appreciate any help 🙂

[Saravanan_SD]

Hi David,

It is not recommended to read the workflow log tables directly. Please follow the below approach.

0. Identify and filter the CRs which are relevant for your scenario (Use table USMD120C)

1. Pass the CR number to the FM - SAP_WAPI_WORKITEMS_TO_OBJECT. This will return the Workflow ID

2. Pass the Workflow ID from step1 to FM - SAP_WAPI_GET_DEPENDENT_WIS to get the workflow step IDs

3. With the workflow items from previous step, use SAP_WAPI_READ_CONTAINER to identify the action by the user.

This way it is possible to identify the background and user steps with actions. The last FM will provide the action (approve/reject) taken by any user on a user step. The above FMs also provide the date,time of each step. Run the above mentioned steps for a CR which has been approved. It will help you to understand the outputs from each FM.

By calculating the date, time difference between the completion of previous step and current step, it is possible to understand the time spent by approvers on a workflow step.

With this approach, I assume you should be able to identify to whom the current CR is assigned.

Regards, Saravanan