SAP Knowledge Base Article - Public

3043073 - How to Sort a Custom Column that Has a Column Type of UserName

Symptom

When making a custom column with a type 'UserName' and assigning it to be Reportable, it still shows as not being sortable in the worksheet.

**Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental**

Environment

SAP SuccessFactors Compensation
SAP SuccessFactors Variable Pay

Cause

The column type 'UserName' is currently not sortable on the worksheets. 

Resolution

To make the UserName column sortable we need to set the column to be type 'String'. However when configuring the field to be String and the field takes in the UserName, the system will return the users ID and not their name. In order to make the column display names and be sortable, a second column needs to be created that has a lookup table which references the column displaying the user IDs.

This Column will then reference a Lookup table which will compare the UserID to the name provided.

Once this is done this column should then be sortable on the worksheet:

See Also

2269345 - Compensation - Variable Pay - How to sort by Custom Field on the worksheet

Keywords

UserName, UserID, Sortable, Compensation, String , KBA , LOD-SF-CMP-FRM , Forms & Templates , How To

Product

SAP SuccessFactors HXM Core 2011