2543452 - Variable Pay Standard fields formulas

SAP Knowledge Base Article - Public

2543452 - Variable Pay Standard fields formulas

Symptom

This KBA includes the list of formulas and sources of Standard fields in Variable Pay.

Environment

Variable Pay

Resolution

 

Field Name Source Field Name Formula

Assignment Basis

Employee History File per user per assignement Basis -

Target Percent1

Imported form Bonus Plan file ASSIGNMENT_TARGET_PERCENT1  -

Target Percent2

Imported form Bonus Plan file ASSIGNMENT_TARGET_PERCENT2  -

Target Percent3

Imported form Bonus Plan file ASSIGNMENT_TARGET_PERCENT3  -

Target Percent4

Imported form Bonus Plan file ASSIGNMENT_TARGET_PERCENT4  -
Proration - - [(Earlier of Bonus Plan end date and Assignment end date) - (Later of Bonus Plan begin Date and Assignment begin date) + 1] / [(bonus plan end date) - (bonus plan begin date) +1]

Target Amount

- - Proration * Assignment Basis

Goal Weight

Imported from Weight mappings file GOAL_WEIGHT  -

Goal Basis

- - Total Target * Goal Weight

Performance Minimum

Imported from Business Goal files performanceMin  -

Performance Target

Imported from Business Goal files performanceTarget  -

Performance Maximum

Imported from Business Goal files performanceMax  -

Goal Forecast

Imported from Business Goal files forecast  -
Goal Forecast Payout Percent - - Formula

The forecast, forecast2 and result are numbers that the application is to find payout percentages for. We support a maximum of 5 points to figure out the payout percentage. Below are combinations that the application can handle

1. min, target_low, target, target_high and max. (5point)

2. min, target_low, target, max (4point)

3. min, target, target_high, max (4point)

4. min, target, max (3 point) //most common

5. min, target. (2 point).

and their corresponding percentages.

The application figures which 2 points the subject lies between.
Example if min = 10 and target = 20 and max = 40 and given a number representing forecast etc to be 12 it will pick min and target to be the 2 points to do the calculation. If the subject is less than min we always associate zero to be the payout and if it is greater than the max we set it to max.
The detail of the search algorithm being used is in a different document.

Formulas:
Interpolate formula. Given the two points (xmin, ymin) (xmax, ymax) and x
find y ..

y = ymin + (x-xmin)(ymax-ymin)/(xmax-xmin)

Step Formula: we always take the floor when we get the two points which X (subject) lies between.

Direct: "Y" is set to the amount given irrespective of points etc.
Goal Forecast Payout Amount - - Goal basis * Goal Forecast Payout Percent 

Goal Forecast2

Imported from Business Goal files forecast2 -

Goal Forecast2 Payout Percent

 -  - Same as Goal Forecast Payout Percent

Goal Forecast2 Payout Amount

 -  - Goal basis * Goal Forecast2 Payout Percent 

Goal Results

Imported from Business Goal files results  

Goal Results Payout Percent

- - Same as Goal Forecast Payout Percent

Goal Results Payout Amount

- - Goal basis * Goal Results Payout Percent 

Total Target Amount

- - Sum(Goal Basis for each Assignment) + Ind Section Amt, Team Section Amt

Total Target

- - Sum of (Bus Section Amount for each Assignment)

Forecast Calc Amount

- - Sum ( All forecast amounts of all assignments for an employee)

Business Forecast Percent

- - Forecast Calc Amt / Total Target

Forecast2 Calc Amount

- - Sum ( All forecast2 amounts of all assignments for an employee)

Business Forecast2 Percent

- - Forecast2 Calc Amt / Total Target

Business Calc Amount

- - Sum (All Goal Result Payout amount of all the assignments for an employee)

Business Percent

- - Business Calc Amount / Total Target

Team Calc Amount

- - -

Team Rating

- PM Form -

Team Guideline

- - -

Team Percent

- - -

Team Amt

- - -

Ind Calc Amount

- - -

Ind Rating

PM Form    -

Ind Guidelines

Guidelines Configured in Set team guidelines page  - -

Ind Percent

As per the guidelines  - -

Amt

0 (it will be 0 for 2nd and 4th formula) - -

Forecast Amt

- - Sum of (Group Total of Forecast Payout Amount for each Assignment)

Forecast Pecent of Tgt

- - Forecast Amount / Total Target Amount

Total

- - sum of (Group Total of Forecast2 Payout Amount for each Assignment)

Forecast2 Percent of Tgt

- - Total / Total Target Amount)

Final Payout

- - Business calc amt * Ind percent 

Percent of Tgt

- - Final Payout  / Total Target amount.

Percent of Salary

- - Final Payout / Salary (Imported from User Directory)

Keywords

Variable Pay formulas , KBA , LOD-SF-VRP , Variable Pay Programs , How To

Product

SAP SuccessFactors HCM Core all versions