topic Re: Complex Customer Master in Application Development and Automation Discussions

Complex Customer Master

Former Member — Wed, 27 Jun 2007 05:13:32 GMT

Hi Gurus

I have more than 10000 customers and is in legacy system. Now my challenge is to bring to SAP system. I will have to use LSMW for this.

What all the points should I keep noting or focussed.

Please give your valuable suggestions

Regards

Suddu

SD functional consultant

Re: Complex Customer Master

Former Member — Wed, 27 Jun 2007 08:55:02 GMT

Dear Suddu,

Visit the following link:

For information regarding LSMW steps visit the following link:

/people/hema.rao/blog/2006/09/14/lsmw--step-by-step

http://help.sap.com/bp_blv1500/BL_US/html/dataconv_lsmw.htm

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

Note that with background processing, the input file must not be located in the presentation server. Access to presentation server files is only possible when you are working online.

Hope this will help.

Regards,

Naveen.

Re: Complex Customer Master

Former Member — Wed, 27 Jun 2007 14:41:33 GMT

Thank you Naveen

Could you please send a document with a test case, by replying to this thread or to my email id sudduval@yahoo.com

Points have been rewarded to you..

Thanks

Suddu

Re: Complex Customer Master

Former Member — Wed, 27 Jun 2007 14:41:54 GMT

Thank you Naveen

Points rewarded

Re: Complex Customer Master

Former Member — Thu, 28 Jun 2007 07:00:32 GMT

Dear Suddu,

Test case will cover all the possible exception situations and success situation. They could be like:

1. What is the error that you are going to get if you doesn't pass a mandatory field. (Field XXX is missing or Enter value for field XXX or Field XXX is mandatory etc.)

2. What is the error that if you pass wrong value to a particular field that would be validated while loading the data. (Example if you had passed that G/L Account number that does not exist. It would say that G/L Account XXX does not exist.)

3. What happens if you pass correct data. (Message :Vendor XXX is created successfully etc.)

Regards,

Naveen.

Re: Complex Customer Master

Former Member — Mon, 23 Jul 2007 06:37:31 GMT

LSMW has a limitation of creating not more then 5000 records at a shot.