SAP Knowledge Base Article - Public

2823754 - Error: "Please Define Region XXX for Country YYY"

Symptom

  • The import of a file in Data Workbench fails with the generic error: "Internal error; create an SAP incident".
  • The import of a file with only one of these records in Data Workbench leads to a more specific error. It fails with the error: "Please define Region XXX for Country YYY" (XXX represents the Region value, YYY represents the Country name).

However, as you notice, all fields in the import file are filled with values. You are wondering why the error is thrown and how to solve the issue.

Environment

SAP Cloud for Customer

Reproducing the Issue

  1. Go to the work center Data Workbench
  2. Select the Monitor view
  3. Search for the task with several failed records
  4. Select the Error log
  5. You find the error: "Internal error; create an SAP incident"
  6. Create a new file with only one of the failing records
  7. Try to import the file
  8. Select again the Monitor view
  9. As you can see, also this import fails
  10. Select the Error log
  11. You find the error: "Please define Region XXX for Country YYY"

Cause

The "Please define Region" error occurs, if the Region code in the file is maintained as XXX instead of 0XXX. This can be caused by the use of Microsoft Excel which formats data files according to the regional settings of the system. This way, opening the file in Microsoft Excel may have removed the leading zero of the Region code.

When uploading a file without the leading zero, this code is treated as non-existent for the business object and causes an error.

Resolution

Ensure that the leading zero is maintained in the field. Recommendation is to use a CSV editor for editing the file.

See Also

System Reports "Please Define Region" Error Although no Region Field Exists

Keywords

Insert, Upsert, Upload, Update, Monitor, Account , KBA , LOD-LE-BP-BP , Business Partner , LOD-CRM-INT-DWB , Data Workbench , Problem

Product

SAP Cloud for Customer add-ins all versions ; SAP Cloud for Customer core applications all versions