3581992 - How to use sequence to auto generate object external code via Import Data?

It is needed to add new data of an object (such as department, division etc.) via Import Data. How to auto generate external code by using sequence?

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 Employee Central

• Foundation Object
• Import Data

Since "Code" column is the mandatory value during import, it is needed to provide some special string to tell business rule that this code needs to be generated by sequence. 

In the example below, the special string is "autoCode".

1. Create a new Sequence: DepartmentCode in Manage Data<Create New 
   
2. Create a MDF business rule with base object: Department 
   
3. Configure the rule under Configure Object Definitions<Object Definitions: Department<Save Rules
   
4. In the import file, fill the Code as below
   

Then the system will generate a new department code by using Sequence number.

code, external code, externalCode, automatic, import data, department, division, position, mdf, metadata framework, object, custom , KBA , LOD-SF-EC-FOO , Foundation Objects (Organisation, Pay and Job Structures) , LOD-SF-MDF-IMP , Import and Export Issues , How To

SAP SuccessFactors Employee Central all versions ; SAP SuccessFactors HCM Core 2411 ; SAP SuccessFactors HCM Suite all versions