SAP Knowledge Base Article - Public

2077493 - Manage Data - Business Goals Weights and Mappings - Variable Pay

Symptom

  • Weights and Business Goals not showing in worksheets correctly.
  • How to define the import file?

Environment

SAP Success Factors Compensation Variable Pay

Cause

  • In Variable Pay Weights and Mappings are required in the Template in order to establish a link between the business goals and the bonus plans. This then determines the unique weights we wish to set for these fields.
  • See below for details on how to define the import file.

Resolution

  • The business goal weights file is imported into SuccessFactors at: Admin Tools > Compensation Home > Select correct plan > Plan Setup > Plan Details > Import Business Goal Weights. Business goal weights must be imported prior to calculating bonus payouts.
  • When the business goal weights file is imported, there is an option to Delete all existing records prior to importing new data. It is strongly recommended that a full file replacement be done each time, so this option should generally be selected.

 
Important! The business goal weight file must be re-imported every time the business goals file (discussed in the previous section) is imported to reestablish the link between business goals and bonus plans.

     Considerations

  • Bonus Plan Name is used as key to the Goal Weights table, not the bonus plan code.
  • Weights are not enforced to add up to 100% via import.
  • Weight and Mapping file will be deleted after a new goal file is imported.  You are required to reload the weight and mapping file before recalculating bonus payouts.


Weights and Mappings (Goal Weights) Import File Format

Assumptions on file format:

  • The import file should be a CSV text file: comma-delimited, with string values enclosed in double quotes. The file can be named anything you wish (but should have a .csv extension).
  • The first record is designated as the system header for the field.
  • Bonus plan name and Business Goal name is unique for a bonus program.
  • If the same relationship appears more than once in the file then the last one will actually take in to effect
  • All percentages should be imported in decimal format (Example. 10% = .10)

     Validations

  • Bonus plan and bonus program exist for the program.
  • Weight should be between 0 and 1.

 

Column

Data Type

Example

Description

A

BONUS_PLAN_NAME

STRING

“50% Corp, 50% Retail”    

Foreign key to previously imported or configured bonus plan name.  This is a required field

B

BUS_GOAL_NAME

STRING

“Retail EBITDA”

Foreign key to previously imported business goal name.  This is a required field

C

GOAL_WEIGHT

NUMBER

0.5

The weight that is defaulted to this business goal for this bonus plan.  This is a required field

D

DISPLAY ORDER

NUMBER

1

Order in which the business goal is displayed for this bonus plan.  A lower number is displayed higher in relation to other business goals.  This is a required field.

 

Sample Weights and Mappings (Goal Weights) Import File

See file attached at bottom.

Keywords

Business Goals, Mappings, Variable Pay, Manage Data , KBA , sf varpay manage data , LOD-SF-CMP-VAR , Compensation Integration Issues with Variable Pay , How To

Product

SAP SuccessFactors Compensation all versions ; SAP SuccessFactors HCM Core all versions

Attachments

weights.xls