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
'SAP > ABAP' 카테고리의 다른 글
| Table to read PO Header text and item text (0) | 2013.07.19 |
|---|---|
| BAPI_CURRENCY_CONV_TO_EXTERNAL (0) | 2013.07.05 |
| FI_document_read_single (0) | 2013.07.05 |
| XI Error - Error during proxy processing Message E W5 101 cannot be processed in plugin mode HTTP (0) | 2013.06.11 |
| SMW0 양식 다운로드 (0) | 2013.05.14 |



