SAP Knowledge Base Article - Public

2345543 - Import Multiple data row with same effective date with associations

Symptom

How to import multiple row data with same effective date with associations.

Example: Required to have multiple Pay Grade (PG1, PG2........ ,PGn), each Pay grade is associated to multiple Legal Entities(L1, L2,....Ln) and have the same effective date.

When this data is imported in multiple rows, one can face validation errors like, "There is already another record with the same start date".

And PG1 is associated to L1 with the first import and L2 in the subsquent imports the first record is overidden.

 

Environment

 SAP SuccessFactors Employee Central: Employee Data Import

Resolution

Use a Pipe seperator "|" between the legal entities in a single row for a particular Pay grade and Effective day.

Example:

externalCodeend-datenamestart-datedescriptionstatuspaygradeLevelLegalEntity.externalCode
Job BandEnd DateInternal DesignationStart DateDescriptionStatusJob BandLegal Entity
PG1 PG101/01/1970Pay Grade 1A L1|L2|L3

Keywords

multi row, multiple association, import association, multiple import. , KBA , LOD-SF-EC-EDP-JOB , Job Information Imports , LOD-SF-EC-JOB , Job Information , How To

Product

SAP SuccessFactors Employee Central all versions