Solution : https://service.sap.com/sap/support/notes/1151258 (SAP Service marketplace login required)
Summary :
When attempting to send emails with Excel attachments from an ABAP application in Unicode environments, issues arise such as corrupted data or errors upon opening the attachments. Problems occur due to encoding mismatches, as Excel expects UTF-16LE encoded data with a byte order mark (BOM). Current SAPconnect configurations typically set CSV documents to UTF-8, which leads to conflicts in Excel compatibility. Moreover, XLS formats, treated as binary by SAPconnect, avoid conversion but encounter platform-specific UTF-16 encoding issues without the necessary BOM. The solution outlined includes implementing correction instructions or importing the relevant Support Package that introduces a new sample report BCS_EXAMPLE_7 which considers these Excel-specific constraints using the new class CL_BCS_CONVERT for correct data encoding and handling.
Key words :
multi-byte code pages, recipient receives corrupt data, byte order mark mentioned, system expects body text, code page utf-16le, sapconnect code page setting, excel expects unicode data, byte order mark, target code page, code page conversion
Related Notes :
| 1319517 | Unicode Collection Note |
| 1151257 | Converting document content |
| 590126 | Sending CSV documents up to Release 4.6 |