上传excel到SAP内表.doc

*&-------------------------------------------------------------------

--*

*&ReportZ_BARRY_UPLOAD_EXCEL

*&

*&-------------------------------------------------------------------

--*

*&

*&

col2(30)TYPEc,

col3(30)TYPEc,

ENDOFt_datatab.

DATA:it_datatabTYPESTANDARDTABLEOFt_datatab,

wa_datatabTYPEt_datatab.

DATA:it_rawTYPEtruxs_t_text_data.

PARAMETERS:p_fileTYPErlgrap-filename.

ATSELECTION-SCREENONVALUE-REQUESTFORp_file.

CALLFUNCTION'F4_FILENAME'

EXPORTING

*I_FIELD_SEPERATOR=

i_line_header='X'

i_tab_raw_data=it_raw

i_filename=p_file

TABLES

i_tab_converted_data=it_datatab[]

EXCEPTIONS

conversion_failed=1

OTHERS=2.

IFsy-subrc<>0.