1、 COPY ALSM_EXCEL_TO_INTERNAL_TABLE 为 ZALSM_EXCEL_TO_INTERNAL_TABLE ,并做少许改动即可 2、 定义结构新的返回ZSALSMEX_TABLINE 3、函数输入输出 代码如下(定义与ZEXCEL自定义函数组下,便于代码管理): function zalsm_excel_to_internal_table. *"--- *"*"Local interface: *" IMPORTING *" VALUE(...
用excel上载大数据量的BOM数据到SAP系统中,一次上载的数量级别在10万条左右,这时用ALSM_EXCEL_TO_INTERNAL_TABLE上载时会dump,查看了代码发现ALSM_EXCEL_TO_INTERNAL_TABLE中是将数据先保存到剪贴板(Clippboard )上,然后在保存到内表中,很不幸剪贴板大小有限制,超过就会dump。 2, 问题解决 解决方法比较简单,就是...
* Get EXCEL-Sheet in internal table CALL FUNCTION 'ALSM_EXCEL_TO_INTERNAL_TABLE' EXPORTING filename = p_file i_begin_col = '1' i_begin_row = g_begin_row i_end_col = '11' i_end_row = g_end_row TABLES intern = git_temp EXCEPTIONS inconsistent_parameters = 1 upload_ole = 2 OTH...
修改ALSM_EXC..FM:ALSM_EXCEL_TO_INTERNAL_TABLE 是上载Excel文件的一个函数,但是这个函数有两个限制。一是每个CELL只能导入前50个字符,二是如果超过9999行,行号会初始化为从零
CALL FUNCTION 'ALSM_EXCEL_TO_INTERNAL_TABLE' EXPORTING FILENAME = 'd:\1.xls' I_BEGIN_COL = 1 I_BEGIN_ROW = 1 I_END_COL = 10 I_END_ROW = 10 TABLES INTERN = itab EXCEPTIONS INCONSISTENT_PARAMETERS = 1 UPLOAD_OLE = 2 OTHERS = 3 ...
CALL FUNCTION 'ALSM_EXCEL_TO_INTERNAL_TABLE' EXPORTING FILENAME = 'C:\Documents and Settings\sudhapa\Desktop\xl.XLS' I_BEGIN_COL = B1 I_BEGIN_ROW = C1 I_END_COL = B2 I_END_ROW = C2 TABLES INTERN = ITAB1 EXCEPTIONS INCONSISTENT_PARAMETERS = 1 UPLOAD_OLE = 2 OTHERS = 3. IF SY...
CALL FUNCTION 'ALSM_EXCEL_TO_INTERNAL_TABLE' EXPORTING filename = p_file i_begin_col = 1 i_begin_row = begin_row i_end_col = v_col i_end_row = 65536 TABLES intern = t_file EXCEPTIONS inconsistent_parameters = 1 upload_ole = 2 OTHERS = 3. IF sy-subrc EQ 0. LOOP AT t_file...
call function 'ALSM_EXCEL_TO_INTERNAL_TABLE' exporting filename = l_file_name i_begin_col = 1 i_begin_row = 1 i_end_col = 255 i_end_row = 65536 tables intern = lt_excel exceptions inconsistent_parameters = 1 upload_ole = 2 ...
I was wondering if there is another function module in SAP that functions just like the function module "ALSM_EXCEL_TO_INTERNAL_TABLE". You see, I have a problem with the length of alsmex_tabline since it only has a length of 50. This leaves the data that I plan to use become trunc...
Dear Experts, Why i used ALSM_EXCEL_TO_INTERNAL_TABLE,it occurs error Error analysis Only message types A, E, I, W, S, and X are allowed. Message type "