2010 Mar 25 4:41 AM
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
2010 Mar 25 5:19 AM
Hi,
In Gui_download You can pass write field-seperator = ' , '. No need to use that another FM in this case
Thanks
kishore
2010 Mar 25 5:33 AM
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
2010 Mar 25 6:16 AM
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
2010 Mar 25 9:21 AM
Hi
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