Your customer uses a look-up table to calculate custom budgets, as shown in the screenshot.

In SAP SuccessFactors Compensation, using look-up tables in formulas is a common method to calculate budget adjustments based on multiple criteria like an employee's country and status. This question is about selecting the correct syntax for using a look-up table to calculate a custom budget based on these criteria. Let's break down the logic and syntax for why option A is correct.

Look-up Table Functionality in Compensation TemplatesIn SuccessFactors Compensation, look-up tables are used to fetch values dynamically based on specific conditions. The lookup function in SAP allows fetching data from a pre-defined table by matching values from specified columns.

Syntax and Parameters in the Lookup FunctionThe lookup function syntax in SAP SuccessFactors Compensation is generally:

plaintext

Copy code

lookup("", , , )

: Name of the look-up table (in this case, "2018_BudgetPool").

and : The fields in the form template used to search in the look-up table. Here, the customCountry and customStatus fields are used to locate the relevant budget value.

: Specifies the index of the column to retrieve. In this scenario, "1" refers to the budget adjustment percentage in the look-up table.

Correct Formula Explanation

Option A: toNumber(lookup("2018_BudgetPool", customCountry, customStatus, 1)) * curSalary

This option correctly uses the lookup function to locate the appropriate adjustment factor (e.g., 1%) from the 2018_BudgetPool table based on the employee’s country (customCountry) and status (customStatus).

The toNumber() function is applied to ensure the fetched value is numeric, allowing it to be used in multiplication.

The formula then multiplies the adjustment factor by the current salary (curSalary) to calculate the adjustment budget.

Why Other Options Are Incorrect

Option B: toNumber(lookup("2018_BudgetPool, customCountry, customStatus, Adjustment)) * curSalary

This option contains syntax errors, such as missing quotation marks around the table name, and “Adjustment” is not a parameter in this lookup. The syntax is incorrect for SuccessFactors’ formula setup.

Option C: toNumber(lookup("2018_BudgetPool", customCountry.customStatus, 2)) * curSalary

Incorrect because customCountry.customStatus is treated as a single parameter, which is invalid. Each key (customCountry and customStatus) should be separated by a comma, not a period.

Option D: toNumber(lookup("2018_BudgetPool", customCountry, customStatus, adjustment)) * curSalary

This option misuses “adjustment” as a parameter in the lookup, which is not defined within the context of the table structure.

Additional SAP SuccessFactors Compensation References

SAP SuccessFactors Compensation Guide: Refer to SAP Help Portal’s SuccessFactors Compensation Guide for syntax rules of lookup tables.

Lookup Table Configuration: In the configuration, ensure that the look-up table (2018_BudgetPool) is correctly defined with customCountry and customStatus as keys, and that the adjustment percentage is in the correct column (column index 1 in this example).

The correct formula, Option A, follows SAP’s syntax requirements and functional logic to retrieve the adjustment budget accurately.