Symptom
Custom columns created in Compensation are not populating data from the User Directory File (UDF), even if import keys have been defined for the custom fields
**Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental**
Environment
SuccessFactors HCM Core
Compensation Management
Reproducing the Issue
- Open Compensation Home
- Select your template
- Click on Plan Setup > Design Worksheet > Design Worksheet
- Create your custom column (e.g. Location)
- Scroll down and define its import key as LOCATION
- Launch Worksheets
- The Location column will be blank, despite the UDF having data for the column Location
Cause
This is expected behavior. As per CMP-6804, Compensation custom columns are different from the standard elements defined in the data model. The Compensation custom fields are taking data from a table which maps to non-standard system keys.
Resolution
First, you will have to define a custom import key. You can do this in Design Worksheet. Follow the same instructions as reproducing the issue, but instead of using a standard element field like LOCATION, set a custom name for the Import Key, like this screenshot below:
This will create a new column in UDF, that you will have to populate with the same information as the standard UDF column via a simple copy-and-paste. The manual process is as follows:
- Go to Admin Center > Compensation > Actions for All Plans
- Click on Import/Export Data > All Plans > Employee Data Export
- Click on the > next to Specify Compensation Data Updating Options
- Check Include User Compensation Data.
- Check Include imported compensation field(s) (and planner flag if applicable) defined for the selected compensation form template(s) below:
- Click Export User File
- Open the CSV file in your spreadsheet editor (NOTE: if your userIDs have leading zeros in them, please take care when directly opening the CSV file in Microsoft Excel, as they can truncate leading zeros.)
- Copy the data from the standard column and paste the same information into the custom column, like so:
- Save, then go back to Admin Center Compensation > Actions for All Plans to perform an import (the default page is the Employee Data Import Page)
- Once again, open the Specify Compensation Data Updating Options, and check Update Compensation Forms.
- After importing the data, relaunch your forms, and the data should now be populating properly onto the worksheet
Keywords
UDF, Compensation, Import, Custom Field, standard field, , KBA , LOD-SF-CMP-FRM , Forms & Templates , Problem