Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Down load report output from SAP to Excel sheet

Former Member
0 Kudos

Hi,

Actually i am downloading report out into Excel sheet using FM GUI_LOAD. But in this case in Excel sheet we are getting the date format as *3/21/2008. But the requerment is the date format in Excel sheet should be display like 3/21/2008.So please advice me.

Code:

CALL FUNCTION 'GUI_DOWNLOAD'

EXPORTING

filename = w-filename

filetype = 'DBF'

col_select = 'X'

col_select_mask = 'XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX'

wk1_n_format = 'X'

wk1_t_format = 'X'

DAT_MODE = 'X'

TABLES

data_tab = dtab_dat

fieldnames = htab.

Thanks in advance.

Regards,

Satya.

1 REPLY 1

Former Member
0 Kudos

Hi,

Please let me know the type of dtab_dat.

Regards

jana