SAP Knowledge Base Article - Public

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

Symptom

  • Weights and Mappings (required) – this flat file links the business goals to the bonus plans and assigns unique weights to this relationship.
     
  • How to define the import file?

Environment

  • Variable Pay

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 re-establish 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 (i.e. 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

KBA , sf varpay manage data , LOD-SF-CMP-VAR , Compensation Integration Issues with Variable Pay , How To

Product

SAP SuccessFactors HCM Core all versions

Attachments

weights.xls