Table to map change request step per workflow WorkItem ID

[former_member631000]

Hello Experts,

MDG calculates and report the SLA times for an entire process, It will show as violated if the number of days/half day is exceeded since the creation, but it does not show in which step took more time to process.

My requirement is to have SLA control in each step of a workflow. Please check the following example:

Customer creation that has 2 approval steps since it submission.

Example: Submission (Requestor) -> Approval 1 (MDO specialist Approval) -> Approval 2 (Business Owner Approval) -> Activation / Replication

I need to know through a report how much time the Approval 1 took to process the Change request, How much time Approval 2 took to process the Change Request based on the priority set by the requestor.

In our scenario we are using BRF+ workflows. I managed to build SQVI query that shows creation and completion date/time of each workflow approval within the change and executor of the approval. What I am missing is process name per each approval step (‘MDO specialist Approval’ or ‘Business Owner Approval’). As I understand this information is defined in the Single Value Decision Table (DT_SINGLE_VAL_<change request type>). What I need is the mapping table that will show change request step per workflow WorkItem ID from SWWWIHEAD table.

Thank you in advance.

[Mark63]

As of SAP MDG 8.0 workflow steps can be evaluated. Please check the following documentation for relevance: https://www.sap.com/documents/2016/06/e26787b9-757c-0010-82c7-eda71af511fa.html

https://www.sap.com/documents/2018/07/02432ba2-107d-0010-87a3-c30de2ffd8ff.htm

Hope this helps,

Markus

[loga201]

Hi Alex,

Use method GET_CREQUEST_STEP of class CL_USMD_WF_SERVICE to get workflow/CR steps based on the workitem id.

Thanks and Regards,

Logan.D