SAP Knowledge Base Article - Public

3560874 - "Enter an employee ID between ABC and DEF" Error While Importing Employee in Data Workbench

Symptom

You are importing employees via data workbench and you are seeing the message "Enter an employee ID between ABC and DEF" as result. You wonder where this block is coming from.

Environment

SAP Cloud for Customer.

Reproducing the Issue

  1. Go to the Data Workbench work center.
  2. Select the Import view.
  3. Select individual object.
  4. Select employee and click in next.
  5. Click in the 'Browse' button and select your excel file GHI (where GHI is an excel file with the column 'Employee ID' inside as JKL (where JKL is an ID of employee)).
  6. Click in the 'Upload' button and then in 'Next'.
  7. Click in Next and then Import.
  8. Go to the Data Workbench work center.
  9. Select the Monitor view.
  10. In the My Tasks query, wait for your task to be with status as 'finished'.
  11. Click in the file hyperlink of column 'File Name' to download it.
  12. Open it.
  13. You will see in the error column "Enter an employee ID between ABC and DEF" (where ABC and DEF are ID numbers).

Cause

In the business configuration fine-tuning activity 'Number Ranges for Employees and Service Agents' the JKL value is outside the range of 'begin number' and 'end number'.

Resolution

This is the system standard behavior. Please change the begin/end number (if possible) or mind the range stated there.

Keywords

Range, Employee, DWB, Data, Workbench, Import, ID, Error, Enter an employee ID between , KBA , LOD-CRM-EMP , Employee , LOD-CRM-INT-DWB , Data Workbench , Problem

Product

SAP Cloud for Customer core applications 2411