SAP Knowledge Base Article - Public

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


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**


  • SAP SuccessFactors Compensation
  • SAP SuccessFactors HXM Suite


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


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


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


SAP SuccessFactors Compensation all versions ; SAP SuccessFactors HXM Suite all versions