Chinese Character data load issue in BW

[Former Member]

Hi All,

we are facing an issue with the Chinese characteristics in SAP BW system!

Our source is SRM system where it has Chinese characters , when we extract the data all the Chinese characters displaying

as ####.. Chinese language pack is already installed in our system, still it is showing garbage values.

Please help us what need to be done to get the Chinese characters display correctly in BW system

Ps Note: we tried to load the Chinese characters from excel using the Unicode, it worked!

Regards,

J

[Former Member · Accepted solution]

Issue resolved.

Thanks to everyone.

http://scn.sap.com/people/jyothi.velpula/blog/2012/04/23/chinese-characters-data-display-issue

[Former Member · Accepted solution]

Hello Jyothi

I am also facing the same issue .. can you please share the solution for this .

Thanks

Ranjan Awasthi.

[Former Member · Accepted solution]

Please go through my blog

http://scn.sap.com/community/data-warehousing/blog/2012/04/23/chinese-characters-data-display-issue

[former_member188080]

Hi,

Check following SAP note

Note 1321293 - BI_CONT 7.05: Information about installation and upgrade

check following thread

Check in SMLT

Your BW system should be uniciode and R/3 as well

Execute program RSCPINST for Right Code Page Setting and see language installed..

else check further SAP note or write to SAP about this

Thanks and regards

Kiran

[Former Member]

Hi Kiran,

Thanks for you quick reply.

Chinese Language pack is already installed in both the systems.

Thank you for the program which you shared.

Yes Both BW and SRM systems are in unicode. When I run the Current NLS confi to check the code page : I can see the standard codes 4102 4110 in both the systems.

Regards,

J

[former_member184494]

YJV,

We had a lot of issues with chinese characters before..

Things you need to check ...

AFAIK - Ideally if it is a Unicode system - you do not need the language packs. The language packs are only for accessing the system in the native langage - i.e if you want RSA1 to show up in chinese - you need the language packs.

If it is a Unicode system - you sould be able to load the file as it is.

Things to check :

1. Have you set RSKC to ALL_CAPITAL?

2. Does your file have only chinese or other characters in it as well - Korean - and if I remember right - thre are two chinese scripts available - which one are you using ..?

3. If your data is getting activated - check the table contents using SE16 Standard view ( the option that you get in user parameters - DO NOT CHOOSE ALV GRID ) - then you will see the data as it got loaded.

If your file is multiple languages in one - we had a file which had Korean , Thai , Chinese and Japanese all in one - int this case we used to get premature file truncation issues.

[Former Member]

Hi J,

If you have language installed and language in selection for load then you can change logon language in SAP Source system and put China language in selection of InfoPackage and then start loading. It will not give any error.

BW system should able to understand which language character is this, so this is done by using logon language while login to source system.

Regards,

Ganesh

[Former Member]

Hi Arun,

Thank you for your reply

Yes Ours is a Unicode system only.

Things to check :

1. Have you set RSKC to ALL_CAPITAL?

we have set ALL_CAPITAL_PLUS_HEX

2. Does your file have only chinese or other characters in it as well - Korean - and if I remember right - thre are two chinese scripts available - which one are you using ..?

we are extracting the data from SRM system, Its a standard extract.

Loading data with Flat file doesn't have any problem, we were able to see the data in Chinese language

3. If your data is getting activated - check the table contents using SE16 Standard view ( the option that you get in user parameters - DO NOT CHOOSE ALV GRID ) - then you will see the data as it got loaded.

When we check the data in PSA itself , it is showing as ####

Regards,

J