2084227 - Managing Lookup Tables in Compensation

This KB article outlines how to manage look up tables in SuccessFactors Compensation/Variable Pay.

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

 CREATE NEW LOOKUP TABLES

1. Go To Admin Tools: Compensation> Action For all plans> All Plans> Lookup Tables 
2. Find the table name(s) that were referenced in the XML. 
3. Click on the table name. 
4. Scroll down and click Export. Take a screenshot or note current name and # of input/output columns. 
5. Save file to a local drive. 
6. Click Up to all lookup tables. 
7. Create new table: Type new Name, clear description and same # of input and output as the previous table. 
8. Click Create     
9. Click on the table name of the new table that you created. 
10. Browse to the saved file > Import File 
11. Sample file format:
12. Once you have finalized the values, you can return here to re-import updated file toreplace current file. 

Note: It is best practice NOT to 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 templates.

• Updates to lookup table after worksheets are launched are dynamic. 
• Any changes in the table will impact completed worksheets. 
• Executive review won't reflect changes made in the lookup tables, unless you run the job to Update all worksheets.
• Lookup tables give you more functionality/flexibility when using custom calculations within custom fields. 
• A typical use case for a lookup table is when you have a calculation where one or more variables within the calculation can change based on a value on the employee’s record.

Example

A worksheet has a custom calculation that calculates a one time incentive payment, salary * incentive percent, however the incentive percent can vary based on the employee’s level within the organization.

In this case you would use a lookup table within the formula that would pull the correct incentive percent based on the field that stores the employee’s level and then multiply that by the employee’s salary.

An example of what this formula might look like: lookup(‘2011IncentivePercent’,jobLevel,1)*curSalary

• Identify whether the configuration you are using references lookup tables. 
• Check your configuration workbook. 
• Check Admin Tools: Compensation> Action For all plans> All Plans> Lookup Tables.
     If no lookup tables appear here contact Customer Success for help determining which templates and fields reference the lookup tables if you are not sure.

Important

• It is NOT recommended to store any confidential or private information within lookup tables.
• This is due to the data being stored within the browsers which helps improve worksheet performance.
• Previously, end-users can view the Lookup table data using the “View Source” functionality of web browsers.
• There is now an option from Company Settings to have this data encrypted. This is only available from b1911.

sf, success factors, CMP, VRP, browser source, lookup values, encrypted lookup, encryption, changes in lookup table, update lookup table , KBA , sf compensation manage data , LOD-SF-CMP-ADM , Admin Tools, Settings, Permissions , LOD-SF-CMP , Compensation Management , LOD-SF-VRP , Variable Pay Programs , LOD-SF-VRP-ADM , Admin Tools, Settings, Permissions , How To