When running a report with workflow information the Request Type field is pulling incorrect information.
"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."
- SAP SuccessFactors HCM Suite
- Report Canvas on advanced reporting query
- Workflow reports
Reproducing the Issue
- Go to Reporting
- Select the workflow report created and run it.
- The field Request Type will be a code (screenshot 1) instead of what it is showing on the Workflow portlet on Manage Workflow Requests (screenshot 2)
This is an expected behavior of the system since the value showed on the portlet is the field Event Reason Icode and not the Request Type.
To report on this information correctly it is required to use the Event Reason Icode field available on the Workflow Emp Wf Request table. See screenshot below where it is comparing the same example used before on Christian Bellacor. The Request Type is "Terminate" and the Event Reason Icode is what it shows on the porlet.
This is also shown on the guide for standard reports. Using the Open Workflow Requests Standard Report there is a pivot table built. The first column is the Request Type and the second one is the Event Reason Icode as per below:
Request Type - Event Reason Icode , KBA , LOD-SF-ANA-RCT , Report Center , Problem