topic Re: Fields separated by comma using GUI_DOWNLOAD in Application Development and Automation Discussions

Fields separated by comma using GUI_DOWNLOAD

Former Member — Mon, 18 Aug 2008 10:06:53 GMT

Hi All,

I want to download internal table data separated by comma.

I am using GUI_DOWNLOAD function module.

I am using separator as comma,but still the data is getting downloaded as Tab delimited.

Please let me know what needs to be done.

Thanks,

Edited by: Mike Pokraka on Aug 18, 2008 3:09 PM

Re: Fields separated by comma using GUI_DOWNLOAD

narin_nandivada3 — Mon, 18 Aug 2008 10:09:06 GMT

Hi,

Please check this solved thread

This would solve your issue.

Good luck

Narin

Re: Fields separated by comma using GUI_DOWNLOAD

Former Member — Tue, 19 Aug 2008 07:38:36 GMT

Hi,

Check this sample code,

TYPES:
  BEGIN OF type_itab1,
    string TYPE string,
  END OF type_itab1.

DATA:
  BEGIN OF itab OCCURS 0,
    vbeln  LIKE vbap-vbeln,
    posnr  LIKE vbap-posnr,
  END OF itab.

DATA:
   wa_itab TYPE type_itab1,
   itab1   TYPE STANDARD TABLE OF type_itab1.

SELECT vbeln
       posnr
    UP TO 5 ROWS
  FROM vbap
  INTO TABLE itab.

SORT itab.

DELETE ADJACENT DUPLICATES FROM itab COMPARING ALL FIELDS.

LOOP AT itab.
  CONCATENATE itab-vbeln
              itab-posnr
         INTO wa_itab-string
         SEPARATED BY ','.
  APPEND wa_itab TO itab1.
ENDLOOP.

CHECK sy-subrc EQ 0.

CALL METHOD CL_GUI_FRONTEND_SERVICES=>GUI_DOWNLOAD
EXPORTING
FILENAME = 'D:\temp\test.txt'
WRITE_FIELD_SEPARATOR = ','
FILETYPE = 'ASC'
CHANGING
DATA_TAB = itab1.

Regards

Adil

Re: Fields separated by comma using GUI_DOWNLOAD

Former Member — Tue, 19 Aug 2008 09:02:39 GMT

CALL FUNCTION 'GUI_DOWNLOAD'

EXPORTING

BIN_FILESIZE =

filename = p_file_temp

filetype = 'DBF'

append = space

write_field_separator = ','

TABLES

data_tab = i_final_data

Pls try this

Re: Fields separated by comma using GUI_DOWNLOAD

Former Member — Tue, 19 Aug 2008 10:19:24 GMT

pass the value in

write_field_separator = ','

Re: Fields separated by comma using GUI_DOWNLOAD

Former Member — Thu, 04 Sep 2008 10:41:50 GMT