Symptom
"Sort Code" field which is present under Payment Information Portlet in EC along with “Account Name”, “Account Number” and “Account Type”, however is not available while creating canvas report.
Environment
SAP SuccessFactors HCM
- Reporting
- Canvas report
Reproducing the Issue
- Navigate to Reporting
- Create canvas report selecting Payment Information V3
- Notice that all of the fields that are reportable are showing except for "Sort Code"
Cause
The default ID label for Sort code is 'Routing Number', and this is being fetched by canvas.
Resolution
The data stored under 'sort code' can be fetched by selecting the field 'Routing Number', as this is the default label stored for the 'sort code' field.
Keywords
Sort Code, Rounting Number, Canvas, SuccessFactors , KBA , ss_anonymizedkba , LOD-SF-ANA , Analytics & Reporting (Ad Hoc, YouCalc, ORD) , How To
SAP Knowledge Base Article - Public