HR Master data download error

[Former Member]

Dear all,

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'

EXPORTING

FILENAME = fname

filetype = 'ASC'

WRITE_FIELD_SEPARATOR = 'X'

TABLES

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 ....

Thanks

- MK

[Former Member]

Leave write-separator = 'X', but don't put tabs manually into the internal table.

Rob

[Former Member]

Leave write-separator = 'X', but don't put tabs manually into the internal table.

Rob

[Former Member]

Hi Rob,

I have replaced those tab values with place before moving to function module.

still, I am getting the number of records to be less than what is in internal table in xls download.

There are records with genuine errors, which can be corrected.Still it is supposed to give atlease number of records to be accurate one.

Has anyone come across such issue while downloading master records

I appreciate ur help.

Thanks

- M