SAP 内表数据导出到EXCEL的几种方法示例

方法一：函数GUI_DOWNLOAD

1. 代码

DATA: lt_itab TYPE TABLE OF sflight.

TYPES: BEGIN OF ty_fieldname,
      name TYPE char20,
      END OF ty_fieldname.

DATA: lt_fieldname TYPE TABLE OF ty_fieldname WITH HEADER LINE.

 SELECT * FROM sflight INTO TABLE lt_itab UP TO 30 ROWS.

 PERFORM frm_set_fieldname USING'Client'.
 PERFORM frm_set_fieldname USING'航线代码'.
 PERFORM frm_set_fieldname USING'航班连接编号'.
 PERFORM frm_set_fieldname USING'航班日期'.
 PERFORM frm_set_fieldname USING'航空运费'.
 PERFORM frm_set_fieldname USING'航班的本地货币 '.
 PERFORM frm_set_fieldname USING'飞机类型'.
 PERFORM frm_set_fieldname USING'经济舱的最大容量 '.
 PERFORM frm_set_fieldname USING'占据的经济舱座位'.
 PERFORM frm_set_fieldname USING'当前预定总数'.
 PERFORM frm_set_fieldname USING'商务舱的最大容量 '.
 PERFORM frm_set_fieldname USING'占据的商务舱座位'.
 PERFORM frm_set_fieldname USING'头等舱的最大容量 '.
 PERFORM frm_set_fieldname USING'占据的头等舱座位'.

 CALL FUNCTION 'GUI_DOWNLOAD'
  EXPORTING
*   BIN_FILESIZE                    =
    FILENAME                        = 'C:\Users\Administrator\Desktop\123.xls'
    FILETYPE                        = 'DAT' "ASC格式 1000- 不会显示为 -1000 DBF格式 字符前空格 前导0不会显示
*   APPEND                          = ' '
*   WRITE_FIELD_SEPARATOR           = ' '
*   HEADER                          = '00'
*   TRUNC_TRAILING_BLANKS           = ' '
*   WRITE_LF                        = 'X'
*   COL_SELECT                      = ' '
*   COL_SELECT_MASK                 = ' '
*   DAT_MODE                        = ' '
*   CONFIRM_OVERWRITE               = ' '
*   NO_AUTH_CHECK                   = ' '
    CODEPAGE                        = '8404' "四位字符集代码 可通过表TCP00A，查询对应字符集代码
*   IGNORE_CERR                     = ABAP_TRUE
*   REPLACEMENT                     = '#'
*   WRITE_BOM                       = ' '
*   TRUNC_TRAILING_BLANKS_EOL       = 'X'
*   WK1_N_FORMAT                    = ' '
*   WK1_N_SIZE                      = ' '