2084281 - Manage Data - Standard user columns as import key fails - Compensation

SAP Knowledge Base Article - Public

2084281 - Manage Data - Standard user columns as import key fails - Compensation

Symptom

  • In some cases you may want to use a User Directory column as a compensation custom column import key. This kind of configuration is not recommended (best practice is to define a unique import key for each custom field) but is possible. It’s usually used to avoid importing the same data twice.
     
     
  • In some cases, custom column won’t be populated as expected. When exporting the User Directory compensation data, it will be empty.

Environment

  • Compensation

Reproducing the Issue

Using standard columns as compensation custom column import key fails in some cases

  • In a compensation form, you have defined two custom columns:
     
     
    - Custom Country (import key: standard column COUNTRY)

     1.png aaa.png

         - Custom Time Zone (import key: standard column TIMEZONE).

     2.png aaa.png

  • Assuming that COUNTRY and TIMEZONE were properly populated through a standard User Import (no compensation data), when exporting your User Directory WITH compensation data, Custom Country is properly populated but Custom Time Zone is empty.

      3.png aaa.png

Cause

  • This is happening because not every User Directory column can be used as import keys. Custom column import key can only use non system fields (fields stored in users_info table).

Resolution

  • Custom column import key can only use non system fields (fields stored in users_info table). System level fields (fields stored in users_sysinfo table) cannot be used.
     
     
    Here the system level fields list:
     
     
  • STATUS
     
  • USERID
     
  • USERNAME
     
  • PASSWORD
     
  • EMAIL
     
  • GENDER
     
  • LASTNAME
     
  • FIRSTNAME
     
  • MI
     
  • MANAGER
     
  • HR
     
  • TIMEZONE
     
  • DEPARTMENT
     
  • DIVISION
     
  • LOCATION
     
  • JOBCODE
     
  • HIREDATE
     
  • COMPANYEXITDATE
     
  • DEFAULT_LOCALE
     
  • NICKNAME
     
  • SUFFIX
     
  • SALUTATION

Keywords

KBA , sf compensation manage data , sf comp import key , LOD-SF-CMP , Compensation Management , How To

Product

SAP SuccessFactors HCM Core all versions