on 03-18-2008 6:39 AM
hI,
I want step by step procedure of LSMW Information.
Please give some materilal on LSMW
hi,
Follow this link for step by step tutorials,
http://www.saptechnical.com/Tutorials/LSMW/LSMWMainPage.htm
Some more link . might help you.
LSMW
http://www.sap-img.com/sap-data-migration.htm
http://www.sapgenie.com/saptech/lsmw.htm
http://sapabap.iespana.es/sapabap/manuales/pdf/lsmw.pdf
Hope this helps, Do reward.
Edited by: Runal Singh on Mar 18, 2008 12:27 PM
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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.
What are the methods to migrate data from a legacy system to SAP?
LSMW is used for migrating data from a legacy system to SAP system, or from one SAP system to another.
Apart from standard batch/direct input and recordings, BAPI and IDocs are available as additional import methods for processing the legacy data.
The LSMW comprises the following main steps:
Read data (legacy data in spreadsheet tables and/or sequential files).
Convert data (from the source into the target format).
Import data (to the database used by the R/3 application.
But, before these steps, you need to perform following steps :
Define source structure : structure of data in the source file.
Define target structure : structure of SAP that receives data.
Field mapping: Mapping between the source and target structure with conversions, if any.
Specify file: location of the source file
Of all the methods used for data migration like BDC, LSMW , Call Transaction which one is used most of the time?
How is the decision made which method should be followed? What is the procedure followed for this analysis?
All the 3 methods are used to migrate data. Selection of these methods depends on the scenario, amount of data need to transfer. LSMW is a ready tool provided by SAP and you have to follow some 17 steps to migrate master data. While in BDCs Session method is the better choice because of some advantages over call transaction. But call transaction is also very useful to do immediate updation of small amout of data. (In call transaction developer has to handle errors).
SO Bottom line is make choice of these methods based of real time requirements.
These methods are chosen completely based on situation you are in. Direct input method is not available for all scenario, else, they are the simplest ones. In batch input method ,you need to do recording for the transaction concerned. Similarly, IDoc, and BAPI are there, and use of these need to be decided based on the requirement.
Try to go through the some material on these four methods, and implement them. You will then have a fair idea about when to use which.
Explain the exact difference between lsmw & bdc.
BDC- It is Batch data communication. Its used for data conversion from legacy system to SAP system. Only technical people can do it. Tcode is SHDB.
LSMW- It is legacy system migration workbench. Its also used for data conversion from legacy system to SAP system. But it is role of functional consultant.
There are 14 steps in LSMW. As soon as you complete the one step, automatically it will go to next step.
In general you can use LSMW. But if you want to transfer more than 40,000 data, then it is not possible in LSMW. That time you can take help of BDC.
refer to the link.
http://www.sap-img.com/sap-data-migration.htm
regards,
sreelakshmi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
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
also go through these links.
http://www.sap-img.com/sap-data-migration.htm
http://www.sap-img.com/basis/transport-guide-tips-for-different-sap-objects.htm
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi,
initially there will be 20 steps but after processing 1 step it will reduced to 14 for Batch input recording method
T-Code: LSMW
ENTER PROJECT NAME
Sub project name
Object name
Execute
1. MAINTAIN OBJECT ATTRIBUTES
Execute
Display/Change
Select Batch Input recording
go to->recording overview
create
Recording name
Enter transaction code
Start recording
do recording as per the Requirement
Save & Back
Enter recording name
Save & Back
Now there will be 14 steps
2. MAINTAIN SOURCE STRUCTURES
Execute
Display/Change
Create
Enter the name of structure
Save & Back
3. MAINTAIN SOURCE FIELDS
Execute
Display/Change
Select structure
Select Copy fields (a dialogue window will pop out )
Select From data file
Apply source fields
a. Enter No. of field's
b. Length of record
c. Attach file
Save & Back.
4. MAINTAIN STRUCTURE RELATIONS
Execute
Display/Change
Save & Back
5. MAINTAN FIELD MAPPING & CONVERSION RULE
Execute
Display/Change
Click on source field, select exact field from structure and press Enter
***repeat these steps for all fields
(or) Extras->Automapping
Save & Back
6. MAINTAIN FIXED VALUES, TRANSACTION, USER DEFINED ROUTINEs
Not necessary.
7. SPECIFY FILES.
Execute
Display/Change
Click on legacy data on pc
Brose flat file
Give description
Select tabulator
select Filed names at start of file
Enter
Save & Back
8*. ASSIGN FILES
Execute
Display/Change
Save & Back
9. READ DATA
Execute
Execute
Back & Back
10. DISPLAY IMPORTED DATA
Execute
Enter ok ***it will show records
Back
11. CONVERT DATA
Execute
Execute
Back & Back
12. DISPLAY CONVERTED DATA
Execute
Enter ok ***it will show records
Back
13. CREATE BATCH INPUT SESSION
Execute
Select keep batch input folder
Execute
Enter
14. RUN BATCH INPUT SESSION.
Execute
SM35 will come
Object name will be shown here
Select object & process
regards,
sreelakshmi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
82 | |
10 | |
10 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.