Answer / ganga

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.

Answer / naveen jakhar

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.
You can have a look at the example of an upload data format
for the Condition Pricing for Sales Order.


You can create lsmw for data migration as follows (using
session method):

Example for xk01 (create vendor)
Initially there will be 20 steps but after processing 1
step it will reduced to 14 for session method.

1. TCode : LSMW.
2. Enter Project name, sub project name and object name.
Execute.
3. Maintain object attributes.
Execute
select Batch Input recording
goto->Recording overview
create
recording name.
enter transaction code.
start recording
do recording as per ur choice.
save + back.
enter recording name in lsmw screen.
save + back

Now there will be 14 steps.
2. MAINTAIN SOURCE STRUCTURES.
Here you have to enter the name of internal table.
display change
create
save + back

3. MAINTAIN SOURCE FIELDS.
display change
select structure
source_fields->copy fields.
a dialogue window will come .
select -> from data file
apply source fields
enter No. of fields
length of fields
attach file
save + back

4. MAINTAIN STRUCTURE RELATIONS
display change
save + back

5. MAINTAN FIELD MAPPING & CONVERSION RULE
display change
click on source field, select exact field from structue
and enter
repeat these steps for all fields.
save+back

6. MAINTAIN FIXED VALUES, TRANSACTION, USER DEFINED
execute
save + back

7. SPECIFY FILES.
display change
click on legacy data
attah flat file
give description
select tabulatore
enter
save + back

8. ASSIGN FILE
execute
display change
save + back

9. IMPORT DATA.
execute
display change
save + back

10. DISPLAY IMPORTED DATA
enter ok, it willl show records only.
back

11. CONVERT DATA
execute
display change
save + back

12. DISPLAY CONVERTED DATA
execute
display change
save + back

13. CREATE BATCH INPUT SESSION
tick keep batch input folder
F8
back

14. RUN BATCH INPUT SESSION.
sm35 will come
Object name will be shown here
select object & process

Answer / anupa

Legacy System Migration Workbench (LSMW) is a SAP tool which
you can use to transfer data into an R/3 System.

This method is very widely used during cut-over, to transfer
legacy system data in to SAP. You can use same to do any
changes to existing data in SAP system as well.

Eg: If you want to change any field value in the material
master, you can download those data from the table in to an
Excel file. Then you can change relevant values in the Excel
sheet. After that using a LSMW, you can write new values
back to SAP.

Below document will explain you on how to create a sample
LSMW. Based on those steps, you should be able to create
your own LSMW.

check below link for more information on How to create a LSMW.

http://learnsaptips.blogspot.com/2010/08/how-to-create-sample-lsmw.html

What is Material Document & Accounting Document in SAP MM.......

0 Answers  

---

Have got 6+ yrs of work experience in CAE/CFD. NOw i am planning to change my career to SAP MM . Kindly guide me on this how to go about it. I have already joined for SAP MM training. Kindly guide me weather i can put some fake experience and apply for the job or i can apply as a fresher with SAP MM. Thanks for the information in advance. Avi

2 Answers  

---

what is exclusion indicator in condition type?

5 Answers   IBM,

---

What are the levels at which a batch number can be configured?

0 Answers  

---

Q. What is GR blocked stock? When it can be used? Q. How do you plan for a vendor rating system and move about? Q. How do you make variants? Q. How to inventory excise duty in SAP? Q. What is meant by consignment stock? Q. What are the steps in automatic account assignment configuration? Q. Tell me about the subcontracting cycle. Q. What is meant by batches? How can the batches be searched? Q. What is meant by MRP Type and lot sizing? Q. Is it possible to have scales in a quotation? Q. How are the variations in subcontracting taken care of in SAP? Q. How is an item with serial no. managed? Q. What are the types of tables in SAP? Q. What are the documents generated in the MIGO 101 movement type? What are the accounts hit? Q. Can it be configured in such a way that the external requisitions can also be taken into account while MRP runs in consumption-based planning if VB is selected as MRP type? Q. Can anyone give an overview on Account Determination? Q. WHAT R ALL THE LEVELS INFORECORDS R MAINTAINING? Q. What is difference between "terms of payment" and "payment terms" Fields are available in vendor master purchasing view and accounting view respectively. System can take two different values for same vendor? Why different values are maintained? Q. Can any one explain the following in length ACCOUNT MODIFIERS, SPLIT VALUATION, VARIANCES, TRANSACTION EVENT KEY? Explanation with an example would help me a lot. Q. A P.O has 50 items all the 50 items have the same price. Instead of entering the price for each item 50 times is there any option in SAP where the common price can be entered in one go? Q. Can anyone describe the batch management process? Q. What are the steps involved in creating a pricing procedure? Q. How is scrap accounted in subcontracting? Q. How does the system calculate taxes? Q. What is meant by MRP Type and lot sizing? Q. What is a reference purchase organization? When can it be used? Q. Explain the concept of split valuation and when can it be used? What are the settings required? Q. What are valuation area, valuation category and valuation class? Q. What is meant by a credit memo? Q. What is meant by a release strategy? Q. What are the tools available for data migration in SAP? Q. What is LSMW? Q. What is the difference between LSMW and CATT? Q. How do you plan for a vendor rating system and move about? Q. I am doing sap mm, i have a question, do consultants copy n save from sap std.1000 in real time too? Q. What is float purchase organization? Q. How many finance documents will system generates when goods receipt from subcontracting made? Q. How we create a new material type and how to assign G/L account to it? Q. How we will differentiate a STO and a standard purchase order with a glance? Q. What is the difference between BSX and BSA? Q. If suppose i m giving sample to store to quality and after one day this stock is unrestricted then quality people wants take another sample on same material suppose stock was 100 kg n in quality i was giving them 1 kg then after a day 99 kg was unrestricted ok, then they decided wants to need another sample 1 kg then what i m doing so pls tell me with transaction code??? Q. How to give another test sample to quality on same material after few days? Please tell me with transaction code???? Q. How a support individual will receive Tickets/issues from client? Q. wht is the diff between partner function and partner type? Q. wht is the use of account modifier in automatic account determination? Q. in stock detrmination.wht is header table and item table? Q. whr in inforecord you can see the quantum price? Q. What is Diffrance Between Batch No. & Serial No.

1 Answers  

---

what is material type PIPE and xplain with example

3 Answers   Bristle Cone,

---

How will you configure a class type?

0 Answers  

---

In subcontracting Process once materials is delivered by vendor and if the material has to be sent back to vendor whatis the Procedure? If the company is in bangalore and vendor in Mumbai what are the documents needed for return?

4 Answers   Cap Gemini,

---

What is meant by batches?

0 Answers  

---

Can we have release procedure without classification for a po?

0 Answers  

---

HOW TO CHANGE CONVERSION FACTOR AFTER MADE GRN.

1 Answers  

---

Do we include sub-contracting stock (material provided to vendor) in physical inventory? Why?

1 Answers  

---