Symptom
"Sort Code" field which is present under Payment Information Portlet in EC along with “ Account Name”, “Account Number” and “Account Type” is not available while creating report.
Environment
Success Factors Reporting
Online Report Designer
Ad-hoc Report
Advance Reporting.
Reproducing the Issue
- Navigate to Analytics
- Advance reporting
- Create Report selecting Payment Information V3
- Notice that all of the fields that are reportable are showing in analytics except for "Sort Code"
- Irrespective of the same Configuration the field is not visible
Cause
The Cause of the Problem is its by-default ID label which is directly fetching the internal name "Routing Number" from backend. Which causes confusion.
Resolution
Create Query and Include the field "Routing Number" in the query available under "Payment Information V3" portlet.
The name of the field is getting fetched from the backend with by-default name as "Routing number".
SAP Note: we will find this Value only under advance-reporting only, Adhoc will not support this as its MDF Object and MDF objects are best accessible using ODS.
Keywords
Sort Code Rounting Number Online report designer , KBA , LOD-SF-ANA , Analytics & Reporting (Ad Hoc, YouCalc, ORD) , How To