Data Transfer - What is the Best Way?

Logistics : MM and its sub-modules (WM, IM, PO, LIS)

Moderators: Snowy, thx4allthefish, Ha Tran, svetja

Post Reply
Guest 77

Data Transfer - What is the Best Way?

Post by Guest 77 » Tue May 13, 2003 2:00 pm

Hi all,

Could you please advise me on what is the best way to transfer data (materials) from the legacy system to SAP (4.6d)? I know there are many way to do that, but what is the most efficient, do you think?

Any help will be appreciated.

Thank you,
Guest 77

blue_forget

Data Transfer Method

Post by blue_forget » Wed May 14, 2003 1:30 am

As far as I know,
1. BDC programming( including batch input, call transaction, direct input ): you should use t-code:shdb to record , then you could write your own program accoring to that record. Still, SAP could generate the program or function from that recording for you automotically.

2. Standard data transfer program. SAP provide lots of standard data transfer program such as customer data, material master, puchase order etc, but for using those st programs, you have to write programs to transfer yours file format to the standard format that program requires. For example, you can use standard batch input program rfbide00 to transfer customer data.

3. Data Transfer Workbench - the tool provided by SAP to transfer data, sorry for forgetting its t-code. You can get more detail information about standard data transfer program and data transfer workbench etc from the "Data Transfer Made Easy" - writed by SAPlabs.com and instead of free lunch, they started to claim for those made-easy books some time ago.

4. LSMW - Legacy System Migration Workbench, an excellent tool which could be downloaded from "service.sap.com/lsmw". Also, there are enough training and implemention materials available could be downloaded. It is very easy to install, just a step-by-step process, but you have to be a SAP administrator for installing since it is just an add-on of SAP system transported by TP. It contains 14 steps and all u have to do is just follow those step. Very easy, no programming.

5. BAPI - business API. Just as windows API, it is none others but RFC function module. Unlike BDC in which you have to first record screen by screen, in the case of BAPI you just fill up the data in the internal tables
accordingly and calls the BAPI and this BAPI directly calls the SAP
standard application function modules directly. This way you are eliminating all the screen sequences. You can get the better performance. Another advantage when using BAPI is just when your system upgrade, you needn't change your programe based on bAPI, but maybe you have to change the one based on BDC since it is possible that the screen recorded changed after upgrading.

6. IDOC-Intermediate Document: it is a standard file format of SAP for data transfer. That's, all SAP data, no matter master data(material master, customer master, vendor etc ), custom data ( plant, storage location, sales organiation etc ) or transaction data(purchase order, sales order, transfer order, packing list etc) have their IDOC format to represent their content. Some interface SAP technology,such as EDI, ALE,generally are based on IDOC. So, it could be used to transfer data between SAP systems or between SAP and other system. Furthermore, LSMW support IDOC. In fact, IDOC is very useful in various technology like business connector, data transfer, ALE etc.

7. CATT: Computer Adid Test Tool, t-code: SCAT, also based on recording, it is a standard test tool but could be used as data transfer as well. Its disadvantage compared with LSMW is that it don't support field mapping and convention which often very critical when transfering between legacy system and SAP. Futhermore, CATT don't fit for the case when data amount is very huge.

Does anyone have other good method for data transfer ?

Guest 77

Post by Guest 77 » Thu May 22, 2003 7:42 am

Thank you so much for your detailed response and for the link to LSMW. I think these are all available methods for data transfer...

Sincerely,
Alex

Guest

Re: Data Transfer Method

Post by Guest » Fri May 23, 2003 8:44 am

[4. LSMW - Legacy System Migration Workbench, an excellent tool which could be downloaded from "service.sap.com/lsmw". Also, there are enough training and implemention materials available could be downloaded. It is very easy to install, just a step-by-step process, but you have to be a SAP administrator for installing since it is just an add-on of SAP system transported by TP. It contains 14 steps and all u have to do is just follow those step. Very easy, no programming.
but I can't find the documentation on how to use this ... could you help please.

Thank You!

Guest 77

Post by Guest 77 » Fri May 23, 2003 12:30 pm

The documentation is available at sap.service.com/lsmw. There is an 80-pages long document with detailed description of the tool.

Alex

Post Reply