topic Re: write CSV file on application server using OPEN DATASET. in Application Development and Automation Discussions

write CSV file on application server using OPEN DATASET.

Former Member — Thu, 24 Jan 2008 13:14:21 GMT

how to write an internal table to a .csv file on application server using OPEN DATASET output?

Re: write CSV file on application server using OPEN DATASET.

Former Member — Thu, 24 Jan 2008 13:17:53 GMT

U can't write data of internal table as .csv format in an application server. U can just dump the data line by line in application server and then may be u can write another program to read this data and do changes and download to .csv format file.

Re: write CSV file on application server using OPEN DATASET.

Former Member — Thu, 24 Jan 2008 13:30:41 GMT

HI Suhas,

Try the follwoing way.

loop at itab.

concatenate itab-field1 itab-field2....into itab_new-data separated by ','.

append itab_new.

clear itab_new.

endloop.

open dataset <filename> for output in text mode.

loop at itab_new.

transfer itab_new to <filename>.

endloop.

close dataset <filename>.

Regards,

Ravi Kanth Talagana

Re: write CSV file on application server using OPEN DATASET.

Former Member — Thu, 24 Jan 2008 13:54:26 GMT

Hi Suhas,

You can use like this:

DATA: e_file like rlgrap-filename value '/usr/sap/tmp/file.txt'.

open dataset e_file for output in text mode.

lOOP AT it_datatab......

transfer it_datatab to e_file.

ENDLOOP.

close dataset e_file.

Reagrds

Sourabh Verma

Re: write CSV file on application server using OPEN DATASET.

uwe_schieferstein — Thu, 24 Jan 2008 20:13:08 GMT

Hello Suhas

I think if you do not provide a file name for function module SAP_CONVERT_TO_CSV_FORMAT (using cl_abap_char_utilities=>horizontal_tab as delimiter) then the fm convert a structured itab into an unstructured itab (holding TAB separated data).

Then you can use this unstructured itab as input for the OPEN DATASET statement.

Regards,

Uwe

Re: write CSV file on application server using OPEN DATASET.

Former Member — Wed, 21 Oct 2009 08:25:59 GMT

thanks