SAP Knowledge Base Article - Public

2085258 - Worksheet Design - Include Names of Other People in Worksheets - Compensation


  • It is possible to include a column or columns in the worksheet using the UserName feature, which populates the fields with a person's first and last name.

    This could be used to show anyone's name, but is typically used to show someones second manager or HR manager for example. The feature requires you to configure a field and populate the data file with the people's UserID.

  • The purpose of this field is to be able to display the full name of any user (first name, middle name, last name) in a custom column by supplying UserID only in User Directory.


  • Compensation


  • To do so, go to Admin Tools > Compensation > Compensation Home > Your Compensation Form Template > Plan Setup > Design Worksheet.

         Hit Add Column button and choose Custom


 In Configure the selected column (right hand part of the screen), use the following settings:

  • Column Name: give your new column a name (in our example, Second Manager)
  • Read-only: Choose Yes
  • Column Type: Choose UserName
  • Formula: leave empty
  • Validation: No validation

      1.png x.png


  • Column width: leave empty (recommended)
  • Other Options: select options you need (in our example, reportable and reloadable)
  • Column Id: give a unique column id or leave system suggested name.
  • Import Key: give a unique import key (in our example SECONDMANAGERID)


   Save your changes

   Next step is to populate User Directory file with UserId. To do so, export the User Directory including Compensation information.

      2.png dd.png

  •  Open your exported file and populate your import key column with UserIds (in our example SECONDMANAGERID).

      3.png dd.png


  • Save your changes and import the updated file back and create a new form.
  • Check your newly created form.

       4.png dd.png


KBA , sf compensation worksheet design , LOD-SF-CMP , Compensation Management , How To


SAP SuccessFactors HXM Core all versions