SAP Knowledge Base Article - Public

2088061 - Standard Field not showing on exported user data file (UDF) and Basic Import template from Employee Export/Import Employee Data tools

Symptom

When you run the Employee Export, the file is missing one more fields. The fields are also not present when you download the Basic Import template from the Import Employee Data tool.

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

Environment

SAP SuccessFactors HXM Suite

Reproducing the Issue

  1. Logon with admin user
  2. Go to Admin Center
  3. Go to Employee Export
  4. Export the user data file (UDF)
  5. When opening, you notice that there is a field that you setup on data model missing

If using the Import Employee Data tool:

  1. Go to Admin Center
  2. Go to Import Employee Data
  3. Select 'Download Template': Basic Import
  4. Click 'Generate Template'
  5. Fields are missing from the template.

Cause

The cause is that when you create the standard-field on the data model, it was missed to include the field on the section sysVisibleUserDirectorySetting.

This section is where the fields on the employee export file and basic template are pulled from.

Resolution

The solution is to include the missing field on the sysVisibleUserDirectorySetting section as example below for CUSTOM12 field.

You need to make sure that the field is already created on the data model before including it on the sysVisibleUserDirectorySetting.

To include the field, you need to follow the below steps:

Via BCUI:

OR

Via Provisioning:

    • Go to Provisioning > Import/Export Data Model > Export the Succession Data Model and navigate down to the block <edit-template id="sysAllUserDirectorySetting">

<edit-template id="sysVisibleUserDirectorySetting">
<label>User Directory Setting(Visible)</label>
<description>User Directory Setting(Visible)</description>
<standard-element-ref refid="custom12"/>
</edit-template>

Step: Grant RBP (Role Base Permission)

Step: Configure People Profile

  • Go To admin Tool- Configure People Profile
  • Click on Block: Personal Information
  • Go to your Right to: Edit Block: live Profile User Information
  • Scroll down to the bottom - add field
  • Select custom field or standard field

Also:

  1. Export the data model of your instance;
  2. Open the exported data model
  3. Search for the section <edit-template id="sysVisibleUserDirectorySetting">;
  4. On that section check if the standard-element-ref to the field is not yet included;
  5. If not you need to insert it before the </edit-template> tag as example below (on bold what you need to include):

<edit-template id="sysVisibleUserDirectorySetting">
<label>User Directory Setting(Visible)</label>
...

      <standard-element-ref refid="username"/>
      <standard-element-ref refid="firstName"/>
      <standard-element-ref refid="lastName"/>

...

      <standard-element-ref refid="custom12"/>
</edit-template>

  1. Save the file that you have changed;
  2. Import the new data model file with the field into the instance.

With the change on the data model, you now should see the field on the Employee Export.

See Also

  • 2654248 - What is difference between <edit-template id="sysAllUserDirectorySetting"> and <edit-template id="sysVisibleUserDirectorySetting"> in the Data Model and BCUI
  • 2576599 - View Template Section in Manage Business Configuration Tips and Tricks
  • 2643327 - Missing 'Company Exit Date' Field in User Profile for DRTM
  • 2363922 - How to create an HRIS Sync Mapping between an Employee Central field and an Employee Profile Using Userinfo Element field
  • 2088061 - Data Model: VisibleUserDirectorySetting Controlling Field Visibility - Platform

Keywords

 Data Model, sysAllUserDirectorySetting, sysVisibleUserDirectorySetting, UDF, Configure People Profile, basic import, BCUI, Manage Business configuration , KBA , LOD-SF-PLT-UEX , Employee Export Issues , LOD-SF-PLT , Platform Foundational Capabilities , LOD-SF-EC-BCI , Manage Business Configuration (BCUI) & Data Models (XML) , Problem

Product

SAP SuccessFactors HCM suite all versions