Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / 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 |
Post New Answer View All Answers
How will you consider sub contracting po components which are not sent by your company to vendor but they are added by the vendor (sub contractor)?
How can we view the stocks provided to the vendor?
Can anybody tell some of business scenarios sample tickets That they have resolved? SAND...@
What is goods movement? What type of documents is created after the goods movement?
How does this impact a business-end user?
What is a ‘return delivery’?
What is meant by scales in mm?
What is a profit center?
Suppose your client wants to activate split valuation for all materials after 1 year of go live? What will be your strategy?
How will you transport release strategy from quality server to production server? Will you transport it from one server to another?
What are the main components of the mm module? How are these components used in sap?
What unique insight into this upgrade does infotrellis have that other vendors don’t have?
What is a material ledger?
What is the subcontracting cycle?
Explain stock transfers?
