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

• The import of a file in Data Workbench fails with the generic error: "Internal error; create an SAP case".
• 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.

SAP Cloud for Customer

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 case"
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"

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.

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

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

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

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