Converting to CSV format...

[Former Member]

Can anyone help me. I want to download a file to local PC in CSV(Comma Seperated Value) format.. IS there any method or Funtion module already available..? If not, please help me with the code...

[Former Member]

Hello Ajay,

Download the file with csv extension like this.

<b>

c:temptest.csv.

</b>

Use the FM <b>GUI_DOWNLOAD</b> for this purpose.

Vasanth

[Former Member]

Hi,

DATA : LV_FNAME TYPE STRING.

select * from vbap into table itab.

LV_FNAME = 'c:\testfile.csv'.

*-- Download the Error Records into a File.

CALL FUNCTION 'GUI_DOWNLOAD'

EXPORTING

FILENAME = LV_FNAME

TABLES

DATA_TAB = I_tab

EXCEPTIONS

OTHERS = 22.

IF SY-SUBRC <> 0.

MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO

WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.

ENDIF.

Pls refer:

https://forums.sdn.sap.com/click.jspa?searchID=4274284&messageID=1658915

Regards

Sudheer

[former_member189059]

What is the format of the file on the application server ?

GUI_DOWNLOAD will only work if it is already in the CSV format

else you may have to programatically convert it