cancel
Showing results for 
Search instead for 
Did you mean: 

Chinese Character Load in SAP BW

0 Kudos

Hi All,

We are facing some issue with the chinese character in SAP BW.

After HCM project finished, user wants to see employee data in SAP BW.

Some employee name displayed in chinese character.

But when we extract the data all the chinese characters displaying as #####

Note:

1. Both system, SAP BW and R/3 HCM are Unicode system and already installed with Chinese Language Pack.

2. tx: RSKC maintained with ALL_CAPITAL.

3. I already tried what mentioned in this link, but it seem doesn't work:

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

4. tx: RSA3 in R/3 it work fine.

5. I tried to load data using excel directly to SAP BW, it worked!

Is there any step that I missed? Please help us to get the chinese characters display correctly in BW system.

Thanks beforehand.

Accepted Solutions (1)

Accepted Solutions (1)

0 Kudos

Hi All,

Thanks for all reply, I already find the solution, for anybody have some problem just follow link below as I mentioned in my message above:

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

And the important thing, make sure you run the infopackage (schedule or immediate) with user that

set chinese as their language in SU01 (or maybe we can set blank). Chinese language pack is mandatory installed in your server.

Regards,

Herry

Answers (2)

Answers (2)

sander_vanwilligen
Active Contributor
0 Kudos

Hi Herry,

Recently I wrote a blog Introducing an Add-on for Cleansing Character Strings and a document Implementing an Add-on for Cleansing Character Strings around this topic. Please try out the Character String Cleansing Add-on.

Best regards,

Sander

former_member220624
Contributor
0 Kudos

Hi Herry,

Is the data dipayed in chinese character in PSA or is it the same ####

If the value is correct in the PSA please check the settings of the dtp (character set and change it to an appropriate value)

Regards,

Amit

0 Kudos

Hi Amit,

Thanks for quick response, data displayed in psa as ####

Regards,

Herry

former_member220624
Contributor
0 Kudos

Hi Herry,

Please check the source table and that particular field from where the data is extracted.

Please make sure that same field is mapped to BW.

Regards,

Amit

former_member976
Active Contributor
0 Kudos

Hi,

check the source side have particular field and you need to correct at source side for the employers.

or you need to write the formula or filed level routine.

maintain the RSKC - # save it and check it out.

Thanks,

Phani.