Send the Japense Text file in the "CSV" format

Hi All,

I m facing an Issue regarding the Japense text in the internal table. then we need to convert it into CSV format and send it through the mail .

1. I had used the approach using the content_hex instead of contents_bin in the FM "SO_NEW_DOCUMENT_ATT_SEND_API1".

but junk character come in the excel, while checking in the txn : SOST.

2. I had also used the class cl_bcs , for sending the excel. The file opened in the SOST ,shoews the proper japanese text properly, but didnt opened at the business end . giving the ERROR of "This is not the CSV FILE ".

is there any possiblity or code so that we can send the CSV format file with Japenese text.

Thanks in advance..

Saurabh Goel