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:

externalCode end-date name start-date description status paygradeLevel LegalEntity.externalCode
Job Band End Date Internal Designation Start Date Description Status Job Band Legal Entity
PG1   PG1 01/01/1970 Pay Grade 1 A   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