SAP Knowledge Base Article - Public

2768129 - Import Keys pointing to Standard Elements not Populating Data to Worksheet - Compensation Management


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**


SuccessFactors HCM Core

Compensation Management

Reproducing the Issue

  1. Open Compensation Home
  2. Select your template
  3. Click on Plan Setup > Design Worksheet > Design Worksheet
  4. Create your custom column (e.g. Location)
  5. Scroll down and define its import key as LOCATION2019-03-14_1-38-04.png
  6. Launch Worksheets
  7. The Location column will be blank, despite the UDF having data for the column Location


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.


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:2019-03-14_3-55-43.png

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:

  1. Go to Admin Center > Compensation > Actions for All Plans
  2. Click on Import/Export Data > All Plans > Employee Data Export
  3. Click on the > next to Specify Compensation Data Updating Options
  4. Check  Include User Compensation Data.
  5. Check  Include imported compensation field(s) (and planner flag if applicable) defined for the selected compensation form template(s) below:2019-10-12_5-35-33.png
  6. Click Export User File
  7. 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.)
  8. Copy the data from the standard column and paste the same information into the custom column, like so:2019-10-12_5-33-32.png
  9. 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)
  10. Once again, open the Specify Compensation Data Updating Options, and check Update Compensation Forms.
  11. After importing the data, relaunch your forms, and the data should now be populating properly onto the worksheet


UDF, Compensation, Import, Custom Field, standard field, , KBA , LOD-SF-CMP-FRM , Forms & Templates , Problem


SAP SuccessFactors HCM Core 1811