Convert to csv format

[Former Member]

Hi All,

I am working on a report wherein i need to download data in csv, txt, xls format.

I am using standard SAP Fm's SAP_CONVERT_TO_CSV_FORMAT etc.

But the extract as downloaded from al11 shows hidden data in only one cell in excel sheet

eg: say the extract contains 5 records. After downlioading the file in excel or csv format, it shows only one record and when you click on cell A, it actually contains 5 records.

However, using gui_download the extract is downloaded to presentation server correctly.

Any pointers to where the problem could be, or please suggest some other FM for csv conversion etc.

[Former Member]

Pass the value to field separator in the function module:

I_FIELD_SEPERATOR = 'X'

Regards,

Gurpreet

[Former Member]

Hi,

When downloading the File using GUI_DOWNLOAD in EXCEL format FILETYPE should be 'DAT'.

If You uisng the FILETYPE as 'ASC' then you need to pass the WRITE_FIELD_SEPARATOR as 'X"

[Former Member]

hi shreya tagra ,

u can use the GUI_DOUNLOAD function module with extension .CSV

concatenate the .csv to the inputfile in the last..

Regds / Prabhu

[Former Member]

Hi All,

Closing this thread after along time.

This problem was solved. Issue was there iwth open dataset statement for .csv or .xls.format we need to open it in TEXT MODE ENCODING DEFAULT.

Thanks for your replies.

Regards,

Shreya

Edited by: shreya tagra on Jun 12, 2009 8:35 AM

[vijay_kumar133]

Hi Shreya,

I have a similar requirement to convert the itab data to CSV and download it to desktop.

Can u guide me the on what parameters to be pass in SAP_CONVERT_TO_CSV_FORMAT FM and how to download it to desktop