Upload file(*.txt, *.csv, *.xls)

在SAP我们经常会用到*.txt, *.csv, *.xls三种文件格式

*.TXT

1. 一般用GUI_UPLOAD来处理, 请看下面的例子:

TYPES: BEGIN OF ty_luke,
  key1 TYPE zluke-key1,
  year1 TYPE zluke-year1,
  month1 TYPE zluke-month1,
  test TYPE zluke-test,
  END OF ty_luke.

DATA: lw_luke TYPE ty_luke,
      lt_luke TYPE STANDARD TABLE OF ty_luke.

DATA: lv_file TYPE string VALUE 'D:\ZZERO2.TXT'.

CALL FUNCTION 'GUI_UPLOAD'
  EXPORTING
    filename            = lv_file
    filetype            = 'ASC'
    has_field_separator = 'X'
  TABLES
    data_tab            = lt_luke
  EXCEPTIONS
    file_open_error     = 1
    file_read_error     = 2
    OTHERS              = 3.

IF sy-subrc <> 0.
* MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO
*         WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.
ENDIF.

BREAK-POINT ID z_zero_test.

2. 这是upload的文件

<