Symptom
How to get current route step of Compensation Form from Report Story
Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.
Environment
People Analytics
Report Stories
Embedded Analytics
Reproducing the Issue
1. Create New Story Report
2. Expand Compensation Planning Object from the Available Data
3. Expand Compensation Form you need to report
4. Drag and drop Worksheet in the Query Designer
5. No Current Route Step column available in Worksheet table
Cause
Route Step details for Compensation Planning object in Story is in Form Status Table
Resolution
1. From Worksheet table join Form Status table from Route Entry
2. Select Step Description and Step Status column
3. The Step Description that has Step Status of “Current” is current route step of Compensation form.
Keywords
Compensation Planning, Compensation Form, Report Story, Current Route Step Name, Route Step , KBA , LOD-SF-ANA-SAC-DAM , Data Modelling - Module & Entity Data Issues , How To