I am trying to download HR Master data using FM gui_download.
In case of downaloading all staff data, I am getting incorrect no
of records in xls file though no of records internal table is accurate.
Also some of the records values are corrupt or incorrupt values.
As analysed , when any value in a record ends with '#' as mentioned below, It is already considered as TAB separtion,thus
ends with incorrect values in certain records
CALL FUNCTION 'GUI_DOWNLOAD'
FILENAME = fname
filetype = 'ASC'
WRITE_FIELD_SEPARATOR = 'X'
DATA_TAB = table.
When I try with ' '( space ) as the separator in this FM , number of records are correct ,but not spread across in respective columns. I need to download in xls file with tab separation....
I appreciate your suggestion on this ....