Symptom
Unable to locate or report the Spot Award ID (External Code) field in Story Report Query Designer for the Spot Award object.
Environment
- SAP SuccessFactors Compensation
- SAP SuccessFactors Reporting
Reproducing the Issue
- Open Report Center and create or edit a Story Report that includes Spot Award data.
- In Query Designer, search the available dimensions/columns of the Spot Award object for “Award ID” or “External Code”.
- Observe that the field is not available for selection.
Cause
The Spot Award reporting domain in Story Reports does not expose the External Code field by design.
Resolution
- Note that this is expected behavior: the External Code (Award ID) is not available in the Spot Award reporting domain within Story Reports.
- If you need the External Code directly in the Spot Award Story Reports domain, submit an enhancement request via the Customer Influence program. Refer to the links in the See also section.
As workaround: Use the Spot Award EC Integrated object as the reporting source to retrieve and display the External Code in Story Reports.
See Also
Keywords
Spot Award, External Code, Award ID, Story Report, Query Designer, reporting domain, field not available, Manage Data, EC Integrated object, Rewards and Recognition, Story reporting, dimensions, columns, limitation , KBA , LOD-SF-RNR-REP , Reporting & Analytics, Data Imports & Exports , Problem
SAP Knowledge Base Article - Public