Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

junk characteristics in attached excel file using FM : 'SO_NEW_DOCUMENT_ATT_SEND_API1'

Former Member

‎03-08-2017 12:29 PM

0 Kudos

Hello All - Good day!

I have used the following FM 'SO_NEW_DOCUMENT_ATT_SEND_API1' to send email with attached excel file with mixed data in English and Hebrew letters

I have a problem with text in Hebrew.( in English – OK )

Hebrew appears as garbage in the excel attachment after it was emailed .

Please , your help : how I can fix it ?.

Helena .

2 REPLIES 2

Sandra_Rossi
Active Contributor

‎03-08-2017 7:43 PM

0 Kudos

If the excel file is in CSV format, then prefer saving it using code page UTF16-LE (SAP code page 4103) with BOM, it's the only format correctly interpreted by all Excel versions. For doing so, you'll have to use for instance CL_BCS_CONVERT=>TXT_TO_SOLIX using code page 4103 and BOM true, then attach the CSV as "binary".

david_liu1
Advisor
Advisor

‎03-09-2017 1:15 AM

0 Kudos

Instead of SO_NEW_DOCUMENT_ATT_SEND_API1, you can use SO_DOCUMENT_SEND_API1. Refer to SAP note 190669.