topic Re: Issue on Write data to application server file in Application Development and Automation Discussions

Issue on Write data to application server file

former_member392866 — Wed, 09 Jul 2014 12:34:56 GMT

Hi Experts,

We are writing data from Internal table to application server file(.xls).

fields we are transferring is : MATNR and sale text .

Problem is materials having sales text with multiple languages.

For English we can able to write successfully bus we have Russian language text also for few materials .

we can't able to transfer Russian language text. In internal table we are seeing proper Russian language text. while transferring data changing with some garbage value.

Could you please provide your inputs for resolve the same .

Thanks,

Balaji.

Re: Issue on Write data to application server file

former_member202771 — Wed, 09 Jul 2014 12:48:37 GMT

Hi Balaji,

Try : "OPEN DATASET g_filename FOR OUTPUT IN LEGACY TEXT MODE CODE PAGE '4110' IGNORING CONVERSION ERRORS."

Thanks,

Anil

Re: Issue on Write data to application server file

former_member392866 — Wed, 09 Jul 2014 13:10:01 GMT

Hi Anil,

Thanks for your quick turn around . Getting dump while executing OPEN DATASET with Legacy. below screen shot FYI..

Thanks,

Balaji.

Re: Issue on Write data to application server file

former_member202771 — Wed, 09 Jul 2014 14:06:29 GMT

Hi Balaji,

Can you type the open dataset statement which you were using before?

Thanks,

Anil

Re: Issue on Write data to application server file

former_member392866 — Thu, 10 Jul 2014 05:52:15 GMT

Hi Anil,

OPEN DATASET l_aname FOR OUTPUT IN TEXT MODE ENCODING DEFAULT.

IF sy-subrc NE 0.

* MESSAGE e208(00) WITH text-027.

ELSE.

DATA : lv_string_ap TYPE string,

rec_len TYPE i VALUE 119.

LOOP AT t_product_f INTO wa_product.

CONCATENATE wa_product-matnr wa_product-desc100

INTO lv_string_ap SEPARATED BY cl_abap_char_utilities=>horizontal_tab.

TRANSFER lv_string_ap TO l_aname.

CLEAR : wa_product,lv_string_ap.

ENDLOOP.

CLOSE DATASET l_aname.

-> in the above code wa_product-desc100 contains Russian language text . work area having correct value , but while transferring to Application server path then its corrupting.

Thanks,

Balaji.

Re: Issue on Write data to application server file

Former Member — Thu, 10 Jul 2014 06:38:01 GMT

Hi Balaji,

for

ENCODING DEFAULT

try

ENCODING UTF-8

and

ENCODING UTF-8 WITH BYTE-ORDER MARK

Regards,

Klaus

Re: Issue on Write data to application server file

former_member202771 — Thu, 10 Jul 2014 07:00:12 GMT

Hi Balaji,

Try,

OPEN DATASET ... IN LEGACY BINARY MODE

OPEN DATASET ............... IGNORING CONVERSION ERRORS

open dataset for output in binary mode non-unicode

OPEN DATASET gv_file FOR INPUT IN TEXT MODE ENCODING NON-UNICODE

WITH SMART LINEFEED.

OPEN DATASET gv_file FOR INPUT IN UTF-8

and other options.

Thanks,

Anil

Re: Issue on Write data to application server file

Former Member — Thu, 10 Jul 2014 07:24:27 GMT

Hi Balaji,

I would suggest send data to unix in two steps.

1. Send only data with english Text.

2. For RU language use page code 1500.

You can give an option of page code on selection screen and use this page code in your open dataset statement.

Otherwise you can try for both text using page code 1100. This will donwlaod EN as well as RU text.

Regards,

Pravin

Re: Issue on Write data to application server file

former_member392866 — Fri, 11 Jul 2014 06:37:24 GMT

Hi Klaus,

ENCODING UTF-8 ->> Not working

and

ENCODING UTF-8 WITH BYTE-ORDER MARK ->> Working but all columns merging (i.e Material no. and sales text are downloading into A column instead of material in A column and Sales text in B column)

Could you please provide any alternative methods to resolve the same .

Thanks,

Balaji.

Re: Issue on Write data to application server file

former_member392866 — Fri, 11 Jul 2014 07:04:36 GMT

Hi Anil,

OPEN DATASET ... IN LEGACY BINARY MODE ->> Going to Dump

OPEN DATASET ............... IGNORING CONVERSION ERRORS ->> Not working

Is there any alternate methods to resolve the same ??

Thanks,

Balaji.

Re: Issue on Write data to application server file

Former Member — Fri, 11 Jul 2014 07:28:39 GMT

Hi,

Check with the option smart line feed in addition to Open dataset.

OPEN DATASET gv_file FOR INPUT IN TEXT MODE ENCODING DEFAULT

WITH SMART LINEFEED.

Regards,

Mallikarjuna