SAP Knowledge Base Article - Public

2833823 - Report Shows Employee's First and Last Name in Wrong Order

Symptom

You are showing employees in a report, for example the report Opportunity Analysis. You notice that for some employees, the order of last name and first name is correct, while for others it is reversed.

Environment

SAP Cloud for Customer

SAP Business ByDesign

Reproducing the Issue

  1. Go to the work center Business Analytics.
  2. Select the view Design Reports.
  3. Search for your report. In our example, it is the report Opportunity Analysis.
  4. Run the report with the required selection.
  5. In the view, add the field Employee Responsible.

You see that for some employees, the system shows the last name first, while for others, it shows the first name first.

Cause

There is a Business Configuration setting that determines the name format for employees of a specific country. The system will check the workplace address of an employee, determine the country based on that, and then apply the settings of that country to the name.

In your case, either the name format is not maintained in the business configuration, or the respective employee has no workplace address in the system due to which the country cannot be determined.

Resolution

Maintain the business configuration settings here:

  1. Go to the work center Business Configuration and the view Overview.
  2. Search for the activity: General Business Partners.
  3. Open it and click Maintain Name Formats.
  4. In the first table called Name Formats, you can either change settings for an existing country or add a new country.
  5. In the second table called Details of Name Format, you can maintain the order of each name element (first name, last name, academic title etc).

Now also make sure that the employee with the wrong format has a country in the workplace address:

  1. Go to the work center Administrator and the view Employees.
  2. Search for your employee and click Edit.
  3. Scroll down to In-House Address and maintain at least the country.
  4. Save.

Keywords

employee, name, order, first name, family name, last name, name format, sequence, business analytics, report, data source, business partner, address, employee responsible , KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , How To

Product

SAP Business ByDesign all versions ; SAP Cloud for Customer add-ins all versions ; SAP Cloud for Customer core applications all versions