SAP EXCEL导入限制修改.docxVIP

SAP EXCEL导入限制修改关于Excel上载限制修改，SAP提供Excel上载文件的一个函数：ALSM_EXCEL_TO_INTERNAL_TABLE，但此函数有两个限制。一：每个CELL只能导入50个字符；二：如果超过9999行，行号会初始化为零开始。解决此问题，只需要修改结构ALSMEX_TABLINE的字段，然后COPY ALSM_EXCEL_TO_INTERNAL_TABLE为ZALSM_EXCEL_TO_INTERNAL_TABLE，并做少许改动即可。第一步：COPY ALSMEX_TABLINE为ZALSMEX_TABLINE修改其字段类型：第二步：COPY ALSM_EXCEL_TO_INTERNAL_TABLE为ZALSM_EXCEL_TO_INTERNAL_TABLE并第三步：将COPY出来的代码添加如下代码并激活。下面为EXCEL导入的简单示例：REPORT??ZTEMPRO3.*----------------------------------------------------------------------**??????TABLE*----------------------------------------------------------------------*TABLES:?ZISS_CO_006.*----------------------------------------------------------------------**??????TYPE-POOLS*----------------------------------------------------------------------**----------------------------------------------------------------------**??????TYPE*----------------------------------------------------------------------*TYPES:??BEGIN?OF?TYP_UPLOAD,????RYEAR?TYPE?STRING,????POPER?TYPE?STRING,????BUKRS?TYPE?STRING,????RACCT?TYPE?STRING,????FKBER?TYPE?STRING,????LINETYPE?TYPE?STRING,????HSL?TYPE?STRING,??END?OF?TYP_UPLOAD.*----------------------------------------------------------------------**??????INTERNAL?TABLE*----------------------------------------------------------------------***----?INTERNAL?TABLE?----**DATA:?IT_UPLOAD?TYPE?STANDARD?TABLE?OF?TYP_UPLOAD.DATA:?IT_OUTPUT?LIKE?STANDARD?TABLE?OF?ZISS_CO_006?WITH?HEADER?LINE.**----?HEADER?----**DATA:?WA_UPLOAD?TYPE?TYP_UPLOAD.*----------------------------------------------------------------------**??????WORKS*----------------------------------------------------------------------**----------------------------------------------------------------------**??????DATA*----------------------------------------------------------------------*DATA:?ITAB?TYPE?STANDARD?TABLE?OF?ZALSMEX_TABLINE?WITH?DEFAULT?KEY.*----------------------------------------------------------------------**??????CONSTANTS*--------------------------------------------------------------------