Skip to Content
avatar image
Former Member

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Aug 22, 2007 at 09: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

    Add comment
    10|10000 characters needed characters exceeded

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