Skip to Content
author's profile photo Former Member
Former Member

Extracting MDG-M Workflow Data and Processor name


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 :-)

Add comment
10|10000 characters needed characters exceeded

3 Answers

  • Posted on Jun 13, 2017 at 06:33 AM


    I am not sure how different the output of report data and structure you are building. However, there is already a standard way of identifying the completeness of the CR. Couple of possibilities are as follows

    1. Navigate to Actual Role Menu Main Page.
    2. Click on the Change Requests & Document
    3. Click on Display Change requests --> un-check No Finalized CR check box if in case you want to search for the CR which is still in process --> Click Continue.
    4. Choose an entry from the result list and click on the "Workflow Log" Button. This shows both foreground and background steps associated with the CR.

    If the requester / or the user who submitted the CR wants to know with whom it is pending then just follow the above steps but at step 3 you have to click on MY Change requests.

    You have possibilities to Filter, Sort, and search based on user ID who created in either cases..

    Thanks, Pavan

    Add comment
    10|10000 characters needed characters exceeded

  • Posted on Jun 13, 2017 at 09:47 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 13, 2017 at 10:16 AM


    Please use the standard delivered class CL_USMD_WF_SERVICE. I have given some sample methods below which could be useful to you.

    Add comment
    10|10000 characters needed characters exceeded