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(...
修改ALSM_EXC..FM:ALSM_EXCEL_TO_INTERNAL_TABLE 是上载Excel文件的一个函数,但是这个函数有两个限制。一是每个CELL只能导入前50个字符,二是如果超过9999行,行号会初始化为从零
用excel上载大数据量的BOM数据到SAP系统中,一次上载的数量级别在10万条左右,这时用ALSM_EXCEL_TO_INTERNAL_TABLE上载时会dump,查看了代码发现ALSM_EXCEL_TO_INTERNAL_TABLE中是将数据先保存到剪贴板(Clippboard )上,然后在保存到内表中,很不幸剪贴板大小有限制,超过就会dump。 2, 问题解决 解决方法比较简单,就是...
CALL FUNCTION 'TEXT_CONVERT_XLS_TO_SAP' EXPORTING * I_FIELD_SEPERATOR = i_line_header = 'X' i_tab_raw_data = it_raw " WORK TABLE i_filename = filename TABLES i_tab_converted_data = itab[] "ACTUAL DATA EXCEPTIONS conversion_failed = 1 OTHERS = 2. IF sy-subrc <> 0. MESSAGE ...
求助:ALSM_EX..万能的abaper,请问:ALSM_EXCEL_TO_INTERNAL_TABLE读取excel时候,执行到CALL METHOD OF workbook 'Open' EXPORTING #1 = filename.时报错,sy-subrc=2,求各位大神解惑大概率是Foxit reader的问题
1, 问题描述 用excel上载大数据量的BOM数据到SAP系统中,一次上载的数量级别在10万条左右,这时用ALSM_EXCEL_TO_INTERNAL_TABLE上载时会dump,查看了代码发现ALSM_EXCEL_TO_INTERNAL_TABLE中是将数
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 = file_nm i_begin_col = '1' i_begin_row = '2' i_end_col = '10' i_end_row = '35' TABLES intern = it_tab EXCEPTIONS inconsistent_parameters = 1 upload_ole = 2 OTHERS = 3. IF sy-subrc <> 0. MESSAGE ID sy-ms...
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...
Solved: CALL FUNCTION 'ALSM_EXCEL_TO_INTERNAL_TABLE' EXPORTING filename = filename i_begin_col = '1' i_begin_row = '1' i_end_col = '200' i_end_row = '5000' TABLES intern