08-22-2007 10:23 AM
Hi
I am trying to download ALV report into a excel file using GUI_DOWNLOAD function module. I have a issue when downloading date into excel say 07/07/2007 is downloading as 7/7/2007 because of this the uploading the same file is giving error.
SAP experts pls help me in resolving this.
Thanks in advance.
Regards
Sam
08-22-2007 10:26 AM
Hi Sam,
If you are uploading the file into ABAP system, then you could download dates in SY-DATUM form.
For ex. 07/07/2007 as 20070707.
Then when u dwnload the file, this unchanged then when uploading back you should not face any problem.
Thanks..
preetham S
08-22-2007 10:41 AM
I would suggest you to use ALV_XXL_CALL if your want to keep your data formats intact.
like this - CALL FUNCTION 'ALV_XXL_CALL'
EXPORTING
i_tabname = 'T_GRID' " Name of your internal table
it_fieldcat = t_fcatk[] "Your LAV grids catalog.
TABLES
it_outtab = t_grid "Internal table itself
EXCEPTIONS
fatal_error = 1
no_display_possible = 2
OTHERS = 3.
IF sy-subrc <> 0.
MESSAGE e806(bk).
ENDIF.
hope it helps.