SAP Knowledge Base Article - Public

3017822 - Kanji automatically convert to Katakana

Symptom

When you are uploading file in DWB, the Kanji characters are getting translated to Katakana after upload.

Environment

SAP Business ByDesign

Reproducing the Issue

  • Go to Data Workbench -> Import -> Complete Business Objects
  • Select Account and then upload your file where the Account Name was in Kanji characters
  • Once the file is uploaded, Check the field "Name" field in the UI. It will be translated to Katakana.

Cause

This happens when the metadata was added by the excel application beause of some formulas written in the Excel. In dataworkbench tool we accept only string data , no formulas are allowed , So, even if the data was copied from another excel file the formatting could have come from the other cell. So we recommend pasting only the values as text.

Resolution

In the Excel Sheet, Manually select the name cell which was causing the issue and then the text to columns functionality to set the Column data format to text .

Keywords

Data Workbench, Translation, Kanji, Katakana , KBA , LOD-CRM-INT-DWB , Data Workbench , Problem

Product

SAP C4C CORE 2405 ; SAP Cloud for Customer core applications 1.0 ; SAP Cloud for Customer core applications 1.5 ; SAP Cloud for Customer core applications 1305 ; SAP Cloud for Customer core applications 1308 ; SAP Cloud for Customer core applications 1311 ; SAP Cloud for Customer core applications 1402 ; SAP Cloud for Customer core applications 1405 ; SAP Cloud for Customer core applications 1408 ; SAP Cloud for Customer core applications 1411 ; SAP Cloud for Customer core applications 1502 ; SAP Cloud for Customer core applications 1505 ; SAP Cloud for Customer core applications 1508 ; SAP Cloud for Customer core applications 1511 ; SAP Cloud for Customer core applications 1602 ; SAP Cloud for Customer core applications 1605 ; SAP Cloud for Customer core applications 1608 ; SAP Cloud for Customer core applications 1611 ; SAP Cloud for Customer core applications 1702 ; SAP Cloud for Customer core applications 1705 ; SAP Cloud for Customer core applications 1708 ; SAP Cloud for Customer core applications 1711 ; SAP Cloud for Customer core applications 1802 ; SAP Cloud for Customer core applications 1805 ; SAP Cloud for Customer core applications 1808 ; SAP Cloud for Customer core applications 1811 ; SAP Cloud for Customer core applications 1902 ; SAP Cloud for Customer core applications 1905 ; SAP Cloud for Customer core applications 1908 ; SAP Cloud for Customer core applications 1911 ; SAP Cloud for Customer core applications 2002 ; SAP Cloud for Customer core applications 2005 ; SAP Cloud for Customer core applications 2008 ; SAP Cloud for Customer core applications 2011 ; SAP Cloud for Customer core applications 2102 ; SAP Cloud for Customer core applications 2105 ; SAP Cloud for Customer core applications 2108 ; SAP Cloud for Customer core applications 2111 ; SAP Cloud for Customer core applications 2202 ; SAP Cloud for Customer core applications 2205 ; SAP Cloud for Customer core applications 2208 ; SAP Cloud for Customer core applications 2211 ; SAP Cloud for Customer core applications 2302 ; SAP Cloud for Customer core applications 2305 ; SAP Cloud for Customer core applications 2308 ; SAP Cloud for Customer core applications 2311 ; SAP Cloud for Customer core applications 2402 ; SAP Cloud for Customer, core applications 2.0