Managing Compensation Tables

Objective

After completing this lesson, you will be able to manage compensation tables.

Compensation Tables

Lookup tables are used in custom formulas to map data to an employee based on certain attributes. Each compensation configuration is unique. Depending on your configuration, you may have many lookup tables or none at all. Your consultant will help you set up your initial lookup tables. The administrator maintains the lookup tables throughout the compensation cycle.

Lookup Tables

Before each new cycle begins, you can create new lookup tables if your data will change year over year. Lookup tables must be in the CSV format with columns in the following order:

Key 1
Value 1
Value 2
Value 3

A maximum of five inputs (Key) and five outputs (Value) are allowed. While headers are not required, they can be included as the first row to make the table more meaningful and understandable. For example, you could use Country for the Key header and Merit, Bonus, and Lump sum for the Value headers.

Lookup tables are accessed in Actions for all plans→Import/Export Data→All Plans→Lookup Tables. One lookup table can be used for different custom fields; output values are indicated using integers 1 to 5. The steps to modify and create a new one are similar to the steps to create a currency conversion table.

When using sensitive employee information as input keys in lookup table, an optional setting is available in Company Settings to encrypt the lookup table data. Encrypting data for large tables might impact system performance.

Caution

You should not update lookup tables that were referenced in worksheets that have been launched for a prior cycle. If you anticipate any changes to the input or output values, it is best practice to create new tables which can be referenced in your new plans. Updates to lookup tables after forms are launched are dynamic. Any changes in the table impacts in-process and completed worksheets.

Stock TablesStock tables are used for Long Term Incentive plans. The types of stock tables include:

Stock Value – Allows for the conversion of currency equity grant values to equivalent units or shares (or vice versa).
Stock Factor – Used to convert stock units to an appropriate mix of applicable equity types.
Stock Participation Guideline – A lookup table that defines the percentage of employees with a specific attribute, for example, pay grade, that are eligible to receive a stock grant.

Manage Compensation Tables

Business Example

Create new compensation tables by using the existing data in preparation for the next cycle.

ExerciseStart Exercise

Steps

Log in as Administrator to SAP SuccessFactors.
Navigate Actions for all Plans by using Action Search.
Select Go to All Plans→Currency Conversion Table.
Select COMP_CURRENCY_CONVERSION.
Select Export.
Open the exported CSV file.
Update the exchange rates by using any online foreign currency exchange rate conversion tool (for example, http://www.xe.com/currencyconverter/).
1. The first column (USD) is the base currency.
2. The second column (fx) is the exchange currency.
3. The third column is the exchange currency rate.
After the updating, save the CSV file locally.
Navigate back to Actions for All Plans→Import and Export Data→All Plans→Currency Conversion Table.
Type 20xx Exchange Rate as the name and description for a new table.
Select Create.
Select the 20xx Exchange Rate name.
Choose the CSV file from the local drive.
Select Import.
You have created a new currency exchange rate table.
Navigate back to Actions for All Plans→Import and Export Data→Salary Plans→Salary Ranges.
Select comp_payguide.
Scroll down, and then select Export.
Open the exported CSV in Microsoft Excel.
Modify the MinPay (column B), MidPay (C) and MaxPay (D) of any of the H paygrades (hourly pay grades).
After the updating, save the CSV file locally.
Navigate to the list of Salary Ranges.
Enter 20xx Salary Range as name and enter a description.
Select functional currency.
Select Create.
Select the newly created 20xx Salary Range.
Choose the CSV file from the local drive.
Select Import.

Result

This completes the exercise

Summary

Lookup tables map data to employees based on attributes and are tailored to each unique compensation configuration. Depending on your configuration, you may have many lookup tables or none at all.

Creation and Format: New lookup tables should be created before each compensation cycle if data changes annually, formatted in CSV with up to five inputs and outputs. Meaningful headers can be added to clarify data points like Country and Merit or Bonus.
Access and Management: Lookup tables are accessed through the Import/Export Data feature in SAP SuccessFactors and can be used across different custom fields. It's important to create new tables for new cycles to prevent dynamic updates affecting previously launched worksheets.
Data Security: An optional encryption setting in Company Settings can protect sensitive employee data in lookup tables, though caution is advised as encrypting large tables can affect system performance.

Go to Course