The import of a file in Data Workbench 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, the import file doesn't include any Region field. You are wondering why the error is thrown and how to solve the issue.
Note: Similar issues may occur for other field names.
SAP Cloud for Customer
Reproducing the Issue
- Go to the work center Data Workbench
- Select the Monitor view
- Search for the failed task
- Select the Error log
- You find the error "Please define Region XXX for Country YYY"
The field names in backend and UI differ. The issue is actually related to a field with a deviating name in the file. For the given example, it may relate to the State field. As you can see, the State field is not filled as required. The leading zero is missing. It might have been removed when the file was opened in Excel before importing it.
Check the import file for fields where the leading zero is missing, and correct the same. For the given example, add the leading zero to the State field.
Insert, Upsert, Upload, Update, Monitor, Account, Country , KBA , LOD-LE-BP-BP , Business Partner , Problem