Symptom
The curSalary is showing a different value when using as column and in a formula.
Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.
Environment
SAP SuccessFactors Compensation
Reproducing the Issue
Two columns are set using curSalary, each with a different value.
- Current Salary as a standard column
- Create a custom column using the curSalary column as a formula.
- Values in UDF are maintained for nonEC users under COMPENSATION_SAL_RATE_UNITES, COMPENSATION_SAL_RATE_TYPE and SALARY.
- For EC users this information is being pulled from EC and their respective pay components and component groups.
- On a launched worksheet you will see the following for the standard and custom column formula.
- Here you can see for the first line, Current Salary is 79,695.00 and Custom Salary is 6,641.25 which contains formula curSalary/1.
- From EC we can see the following for this example.
Cause
- The behaviour of standard column curSalary is annualized within Compensation.
- Even though you have this standard colmun mapped to an EC component which holds 6,641.25 the system will annualise this. So, 6,641.25*12 (MON)=79,695.
- For the custom column using curSalary as a formula, it will take the raw data which is being pulled from EC rather than the annualised figure.
- Therefore we see 6,641.25 when using this example formula.
- Additionally, when using Merit this will be taken from the raw EC data going into curSalary.
In the below example we can see 5% of 6,641.25 is 332.06 rather than 5% of 79,695.00 as this would be 3984.75.
Resolution
- This is the current designed behaviour.
- For monthly purposes, the field to be configured under the column can be "SalaryRatePlan" however, in the formula, "curSalary".
Keywords
sf, success factors, CMP, monthly salary, annual, rate units , KBA , LOD-SF-CMP-FRM , Forms & Templates , LOD-SF-CMP-CMP , Compensation , Problem
Product
SAP SuccessFactors Compensation all versions