What is LSMW?

Answers were Sorted based on User's Feedback



What is LSMW?..

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.

Is This Answer Correct ?    67 Yes 3 No

What is LSMW?..

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

Is This Answer Correct ?    41 Yes 3 No

What is LSMW?..

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

Is This Answer Correct ?    11 Yes 1 No

Post New Answer

More SAP MM (Material Management) Interview Questions

How to give specifications for developments?

1 Answers  


What is the step by step process in MRP

3 Answers   HP, Pesticides,


why split valuation is only used along with the moving average price? why standard price is not used ? reasons?

4 Answers   Wipro,


What is material length & What is the maximum linit to define it?

6 Answers   Accenture,


Hai brothers, i have done b.Tech(Eee)In 2007..Now i have 6 years of gap....Now i am planning to learn sap..... Can u pls suggest me which sap-module suits to me...Pls help me bro.S? Waiting for ur replies?

3 Answers  






How are the consignment stocks created?

0 Answers  


what is the difference bet standard & reference purchasing organisation

1 Answers   WebTech,


How are the variations in subcontracting taken care of in SAP?

2 Answers  


What is LSMW?

3 Answers  


What is the movement type used in receipt of RTP?

9 Answers  


Explain mrp type

0 Answers  


How do you display a list of all reservations in the system?

0 Answers  


Categories
  • SAP Basis Interview Questions SAP Basis (1262)
  • SAP ABAP Interview Questions SAP ABAP (3939)
  • SAPScript Interview Questions SAPScript (236)
  • SAP SD (Sales & Distribution) Interview Questions SAP SD (Sales & Distribution) (2716)
  • SAP MM (Material Management) Interview Questions SAP MM (Material Management) (911)
  • SAP QM (Quality Management) Interview Questions SAP QM (Quality Management) (99)
  • SAP PP (Production Planning) Interview Questions SAP PP (Production Planning) (523)
  • SAP PM (Plant Maintenance) Interview Questions SAP PM (Plant Maintenance) (252)
  • SAP PS (Project Systems) Interview Questions SAP PS (Project Systems) (138)
  • SAP FI-CO (Financial Accounting & Controlling) Interview Questions SAP FI-CO (Financial Accounting & Controlling) (2766)
  • SAP HR (Human Resource Management) Interview Questions SAP HR (Human Resource Management) (1180)
  • SAP CRM (Customer Relationship Management) Interview Questions SAP CRM (Customer Relationship Management) (432)
  • SAP SRM (Supplier Relationship Management) Interview Questions SAP SRM (Supplier Relationship Management) (132)
  • SAP APO (Advanced Planner Optimizer) Interview Questions SAP APO (Advanced Planner Optimizer) (92)
  • SAP BW (Business Warehouse) Interview Questions SAP BW (Business Warehouse) (896)
  • SAP Business Workflow Interview Questions SAP Business Workflow (72)
  • SAP Security Interview Questions SAP Security (597)
  • SAP Interfaces Interview Questions SAP Interfaces (74)
  • SAP Netweaver Interview Questions SAP Netweaver (282)
  • SAP ALE IDocs Interview Questions SAP ALE IDocs (163)
  • SAP Business One Interview Questions SAP Business One (110)
  • SAP BO BOBJ (Business Objects) Interview Questions SAP BO BOBJ (Business Objects) (388)
  • SAP CPS (Central Process Scheduling) Interview Questions SAP CPS (Central Process Scheduling) (14)
  • SAP GTS (Global Trade Services) Interview Questions SAP GTS (Global Trade Services) (21)
  • SAP Hybris Interview Questions SAP Hybris (132)
  • SAP HANA Interview Questions SAP HANA (700)
  • SAP PI (Process Integration) Interview Questions SAP PI (Process Integration) (113)
  • SAP PO (Process Orchestration) Interview Questions SAP PO (Process Orchestration) (25)
  • SAP BI (Business Intelligence) Interview Questions SAP BI (Business Intelligence) (174)
  • SAP BPC (Business Planning and Consolidation) Interview Questions SAP BPC (Business Planning and Consolidation) (38)
  • SAP BODS (Business Objects Data Services) Interview Questions SAP BODS (Business Objects Data Services) (49)
  • SAP BODI (Business Objects Data Integrator) Interview Questions SAP BODI (Business Objects Data Integrator) (26)
  • SAP Ariba Interview Questions SAP Ariba (9)
  • SAP Fiori Interview Questions SAP Fiori (45)
  • SAP EWM (Extended Warehouse Management) Interview Questions SAP EWM (Extended Warehouse Management) (58)
  • Sap R/3 Interview Questions Sap R/3 (150)
  • SAP FSCM Financial Supply Chain Management Interview Questions SAP FSCM Financial Supply Chain Management (101)
  • SAP WM (Warehouse Management) Interview Questions SAP WM (Warehouse Management) (31)
  • SAP GRC (Governance Risk and Compliance) Interview Questions SAP GRC (Governance Risk and Compliance) (64)
  • SAP MDM (Master Data Management) Interview Questions SAP MDM (Master Data Management) (0)
  • SAP MRS (Multi Resource Scheduling) Interview Questions SAP MRS (Multi Resource Scheduling) (0)
  • SAP ESS MSS (Employee Manager Self Service) Interview Questions SAP ESS MSS (Employee Manager Self Service) (13)
  • SAP CS (Customer Service) Interview Questions SAP CS (Customer Service) (0)
  • SAP TRM (Treasury and Risk Management) Interview Questions SAP TRM (Treasury and Risk Management) (0)
  • SAP Web Dynpro ABAP Interview Questions SAP Web Dynpro ABAP (198)
  • SAP IBP (Integrated Business Planning) Interview Questions SAP IBP (Integrated Business Planning) (0)
  • SAP OO-ABAP (Object Oriented ABAP) Interview Questions SAP OO-ABAP (Object Oriented ABAP) (70)
  • SAP S/4 HANA Finance (Simple Finance) Interview Questions SAP S/4 HANA Finance (Simple Finance) (143)
  • SAP FS-CD (Collections and Disbursements) Interview Questions SAP FS-CD (Collections and Disbursements) (0)
  • SAP PLM (Product Lifecycle Management) Interview Questions SAP PLM (Product Lifecycle Management) (0)
  • SAP SuccessFactors Interview Questions SAP SuccessFactors (33)
  • SAP Vistex Interview Questions SAP Vistex (0)
  • SAP ISR (IS Retail) Interview Questions SAP ISR (IS Retail) (28)
  • SAP IdM (Identity Management) Interview Questions SAP IdM (Identity Management) (0)
  • SAP IM (Investment Management) Interview Questions SAP IM (Investment Management) (0)
  • SAP UI5 Interview Questions SAP UI5 (59)
  • SAP SCM (Supply Chain Management) Interview Questions SAP SCM (Supply Chain Management) (51)
  • SAP XI (Exchange Infrastructure) Interview Questions SAP XI (Exchange Infrastructure) (49)
  • SAP Cloud Platform Interview Questions SAP Cloud Platform (34)
  • SAP Testing Interview Questions SAP Testing (89)
  • SAP SolMan (Solution Manager) Interview Questions SAP SolMan (Solution Manager) (63)
  • SAP MaxDB Interview Questions SAP MaxDB (116)
  • SAP GUI Interview Questions SAP GUI (15)
  • SAP AllOther Interview Questions SAP AllOther (329)