Symptom
You are uploading Leads using Excel and the value for State is not uploaded correctly. However, you don't receive an error message.
Example: You enter "Wien" in the excel field; this State is in the Lead header drop down listed as "W- Wien" but it is not uploaded as "W - Wien".
Environment
SAP Cloud for Customer
Reproducing the Issue
- Download the excel template for Leads.
- Fill the field Country, eg "AT" for Austria.
- Fill in the field State, eg "Wien".
- Click Save Data To.
- Go to the Leads view and find the new Lead.
Result: the field State is filled with "Wien" instead of "W- Wien".
Cause
The values for the field State are Code List values (which are restricted by Country) and have to be used at the code value and not the description.
Resolution
In our example, please enter "W" instead of "Wien". You can use the function "Lookup" which is provided in the excel template to see which values can be entered for the fields.
Keywords
leads, upload, state, country, code list value , KBA , LOD-CRM-LM , Lead Management , Problem