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 Variable Pay
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:
UserName, UserID, Sortable, Compensation, String , KBA , LOD-SF-CMP-FRM , Forms & Templates , How To