SAP Knowledge Base Article - Public

3381139 - Error while importing Payment Information ''Key columns are not defined for referring field: customPayType'' - Employee Central

Symptom

After making an import of payment information the error is received: ''Key columns are not defined for referring field: customPayType''

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

Reproducing the Issue

  1. Go to Import and Export Data
  2. Import attached file Payment Information -Details_Import_oedivT1_USA.csv (USA is an example but can be for any country)
  3. Got to scheduled Job Manager and see result of the import
  4. Download status with error “Key columns are not defined for referring field: customPayType.”

Cause

The File that has been imported have an wrong column (column E)

Resolution

Check the import template and note that column E of the file that customer has imported has ''toPaymentInformationDetailV3.customPayType.standardPayType'' but in the default template the column E should be ''toPaymentInformationDetailV3.customPayType.externalCode''.


 

See Also

2731099 - How to update existing Payment Information for an Employee through Import? - SAP for Me 

Keywords

KBA , LOD-SF-EC-EDP , Import Employee Data (EC Core only) , Problem

Product

SAP SuccessFactors HCM suite all versions