Skip to Content
Technical Articles
Author's profile photo Safeena Begum

Creating Compensation Worksheets Using Employee Groups

       In order to launch worksheets in compensation management the compensation admins go to Manage Worksheets, fill in the required information, and select an employee who sits at the top of the hierarchy in the organisation, generally the CEO. If ‘Create worksheet for Head of Planning only’ is unchecked, the worksheets are launched for all the planners in the organisation.

In some cases organisations launch their compensation worksheets based on different departments, divisions or legal entities. To launch the compensation worksheets for a specific group of employees, there is another method which makes use of Employee Groups.

For example, if the planner has direct reports working in various departments, and the worksheets have to be launched for employees working for department A, in such a situation the employee groups will be helpful and we can create a group for employees working in department A and launch the worksheet using the group.


To allow access to this feature:

  • Navigate to Admin tools –>Set User Permissions–> Manage Permission Roles

  • Select the required admin role click on Permissions.
  • Under the Administrator Permissions category select Manage Users and enable Manage Employee Groups.

Once the permissions have been granted, new groups can be created

 To Configure:

  • Action Search→ Manage Employee Groups to create dynamic groups of employees.
  • Select Create New Group.
  • Enter the Group Name.
  • Select a category from the People Pool.

  • Click Update to view the members of the group.
  • Exclude any members from the group as needed
  • Click Done.

For launching Compensation Worksheets for a group of user:

  • Navigate to Admin tools –> Actions for all plans in Compensation tile.
  • Select the desired form template as shown below and click on Plan Setup.
  • Under Settings select Advanced Settings.

  • Search for Create worksheets by employee group and enable it.
  • Select “Do not duplicate employees on worksheets”.
  • Click “Update Form Template”.


  • The “Do not duplicate” option prevents users from being moved around on forms if their membership in a group changes.
  • The “Create by employee group” option will be grayed out if any forms have already been created. Delete worksheets to enable this option.

Create worksheets using Employee Groups:

  • Under Actions for all plans, select the template for which Create worksheets by employee group has been enabled.
  • Navigate to Manage Worksheets –> Create Worksheets.

  • Fill out the required details.

  • Select the required group and Launch the worksheet.
  • Planners will receive forms in their inbox with only the employees in the selected group.

Below is the example for how the compensation form will look like for the same planner when using the employee group and otherwise.

Not using the Employee Group:

When using the Employee Groups for launching the compensation worksheet:

There are certain implications when using Employee Groups to launch the worksheets:

  • It will include inactive users.
  • Multiple forms will be created for planners as opposed to a single form with all the direct reports for a particular planner

Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Ravinder Kisari
      Ravinder Kisari

      Good Work.!

      Author's profile photo Safeena Begum
      Safeena Begum
      Blog Post Author


      Author's profile photo Xavier Le Garrec
      Xavier Le Garrec

      Nice documentation on this feature, thank you ! Maybe we could add that this feature only makes sense if nothing changes in the configuration of the template from one group launch to another. For example if a customer needs to launch in January for Salaried employees with one set of eligibility rules and in July for hourly employees with another set of eligibility rules (and potentially a different set of lookup tables/budgets/guidelines), then it is preferable to use 2 different templates instead of this feature because if you do use it you run the risk of overriding things in the first wave of forms that was launched (when using Update All Worksheets for example).

      Author's profile photo sudhanwa Agawekar
      sudhanwa Agawekar

      Hi Xavier, Thanks for the comment and I absolutely agree with what you have mentioned, however since we couldn't find any detailed documentation for this particular feature, we brainstormed internally and Safeena thought of writing on it to explain how to use the Employee Groups for launching Compensation Worksheets.

      Author's profile photo Xavier Le Garrec
      Xavier Le Garrec

      Yes that is great ! thank you for taking the time. We need to write more about Compensation topics on the SAP blog, any content is a great added value for consultants and customers.

      Author's profile photo Tarun Aggarwal
      Tarun Aggarwal

      Nice work Safeena. This is actually a lesser-known functionality but a very useful one which can actually limit the number of templates. But as Xavier mentioned, we need to be vigilant while using this functionality as factors like EC effective date, lookup tables, eligibility rules etc. must be same for all entities to use it.

      Author's profile photo Prathap Mukthapuram
      Prathap Mukthapuram

      Very quality write-up Safeena...keep writing such posts...

      Author's profile photo Alina-Elena Dobre
      Alina-Elena Dobre

      Hi Safeena Begum,

      In this situation, all the different groups used the same effective date of the template?

      Have you tried changing the effective date of the template between launches? I can foresee some of the challenges, but I haven't tested this solution.



      Author's profile photo Xavier Le Garrec
      Xavier Le Garrec

      Hi Alina-Elena Dobre

      template effective date cannot be changed once 1 or more worksheets have been created, the limitation is also there for launching by employee groups unfortunately.

      All the best