Use the Function Module "KCD_CSV_FILE_TO_INTERN_CONVERT" to upload data, which is in CSV file type. But, Internal table cann't hold data more than 2 GB, I hope it is not pissible. Regards,SuryaPraveen. Reply andreas_mann3 Active Contributor 2012 Apr 12 7:43 AM 0 Kudos ...
FM ALSM_EXCEL_TO_INTERNAL_TABLE is even worse than FM TEXT_CONVERT_XLS_TO_SAP. If you check structure of table field intern of FM ALSM_EXCEL_TO_INTERNAL_TABLE you will see that VALUE field is 50 characters. define type alsmex_tabline { row : kcd_ex_row_n; col : kcd_ex_col_n...
i_internTYPEty_t_itabUSINGi_separatorTYPEc.DATA:l_sic_tabixLIKEsy-tabix,l_sic_colTYPEkcd_ex_col.DATA:l_fdposLIKEsy-
1、 'TEXT_CONVERT_XLS_TO_SAP'单元格文本不能超过256个字符 CALL FUNCTION 'TEXT_CONVERT_XLS_TO_SAP' EXPORTING i_line_header = 'X' i_tab_raw_data ...
具介们如下:体1、'TEXT_CONVERT_XLS_TO_SAP'们元格文本不能超们256字符个CALLFUNCTION'TEXT_CONVERT_XLS_TO_SAP'EXPORTINGi_line_header='X'i_tab_raw_data=lt_rawi_filename=p_fileTABLESi_tab_converted_data=it_dataEXCEPTIONSconversion_failed=1OTHERS=2.2、'ALSM_EXCEL_TO_INTERNAL_TABLE'们元格文本不...
CALL FUNCTION ‘KCD_CSV_FILE_TO_INTERN_CONVERT’ EXPORTING i_filename = ‘C:\Temp\Upload.csv’ i_separator = ‘,’ TABLES e_intern = gt_intern EXCEPTIONS upload_csv = 1 upload_filetype = 2. Drawbacks a) The file can be read only from presentation server/ desktop. ...
可以通过过函数KCD_CSV_FILE_TO_INTERN_CONVERT将CSV格式的文件上载到本机。 代码如下: REPORT z_upload_csv. TYPE-POOLS: kcde. TYPES: BEGIN OF ty_input, id TYPE string, name TYPE string, place TYPE string, phone TYPE string, END OF ty_input. CONSTANTS: c_separator TYPE c VALUE ','. ...
CSV文件是逗号分隔符格式的文件。将内表数据下载成CSV文件到本机上要先将内表中的数据通过函数SAP_CONVERT_TO_TEX_FORMAT转换成CSV格式,然后再下载到本机。完整代码:REPORT z_download_csv. TYPE-POOLS: truxs. *&---* *& Data Types *&---* TYPES: BEGIN OF ty_spfli, carrid TYPE spfli-carrid, ...
'KCD_EXCEL_OLE_TO_INT_CONVERT' FM to upload data from excel into internal table. 1. CALL FUNCTION 'ALSM_EXCEL_TO_INTERNAL_TABLE' EXPORTING filename = filename i_begin_col = 1 i_begin_row = 1 i_end_col = 3 i_end_row = 65535 TABLES intern = it_vbak. 2. DATA : l_intern TYP...
TEXT_CONVERT_XLS_TO_SAP' SAP_CONVERT_TO_CSV_FORMAT KCD_EXCEL_OLE_TO_INT_CONVERT if the above fm's are not able to solve your problem then you need to save the excel sheet as "tab delimited text file" and then Upload using the GUI_UPLOAD FM. hope it helps regards Aakash Banga Reply...