SAP Knowledge Base Article - Public

2470924 - Import Key on Custom Column not pulling User Data File(UDF) data

Symptom

We have configured a Custom Column with import key as CUSTOM05.

Requirement is to fetch the UDF CUSTOM05 data into the custom column of the worksheet.

But it is giving blank value in the worksheet.

Environment

Compensation Worksheet

Reproducing the Issue

We have configured a custom field as below with import key as CUSTOM05,

Configuration 1.png

But when we launch the worksheet, it returns a blank value in this column.

 

 

Cause

Ideally this configuration should give CUSTOM05 UDF data into the Column of the worksheet for those respective employees.

But we will have to check if "<comp-group id=" is defined. If yes, then import key will not fetch the UDF data.

Resolution

But the workaround for this would be, not to define the import key in the Custom Column.

Once you save this custom column in the Column Designer, there would be a column created in UDF in the format "<GROUPID>_<ColumnID>".

For example if Group ID defintion in the Template is like

<comp-group id="2017"/>

and Column definition in the Column Designer with Column ID = customField4,

Then the UDF Column would be '2017_customField4'. So you will have to populate the data into this column.

 

You will need to populate/import data into this column of the UDF, so that data from this field will come into the Custom Column of the worksheet for those respective employees.

Keywords

Import Key Custom Column , KBA , LOD-SF-CMP-ADM , Admin Tools, Settings, Permissions , Problem

Product

SAP SuccessFactors HCM Suite all versions