SAP for Retail Discussions
Join conversations about personalization, omnichannel strategies, and operational excellence in retail using SAP for Retail software.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

How to transfer data from legacy system to SAP

Former Member

‎09-27-2011 2:34 PM

0 Kudos

Hi Friends,

I would like to know the process and the steps followed to transfer data from my legacy system to SAP.

Suppose if i have all the data in the form of Excel sheet or doc type. How can i transfer this data into SAP.

Please explain the steps followed.

Appreciate your help

Anil

3 REPLIES 3

Former Member

‎09-28-2011 6:26 AM

0 Kudos

Hi,

Use LSMW for upload.

Regards

Mohan

Former Member

‎09-28-2011 8:11 AM

0 Kudos

Hi ,

Conversion of legacy data into SAP can be uploaded using a standard SAP Tool called LSMW ( TCode:LSMW).

the below link gives a brief explanation of the LSMW tool

http://tutorialsap.com/abap/sap-lsmw-tutorial-with-steps-to-create.html

There are various methods to upload data within LSMW. If the number of records are very high like Article Master or Conditions for Retail the IDOC method must be used.

Standard IDocs

1. Article Master - ARTMAS

2. Conditions - COND_A

3. Source list - SRCLST

4. Customer Master or WRF3/WRF6 tables - DEBMAS

5. Vendor master- CREMAS

Etc. Use transaction code WE60 to see the structure of each of the idocs. New enhancements can be done for the idocs if the required field is not available.

Regards

Prabhu

Former Member

‎09-28-2011 2:48 PM

0 Kudos

Thanks Prabhu and Mohan,

I will proceed as you suggested and get back to you if i have any doubts.

Anil