topic Re: Convert to csv format in Application Development and Automation Discussions

Convert to csv format

Former Member — Wed, 01 Apr 2009 14:51:48 GMT

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.

Re: Convert to csv format

Former Member — Wed, 01 Apr 2009 14:59:38 GMT

Pass the value to field separator in the function module:

I_FIELD_SEPERATOR = 'X'

Regards,

Gurpreet

Re: Convert to csv format

Former Member — Wed, 01 Apr 2009 15:00:57 GMT

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"

Re: Convert to csv format

Former Member — Wed, 01 Apr 2009 15:26:02 GMT

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

Re: Convert to csv format

Former Member — Fri, 12 Jun 2009 06:35:17 GMT

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

Re: Convert to csv format

vijay_kumar133 — Fri, 27 Nov 2009 06:44:42 GMT

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