2243856 - Employee Export (UDF) shows a Numeric Value in State and/or Country column

• In Employee Export file (UDF) some fields are showing a numeric value instead of a string value.
• In Employee Export file (UDF) some fields are showing the Picklist Option ID instead of the picklist value.

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

• SAP SuccessFactors HCM Suite

1. Download User Data File
2. See that some fields, for example State and Country, show the Picklist Option ID instead of the picklist value.

Picklist "Country" or "City" is mapped in the UDF corresponding field configuration in Manage Business Configuration (BCUI).

In BCUI > Employee Profile > View Template > SysUserDirectorySettings > sysAllUserDirectorySetting > Country, remove the Country/City Picklist mapping.

Additional notes: 

• Also, labels could appear in UDF instead of optionIds, if the labels (external codes) were used while performing Employee Import/Basic Import for the fields of type picklists, such fields as State and Country.
• If the values provided during an Employee Import were in the form of OptionIds (and not labels in the form of text/string), then the same OptionIds will be showing in UDF.

Option Id, picklist, State, Country, standard field, picklist mapping, BCUI, OptionID, Numeric value , KBA , LOD-SF-PLT-UIM , Employee Import Issues , LOD-SF-PLT-PCK , Picklist Management Issue , Problem