on 06-23-2007 5:19 PM
Hi Gurus,
Can you tell me about the topic SAP Data Migration with LSMW ?
Also what is Cross Sales ??
Rohit
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 must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi below are the details for Data Migration with LSMW Reward if Useful
-
-
SAP Data Migration with LSMW
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.
This is one of the very powerful tools available in SAP to upload large amount of data to the system. This tools is comparable to ecatt or scatt. But the advantage LSMW has over them is the amount of data processed in single session. Moreover LSMW is easer to learn and execute.
Through LSMW one can create Master data, create transactional data, modify existing master data etc. This tool is very useful when some mass changes are to be carried out and no standard SAP transactions are available for that. There are few standard objects available in LSMW e.g. material master, vendor master, customer master, purchasing info record, purchase requisitions, purchase orders etc. Using these standard objects one can do mass data upload and mass transactions. Apart from this LSMW provides another functionality of recording the transaction and then carrying that out many times with large data. eg for that can be mass deletion of purchase requisitions, mass deletion of planned orders etc.
For creating simple projects user can go to tcode LSMW and get started. All the steps are listed very nicely and system will not allow user to skip the steps enlisted. User will need to create Project, Subproject and Object.
Input to LSMW can be simple excel sheet or text tab delimited file(text file like note pad).
Example of a LSMW project in step wise manner is presented below:
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.
LSMW data migration for sales order VA01 / XD01 customer
LSMW using session method for data migration as follows
E.g. for XD01 (create customer)
initially there will be 20 steps but after processing 1 step it will reduced to 14 for session method.
1. T-Code: LSMW.
2. ENTER PROJECT NAME
Sub project name
Object name.
Execute.
3. MAINTAIN OBJECT ATTRIBUTES.
Execute
Select Batch Input recording
go to->recording overview
create
Recording name.
Enter transaction code.
Start recording
do recording as per your Requirement.
Save à Back.
Enter recording name in LSMW screen.
Save à Back
Now there will be 14 steps.
2. MAINTAIN SOURCE STRUCTURES.
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 pop out )
Select à From data file
Apply source fields
a. Enter No. of field's
b. Length of fields
c. 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 structure 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
Attach flat file
Give description
Select tabulators
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 will 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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
108 | |
12 | |
11 | |
6 | |
5 | |
4 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.