Date Format incorrect when downloading the content of ALV to Excel file

[Former Member]

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

[Former Member]

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

[Former Member]

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.