Question

怎么Import文本文件到SAP中

SIL-EM.doc 各位,偶公司之前的系统就可以把文本文件的信息自动导入SC中,做为开一张新的订单,请问在SAP 怎样才能实现呢?

Answer 1

谢谢你的回复!SC就是sales Order,SD模块的销售订单,我们之前的ERP是Navision,我们就把客户 的Order form是电子表格形式用Macro处理，导成文本的形式，再在ERP中做Dataport,直接实现把 文本导入ＥＲＰ中，用户就不需要再输入订单了，可在ＳＡＰ中具体没有实现过，谢谢你的方 法，偶会试一下是否成功．

Answer 2

BDC: ?CALL FUNCTION 'KCD_EXCEL_OLE_TO_INT_CONVERT' ? ?EXPORTING ? ? ?filename ? ? ? ? ? ? ? ?= p_file ? ? ?i_begin_col ? ? ? ? ? ? = 1 ? ? ?i_begin_row ? ? ? ? ? ? = 1 ? ? ?i_end_col ? ? ? ? ? ? ? = 9 ? ? ?i_end_row ? ? ? ? ? ? ? = 1000 ? ?TABLES ? ? ?intern ? ? ? ? ? ? ? ? ?= l_intern ? ?EXCEPTIONS ? ? ?inconsistent_parameters = 1 ? ? ?upload_ole ? ? ? ? ? ? ?= 2 ? ? ?OTHERS ? ? ? ? ? ? ? ? ?= 3. ?LOOP AT l_intern. ? ?MOVE l_intern-col TO l_index. ? ?ASSIGN COMPONENT l_index OF STRUCTURE i_table TO . ? ?MOVE l_intern-value TO . ? ?AT END OF row. ? ? ?APPEND i_table. ? ? ?CLEAR i_table. ? ?ENDAT. ?ENDLOOP. 试验一下

Answer 3

What does "SC" stand for? I believe that this implementation might be quite simple. Just upload your file into an internal table by using any of function modules "UPLOAD", "WS_UPLOAD", "GUI_UPLOAD" etc. Then do whatever is needed from the data of internal table.

Answer 4

Here are two options I can think of so far 1) BDC Find the transaction in SAP for sales order creation, record the procedure(t-code: sm35 or shdb), create a BDC program, and adjust the program by using your data file as input 2) BAPI Find a BAPI for order creation, call the BAPI from outside

Answer 5

Dear shaw,thx for you help,I will try according to your advice.