SAP Knowledge Base Article - Public

2995040 - How to Upload Values to a KUT List Field Which Contain Special or Foreign Characters

Symptom

You tried to upload a list of values to a KUT list field from Microsoft Excel, however this list have special or foreign characters which are not being displayed as expected.

Environment

 SAP Cloud for Customer

Cause

When converting CSV to Microsoft Excel and from Microsoft Excel to CSV, special characters and foreign characters tend to loose it encoding.

Resolution

  1. In Microsoft Excel, open the *.xlsx file.
  2. Select Menu and click Save As.
  3. Enter any name for your file.
  4. Under "Save as type", select Unicode Text.
  5. Click Save.
  6. Correct the file extension.
  7. Open your saved file in Microsoft Notepad or Notepad++.
  8. Replace all tab ("/") characters with commas (",").
  9. Save and now you can upload.

Keywords

Umlauts, Upload, Excel, KUT, List Field, Special Symbols, Characters, Language , KBA , AP-RC-UIF-FLX , Page Layout & Key User Configuration , How To

Product

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