topic Re: CSV dump in Application Development and Automation Discussions

CSV dump

Former Member — Thu, 25 Mar 2010 04:41:45 GMT

Hi experts,

I have an internal table with 9 fields ( emp no,emp bank ac no, blank1,blank2,blank3, amount,blank4,blank5, empname). The fields blank1,blank2,blank3,blank4,blank5 would be empty fields without values. I want this table to convert to CSV file and dump it on the desktop. I have used SAP_CONVERT_TO_CSV_FORMAT to convert the table in CSV format with all the 9 fields.

then i have used GUI_download to create dump on the desktop but when i open the file with excel it shows semicolon in between each field and the blank fields are also not showing

Regards

Farkankhud

Re: CSV dump

Former Member — Thu, 25 Mar 2010 05:19:53 GMT

Hi,

In Gui_download You can pass write field-seperator = ' , '. No need to use that another FM in this case

Thanks

kishore

Re: CSV dump

Former Member — Thu, 25 Mar 2010 05:33:50 GMT

Hi,

In Gui_download You can pass write field-seperator = ' , '. No need to use that another FM in this case.

Then the dump will come to tab delimited file. After that can save the as (.CSV) file.

Thanks

kishore

Re: CSV dump

Former Member — Thu, 25 Mar 2010 06:16:11 GMT

Thanks Kishore,

I have looped through the internal table to concatenate each row appended to a string type internal table separated by ','.

then i passed this string type table to gui_download to get the desired result

Re: CSV dump

Former Member — Thu, 25 Mar 2010 09:21:39 GMT

I have to find out the month in words and year by keying in period and year. For example if i put period 03 and year 2010

then it should throw back June 2010. Is there any standard function module availabe