Skip to Content
avatar image
Former Member

chinese char disorder from SAP download into Excel

Hi all,

I used t_code PA30 to input one person name and the name is '燊'. But when I use customizing report to display and download the person information into Excel,

the display is ordinary and the person name is disorder in the downloaded excel.

the '燊' changed the interrogation mark.

But I use the customizing report to download the other information, that is ordinary.

I don't know the reason, and I hope everybody help me to resolve the error.

Thanks

Ma Chao

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Aug 22, 2007 at 03:59 AM

    Hi,

    When you download in Excel, the character formats are taken from the Front end,

    Check whether chinese font is installed in your system.

    aRs.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi,

      I have a symptom that I add one char as '1' or '#' after the char '燊', and that the char download into excel is successful. How?

      Thanks

  • Aug 22, 2007 at 04:40 AM

    Hi,

    1. WS_DOWNLOAD is obsolete. use fm GUI_DOWNLOAD

    For search and replace a character in string please check this code , may this will be useful to you

    DATA : find(33) TYPE c VALUE 'xx_aa_yy_zz_xx_yy_yyb_yy_yybyy_1', 
    len LIKE sy-fdpos. 
    
    len = 1. 
    
    WRITE:/ find. 
    
    WHILE sy-subrc = 0. 
    SEARCH find FOR 'yy_' STARTING AT len. 
    CHECK sy-subrc = 0. 
    len = len + sy-fdpos + 1. 
    REPLACE '_' WITH '*' INTO find+len(1). 
    ENDWHILE. 
    
    WRITE:/ find. 
    
    

    aRs

    Add comment
    10|10000 characters needed characters exceeded