topic Re: CSV formatted output in Application Development and Automation Discussions

CSV formatted output

Former Member — Fri, 14 Aug 2009 08:50:06 GMT

Hi Every one,

I have at present ALV report.In ALV we donot have CSV format option, so my requirement is i need to get the out put file in CSV format.So can any help me on this requirement.

Re: CSV formatted output

Former Member — Fri, 14 Aug 2009 08:53:36 GMT

Hi Krishna ,

When you are downloading to CSV you can use the FM SAP_CONVERT_TO_CSV_FORMAT or SAP_CONVERT_TO_TXT_FORMAT.

Add a new button in the ALV Mneu which will download the data to CSV format.

Regards,

Arun

Re: CSV formatted output

mohammed_moqeeth — Fri, 14 Aug 2009 09:09:29 GMT

Hi,

To download file in CSV format, first convert internal table data into csv format using function module "SAP_CONVERT_TO_TEX_FORMAT" and then use function module "GUI_DOWNLOAD" as shown below

CALL FUNCTION 'SAP_CONVERT_TO_TEX_FORMAT'

EXPORTING

i_field_seperator = ','

TABLES

i_tab_sap_data = t_output

CHANGING

i_tab_converted_data = t_output_csv

EXCEPTIONS

conversion_failed = 1

OTHERS = 2.

IF sy-subrc 0.

MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO
WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.

ENDIF.

DATA: lv_file TYPE string, lv_sep TYPE c.

lv_file = 'c:\data.csv.

CALL FUNCTION 'GUI_DOWNLOAD'

EXPORTING

filename = lv_file

filetype = 'ASC'

write_field_separator = lv_sep

TABLES

data_tab = t_output_csv

EXCEPTIONS

file_write_error = 1

no_batch = 2

gui_refuse_filetransfer = 3

invalid_type = 4.

Regards,

Moqeeth.

Re: CSV formatted output

Former Member — Fri, 14 Aug 2009 11:31:48 GMT

What should be the types of internal tables t_output and t_output_csv.

Re: CSV formatted output

Former Member — Fri, 14 Aug 2009 11:41:34 GMT

hi,

t_output <<< Your data any format

t_output_csv declare type truxs_t_text_data

you can also try like below:

declare a table like below:

data: begin of t_con occurs 0,

line(255),

end of t_con.

then concatenate all the field values into this line with separator as comma like below:


data: lv_sep value ','.

loop at it_data  <-----your data internal table.

concatenate it_data-field1 it_data-field2...into t_con-line
  separated by lv_sep.

append t_con.

then call the GUI_DOWNLOAD and download the file.

I hope it helps

regards,

Himanshu

Re: CSV formatted output

Former Member — Fri, 14 Aug 2009 12:36:20 GMT

How can we add a button to ALV .

Re: CSV formatted output

Sandra_Rossi — Fri, 14 Aug 2009 22:54:45 GMT

"how to add a button in alv" : please don't abuse, search forum !

"alv does not save as CSV format" : within ALV, when you export data as excel format, it saves a file which is like CSV, but with tabs instead of commas. Provided that the user saves it with the .csv option (like with commas by the way), when the user opens this file later, Excel opens it as if it had commas.

Re: CSV formatted output

Former Member — Thu, 20 Aug 2009 07:37:05 GMT

answered

Re: CSV formatted output

Sandra_Rossi — Thu, 20 Aug 2009 08:28:04 GMT

Hi. Could you just give us a feedback, what were the answers to your questions ?