SAP Knowledge Base Article - Public

2403573 - "Sort Code" field is not reportable in advance reporting

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

  1. Navigate to Analytics
  2. Advance reporting
  3. Create Report selecting Payment Information V3
  4. Notice that all of the fields that are reportable are showing in analytics except for "Sort Code"
  5. 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

Product

SAP SuccessFactors HCM Suite 1705