File Inbound (csv) having Japanese and Chinese character

[Former Member]

Hi Expert,

I have the scheduled ABAP Report which is import csv to zTable periodically.

But i have problem in showing the japanese and chinese chracter in the data view, all non-english characters display as ##########

The zTable i used is using EN as original language, is that cause a problem?

So how could I show the correct chinese , japanese data in SAP SE16N?

Thank you!.

Chris

[Former Member]

Hi Christoper,

1) First your bankend should support the special characters hence first check whether Japanese & chinese languages are mainatined in your system.

2) Issue may be with front end also.

Recently I had a issue whether all the special characters were appearing as # even though languages were maninatained in the system. Finally I found that in my SAP Logon pad .

In SAP Logon options->Genral tab field Additional command Line Arguments should be blank.

In my case it was showing some default code page parameter, So I remove that and it was working fine.

Please rate in case of information is helpful to you.

Regards,

Pushkar Joshi

[Former Member]

Hi Pushkar ,

Thanks for your fast response !

I have found that my SAP GUI Start Options having no parameters (blank field) already.

Recently i have tried to created a table using "Original Language" as ZF(Chinese Trad) and login using ZF as login language,it shows the Chinese character correctly . but i presume that the case will work for Chinese character only but not for japanese chracter.

How about if it is a must to show chinese and japanese chracter in the same zTable?

Is there any way to convert the zTable to UTF8?

Thanks a lot!

BR - Zeus

[Former Member]

Hi Christopher,

Do in Unicode format.

Just copy some Chinese characters to textpad and save. You will get a popup. Click cancel and select unicode format and save. Now upload the file. It should work fine.

[Former Member]

Hi,

Even I faced same problem a year back. The non-english characters will be displayed as #### only if your original language is EN as SAP system could not able to recognize the non-english characters.

First see whether you are able to see the proper characters in your text file. I hope you need to save the text file in unicode format.

Just copy some Chinese characters to textpad and save. You will get a popup. Click cancel and select unicode format and save. Now upload the file. It should work fine.

OR

You can try the TEXT TABLE for particular language to upload.

For any further information please let me know.

[Former Member]

Hi

May i know what is "text table" you have mentioned?

Also, how about if the original file is not being able to change to utf8

can i do that programmatically in encoding conversion in ABAP during after upload the file to SAP or during reading the content to zTable process?

BR- Chris

[Former Member]

This message was moderated.

[Former Member]

This message was moderated.