Data Transfer with APD in UTF-8 format

[Former Member]

Hello Experts,

I am facing a situation where I need to transfer data from our Unicode BW system to the external system which accepts data only in UTF-8 format.

I have created an APD and I am storing the result file on the application server of the BW system where the external system picks up the data. The problem arises when the target system is unable to read the file as it is in unicode format or UTF-16. Only when I manually save the file as UTF-8 type I can transfer the file to target which it can read. I need to avoid this manual intervention.

Does anyone have a better way of doing this activity.

I will highly appreciate a good reply or a solution.

Thanks,

Rohit

[Former Member]

Hi,

Which command you are using to open file ?

Regards

Rahul

[Former Member]

I am exporting the file from AL11 to my desktop and giving the encoding as UTF-8.

[nils_buerckel]

Hi Rohit,

if you transfer the data with

OPEN DATASET IN TEXT MODE ENCODING UTF-8

the system is using UTF-8 as code page for the file and you can pick up the data as desired.

Best regards,

Nils Buerckel

SAP AG

[Former Member]

Can you please elaborate more on this property for me .

[nils_buerckel]

Hi Rohit,

using OPEN DATASET is the standard way to download data in an ABAP program.

Please have a look at the standard help for a description.

However I guess it does not help you ...

Can you please describe your specific problem in more detail ?

What exactly are you doing when you say

'giving the encoding as UTF-8' ?

Do you convert the data or add a BOM (Byte order mark) ?

Regards,

Nils Buerckel

[Former Member]

Hello Nils,

when i try to save the file on the desktop after using the export option in AL11, that time i set the encoding property in 'file save as' option as 'UTF-8'.

Our requirement is that by any chance if we can convert the data into UTF-8 format and send it to the target system as the target system can read data only in UTF-8 format.

[nils_buerckel]

Hi Rohit,

AL11 should already save the file in UTF-8 format in a Unicode system.

Therefore I think it should also work without your manual change.

Did you examine the file with an Hex-editor (before and after change) ?

Then you might be able to see the delta ...

Best regards,

Nils Buerckel

SAP AG