code for download data into excel .


TYPE-POOLS: truxs.


 TABLES: zregtab.


Parameters: p_file TYPE rlgrap-filename default 'C:\test.xls'.


TYPES: BEGIN OF ty_regtab,
        empid         LIKE zregtab-empid,
        empname       LIKE zregtab-empname,
        technology    LIKE zregtab-technology,
        desgination   LIKE zregtab-desgination,
        mobile        LIKE zregtab-mobile,
        boardingpoint LIKE zregtab-boardingpoint,
        END OF ty_regtab.


DATA:  itab1    TYPE truxs_t_text_data.


 DATA:  itab    TYPE ty_regtab OCCURS 0.


SELECT empid
        empname
        technology
        desgination
        mobile
        boardingpoint
        FROM zregtab
        INTO TABLE itab.


CALL FUNCTION 'SAP_CONVERT_TO_XLS_FORMAT'
   EXPORTING
 *   I_FIELD_SEPERATOR          = ';'
 *   I_LINE_HEADER              =
     I_FILENAME                 = p_file
 *   I_APPL_KEEP                = ' '
   TABLES
     I_TAB_SAP_DATA             = itab
 CHANGING
    I_TAB_CONVERTED_DATA       = itab1.



출처: http://wiki.sdn.sap.com/wiki/display/Snippets/download+data+into+excel+using+fm

Posted by KindKay
,