Problems in using FM SCMS_STRING_TO_XSTRING in Unicode system

[Former Member]

Hi

I am trying to use FM SCMS_STRING_TO_XSTRING in an Unicode system from Hebrew when i trying to download a table to Excel, but i cannt open file that was created or i get it with signs insted of Hebrew letter.

I use it this way -

CALL FUNCTION ‘SCMS_STRING_TO_XSTRING’
exporting
text = l_string
mimetype = ‘APPLICATION/MSEXCEL; charset=utf-16le’

* encodein =

importing
buffer = l_xstring.

Does anyone has an idea what mimetype or encoding i should use ?

Thanks alot

Ami B.

[retired_member · Accepted solution]

Why don't you try CL_ABAP_CODEPAGE. This is directly from basis. Don't know about that myriads of FMs and their do's and don'ts.