Regarding Data Migration

Former Member — Wed, 06 Feb 2008 07:49:46 GMT

HI Folks,

I am working on the data migration project.

Please let me few details.

1. Which methods we should use with respect to amount of data and scenario out of BDC, LSMW, Call Transaction method. Means whats are th guideline which we have to follow.

2. BAPI & IDOCS would work for the data migration and what facts we should consider before using the same.

Please reply asap. Any document on this would be appreciated.

Regards,

Akshay Shail

akshay.shail@gmail.com

Re: Regarding Data Migration

Former Member — Wed, 06 Feb 2008 08:53:49 GMT

hi,

SAP Data Migration with LSMW

No ABAP effort are required for the SAP data migration. However, effort are required to map the data into the structure according to the pre-determined format as specified by the pre-written ABAP upload program of the LSMW.

The Legacy System Migration Workbench (LSMW) is a tool recommended by SAP that you can use to transfer data once only or periodically from legacy systems into an R/3 System.

More and more medium-sized firms are implementing SAP solutions, and many of them have their legacy data in desktop programs. In this case, the data is exported in a format that can be read by PC spreadsheet systems. As a result, the data transfer is mere child's play: Simply enter the field names in the first line of the table, and the LSM Workbench's import routine automatically generates the input file for your conversion program.

The LSM Workbench lets you check the data for migration against the current settings of your customizing. The check is performed after the data migration, but before the update in your database.

So although it was designed for uploading of legacy data it is not restricted to this use.

We use it for mass changes, i.e. uploading new/replacement data and it is great, but there are limits on its functionality, depending on the complexity of the transaction you are trying to replicate.

The SAP transaction code is 'LSMW' for SAP version 4.6x.

For those with the older SAP version (4.7 and below), the data migration programs might not have been pre-loaded.

You can download the LSMW at no cost from SAPNet under Services, SAP Methodology and Tools, category Tools.

If you are an existing SAP customer with an OSS ID, you can access the SAP Service Marketplace to download the LSWM for your Basis teams to install to your SAP system: http://service.sap.com/lsmw

The LSM Workbench carries out the following tasks:

Reads the transfer data from one or more files (for example, spreadsheets, sequential files etc.)

Converts the data from the source format into the target format

Data Transfer

When you need to load information into an SAP R/3 system from a legacy system, a set of tools that falls into the Data Transfer catagory are used. Between 3.1H and 4.6C there were major changes in this area of SAP. The old Data Transfer Workbench can be used, or you can combine the new tools with programs that you write to effectively manage a data transfer project. SAP offers The Data Transfer Guidebook www.saplabs.com/dx to help guide users through the process.

Determining when to use Data Transfer technology

Essentially, if Data Transfer technology is not used, the data must be manually entered. Manually entered data will, as a rule, be cleaner and cause fewer problems in the future. A number of factors go into the choice between manual entry of information vs. Data Transfer . Any large group of records (say 2000 or more) will probably need to be automated. Anything less that 2000 can probably be manually input in less time than it will take to write and correctly test a conversion program, convert the data into a QA environment, test and adjust the conversion, then convert the data into your production system.

However, another factor is time available at go-live.

For BAPI's for mass data transfer follow this link

http://help.sap.com/saphelp_nw04/helpdata/en/4c/4c0e8a725311d396a80004ac96334b/frameset.htm

Hope this is helpful, Do reward.

topic Re: Regarding Data Migration in Application Development and Automation Discussions

Regarding Data Migration

Re: Regarding Data Migration

Re: Regarding Data Migration