03-25-2010 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
03-25-2010 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
03-25-2010 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
03-25-2010 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
03-25-2010 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