topic Re: csv format output in Application Development and Automation Discussions

csv format output

Former Member — Wed, 19 Dec 2007 07:41:41 GMT

hi all,

i have a requirement for downloading to csv format when i give it as excell its working fine but when i use csv extension i am gettin all the column in a single column.i want each and every column to be separated that is comma separated.i have used it as folows

CALL FUNCTION 'DOWNLOAD'

EXPORTING

FILENAME = P_FILE

FILETYPE = 'DAT'

TABLES

DATA_TAB = T_T500P

IF SY-SUBRC <> 0.

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

ENDIF.

here ,

p_file i am defining the file path with the extension

t_t500p is my internal table.

Re: csv format output

Former Member — Wed, 19 Dec 2007 07:44:16 GMT

Hi, Abinash,

Use

File Type = 'ASC'

and use

Write_field_separtator = 'X'.

Reward points if use full

Thankz

vinesh.

Re: csv format output

Former Member — Wed, 19 Dec 2007 08:03:50 GMT

I USE THIS I GET DUMP.

Re: csv format output

Former Member — Wed, 23 Jan 2008 06:38:44 GMT

answered