STJ LSMW

LSMW (Legacy System
Migration Workbench)
p
to
m
o
c
.
s
b
jo
Published by Team of SAP

Consultants at SAPTOPJOBS Visit us at
www.sap-topjobs.com
p
a
.s
Copyright 2007-09@SAPTOPJOBS
w
w
All rights reserved. No part of this publication may be reproduced, stored in a

retrieval system, or transmitted in any form, or by any means electronic or mechanical
including photocopying, recording or any information storage and retrieval system
without permission in writing from SAPTOPJOBS.
TABLE OF CONTENT
INTRODUCTION ..................................................................................................3
1. Create a project, sub project and object ........................................................4
2. Create Recordings.........................................................................................7
3. Maintain object attributes.............................................................................26
4. Maintain Source Structure ...........................................................................29
5. Maintain source fields ..................................................................................31
6. Maintain Structure relations .........................................................................44
7. Maintain field mapping and conversion rules...............................................45
8. Specify file for upload and create a file for upload .......................................56
9. Assign files...................................................................................................71
10.
Read data.................................................................................................72
11.
Display Read data....................................................................................74
12.
Convert data.............................................................................................77
13.
Display converted data.............................................................................78
14.
Create Batch input session ......................................................................81
15.
Run Batch input session...........................................................................82
p
to
w
w
p
a
.s
b
jo
c
.
s
m
o
INTRODUCTION
LSMW an abbreviation for Legacy System Migration Workbench is a tool in SAP
which is used to migrate Legacy data into SAP.
It is a very important tool and easy to learn and master it.
LSMW has a recording tool which can record the transaction and the fields to be
uploaded.
m
o
Thus upload of master data and transaction data is made very simple in this tool.
You can use this tools in almost all modules for upload of master data and too
some extent transaction data also.
c
.
s
Thus in FI you can upload the following master data through this:
Vendors, Customers, General Ledger, Asset master, Bank Master.
You can upload Transaction balance through this i.e. an FI document.
b
jo
In CO you can upload the following master data:

Cost element, Cost center, Profit center, Activity types, Internal orders, Statistical
key figures
p
to
p
a
.s
In other modules likewise you can upload other sets of master data.
In this book we cover the creation of a Vendor master data with accounting
view.
Lets get going then.
w
w
1. Create a project, sub project and object

Type LSMW in the command field
p
to
w
w
Click
p
a
.s
b
jo
c
.
s
m
o
Click
p
to
to continue.
b
jo
If you do not want this message to appear every time,
p
a
.s
You can click on the check box
w
w
c
.
s
m
o
Click on
to create a new project
Update the following fields:
Create a subproject
Click
p
a
.s
Create an object description
w
w
Click
p
to
m
o
c
.
s
Click
b
jo
2. Create Recordings
p
to
m
o
b
jo
c
.
s
Now we will proceed to Recordings since we want to record a transaction (Create

Vendor Master data)
p
a
.s
Important:
Please note that before you start the recording you should first actually
perform this transaction manually and plan what data you want to capture
for upload purpose. This is required so that you avoid doing mistakes while
recording.
While recording you should not press enter in between, you should only
press enter after you have completed entering all the details on that screen.
w
w
Click on Goto Recordings
w
w
Click
p
to
p
a
.s
Click
b
jo
c
.
s
m
o
Update the following:-
p
to
w
w
p
a
.s
b
jo
c
.
s
m
o
Click
p
a
.s
p
to
w
w
Update the following fields:
b
jo
c
.
s
m
o
p
to
w
w
p
a
.s
Click
b
jo
c
.
s
m
o
We do not want capture anything here.
p
to
p
a
.s
w
w
Click
to go to the next screen
b
jo
c
.
s
m
o
Click
to go to the next screen.
w
w
p
a
.s
p
to
b
jo
c
.
s
m
o
p
to
w
w
p
a
.s
b
jo
c
.
s
m
o
p
to
w
w
p
a
.s
Click
b
jo
c
.
s
m
o
p
to
w
w
p
a
.s
b
jo
c
.
s
m
o
p
to
w
w
p
a
.s
Click
b
jo
c
.
s
m
o
p
to
w
w
p
a
.s
b
jo
c
.
s
m
o
p
to
w
w
p
a
.s
Click
b
jo
c
.
s
m
o
Click
to save the vendor master data.
p
to
w
w
Click
p
a
.s
to update the field name.
b
jo
c
.
s
m
o
p
to
w
w
p
a
.s
Click on
b
jo
Make a note of these fields since they will be required later on.
c
.
s
You can export these fields to an excel sheet as follows:-
m
o
p
to
w
w
p
a
.s
Select spreadsheet
b
jo
c
.
s
m
o
Click
Click
p
a
.s
p
to
to change the location
w
w
b
jo
c
.
s
m
o
Click
p
a
.s
w
w
Click
We will see the file later.

Click
p
to
b
jo
c
.
s
m
o
Click
p
to
w
w
p
a
.s
Click
b
jo
c
.
s
m
o
3. Maintain object attributes

Here we maintain the attributes of the object VENDORS. We link the recording
created to the object VENDORS.
Click
p
a
.s
p
to
w
w
b
jo
c
.
s
m
o
p
to
p
a
.s
w
w
Click
Click radio button

Take a drop down in Recording
to select
b
jo
c
.
s
m
o
p
to
w
w
p
a
.s
Click
Click
b
jo
c
.
s
m
o
4. Maintain Source Structure

Notice that the radio button has automatically moved to the next step Maintain
source structures. Each time you perform a transaction the radio button moves to
the next step automatically.
Also notice on the extreme right hand side under the column Last action (date,
time, and user). This is updated with information each time the transaction is
performed.
m
o
Here we maintain the source structure for the LSMW.
p
to
w
w
p
a
.s
Click
b
jo
c
.
s
p
to
w
w
Click
p
a
.s
m
o
c
.
s
Click
b
jo
Click
Click
5. Maintain source fields

Here we maintain the source fields which are to be updated with the data.
p
to
w
w
Click
p
a
.s
b
jo
c
.
s
m
o
Click
p
to
w
w
p
a
.s
Position the cursor on

Click
b
jo
c
.
s
m
o
p
to
w
w
p
a
.s
c
.
s
b
jo
Now we need to update the fields which you have captured in the recording.
In step 1 recording we had downloaded a file with the fields.

Let us open that file in excel.
m
o
Click
w
w
p
a
.s
Click
p
to
b
jo
c
.
s
m
o
Click
w
w
p
a
.s
p
to
b
jo
c
.
s
m
o
p
to
p
a
.s
m
o
c
.
s
b
jo
All the fields shown in column J needs to be mapped
w
w
Now go to SAP LSMW screen and copy and paste all these fields from excel.
To know the length of fields, go to the transaction code FK01 and enter the
vendor code you just now saved. In our case we saved vendor code 100001
We want to know the length of the field Name
p
to
p
a
.s
c
.
s
m
o
b
jo
w
w
Position the cursor on field

and press F1 function button on the
keyboard or right click and select Help
Click
p
a
.s
p
to
to see the technical information
w
w
b
jo
c
.
s
m
o
Double click
p
a
.s
p
to
w
w
b
jo
c
.
s
m
o
p
to
p
a
.s
c
.
s
b
jo
The length of the field Name1 is 40 and the data type is character
w
w
m
o
Here you update the field name, the type of field whether C (Character,
alphanumeric) or N (Numeric) and the length of the field
p
a
.s
After updating all the fields
w
w
Click
p
to
b
jo
c
.
s
m
o
Click
p
a
.s
Click
p
to
w
w
b
jo
c
.
s
m
o
p
to
w
w
Click
Click
p
a
.s
b
jo
c
.
s
m
o
6. Maintain Structure relations

We actually dont do anything except click on change button and click on save
button.
Click
p
a
.s
w
w
Click
p
to
b
jo
c
.
s
m
o
Click
m
o
c
.
s
Click
b
jo
7. Maintain field mapping and conversion rules
p
to
Here we create a link between the system fields and the source fields maintained
in the earlier step.
w
w
p
a
.s
Click
Click
p
a
.s
p
to
w
w
b
jo
c
.
s
m
o
p
to
and click
w
w
p
a
.s
b
jo
c
.
s
m
o
p
to
Double click
w
w
p
a
.s
b
jo
c
.
s
m
o
p
to
p
a
.s
m
o
b
jo
c
.
s
If you want to default the company code position the cursor on BUKRS and click
w
w
p
a
.s
p
to
w
w
and click
b
jo
c
.
s
m
o
Double click
p
a
.s
p
to
w
w
b
jo
c
.
s
m
o
p
to
p
a
.s
Position the cursor on NAME1 and click
w
w
Double click
Similarly map all the fields
To
c
.
s
m
o
b
jo
.
c
.
s
m
o
Sometime you get a message ignore it. This is because you have maintained the
length of the field which is more than the target field. If the source field is longer
than the target field the text such as name, address could get truncated.
p
to
w
w
p
a
.s
b
jo
p
to
w
w
Click
p
a
.s
Click
b
jo
c
.
s
m
o
p
to
w
w
p
a
.s
Click
b
jo
c
.
s
m
o
8. Specify file for upload and create a file for upload

Here you attach the text file for upload.
p
to
p
a
.s
c
.
s
b
jo
Skip the Step Maintain fixed values, translations, user defined routines
w
w
Click
Click
m
o
p
to
Use the file already downloaded for creating upload file
w
w
p
a
.s
c
.
s
b
jo
Before we attach the file for upload, we must create this the file.
m
o
Copy column K and insert on a new worksheet

Right click and select
p
to
w
w
p
a
.s
b
jo
c
.
s
m
o
Click
p
to
p
a
.s
c
.
s
b
jo
Remove the blank columns in between
m
o
w
w
Now update the data for vendors to be uploaded into the system.
Save this file as an excel template for upload of Vendor master.

Thereafter delete the header row.
p
a
.s
Now click on File Save as
p
to
w
w
b
jo
c
.
s
m
o
p
to
Click
p
a
.s
w
w
Click
Click
Click
to close the file
b
jo
c
.
s
m
o
Click
Check the text file to see if it is ok , whether it has no double quotes etc.
Open the text file from the location where it is saved.
p
to
p
a
.s
c
.
s
m
o
b
jo
w
w
There are some double quotes in the file, we need to remove this
p
a
.s
w
w
Click
Click
p
to
b
jo
c
.
s
m
o
Now the file is ready for upload.

Go to the LSMW screen in SAP
p
to
p
a
.s
Close this file.
w
w
b
jo
c
.
s
m
o
p
to
Click
w
w
p
a
.s
b
jo
c
.
s
m
o
Double click
p
to
w
w
p
a
.s
Take a drop down in the field file
b
jo
c
.
s
m
o
Click
p
a
.s
p
to
w
w
b
jo
c
.
s
m
o
p
to
w
w
p
a
.s
b
jo
c
.
s
m
o
p
to
w
w
Click
p
a
.s
b
jo
c
.
s
m
o
Click
p
a
.s
Click
p
to
w
w
b
jo
c
.
s
m
o
9. Assign files
We just click on change button and save the assignment.
Click
p
a
.s
Click
p
to
w
w
b
jo
c
.
s
m
o
Click
Click
10.
Read data
By executing this step the system actually reads the data from the upload file.
p
to
w
w
p
a
.s
Click
b
jo
c
.
s
m
o
Click
p
to
p
a
.s
c
.
s
m
o
b
jo
w
w
It shows the number of transactions read, written and not written.
Click
11.
twice
Display Read data
This step is very important. Here you come to know whether there are any errors.
Whether the data passed on from the file is mapped to correct field. So you
should see a few records to see whether it is correct.
p
to
w
w
Click
p
a
.s
Click
b
jo
c
.
s
m
o
Double click
p
to
w
w
p
a
.s
b
jo
c
.
s
m
o
p
to
p
a
.s
w
w
Click
twice
b
jo
c
.
s
m
o
12.
Convert data
In this step the read data is converted.
Click
p
a
.s
w
w
Click
p
to
b
jo
c
.
s
m
o
Click
13.
twice
p
to
Display converted data
p
a
.s
m
o
b
jo
c
.
s
In this step we display the converted data. Again you should see one or 2
records to see that they are converted correctly.
w
w
p
to
Click
w
w
p
a
.s
b
jo
c
.
s
m
o
Double click on
p
to
p
a
.s
w
w
Click
twice
b
jo
c
.
s
m
o
14.
Create Batch input session
In this step we create the Batch input session for the upload data. The data is not
updated when you create Batch input session.
Click
p
a
.s
w
w
Click
p
to
b
jo
c
.
s
m
o
15.
m
o
Run Batch input session
c
.
s
In this step, we execute the Batch input session. Data is actually updated here.
We should first execute the Batch input session for a few records in foreground.
After testing that the data is getting uploaded correctly, then you can execute this
session in the background.
p
to
w
w
p
a
.s
Click
b
jo
p
to
w
w
Click
p
a
.s
m
o
c
.
s
Select
b
jo
Run the first record in foreground.
Click
w
w
p
a
.s
Click
p
to
b
jo
c
.
s
m
o
p
to
Click
w
w
p
a
.s
b
jo
c
.
s
m
o
p
to
w
w
p
a
.s
Click
b
jo
c
.
s
m
o
p
to
Click
w
w
p
a
.s
b
jo
c
.
s
m
o
p
to
w
w
p
a
.s
Click
b
jo
c
.
s
m
o
Click
p
a
.s
p
to
w
w
b
jo
c
.
s
m
o
p
to
Click
w
w
p
a
.s
b
jo
c
.
s
m
o
Click
p
a
.s
w
w
Click
p
to
b
jo
c
.
s
m
o
b
jo
Now again select and process in background for the next record
p
to
w
w
p
a
.s
Click
Keep Pressing enter till the session goes away.
m
o
c
.
s
After verifying that the first record is uploaded correctly, you can now run the
batch input session in background.
The Vendors are successfully updated.

That brings us to an end of creation and execution of LSMW.
p
to
w
w
p
a
.s
b
jo
c
.
s
m
o

STJ LSMW

Uploaded by

Copyright:

Available Formats

STJ LSMW

Uploaded by

Document Information

Original Title

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

STJ LSMW

Uploaded by

Copyright:

Available Formats

What are the main steps to create and execute an LSMW project?

What are the main steps to create and execute an LSMW project?

What are recordings used for in LSMW?

What are recordings used for in LSMW?

LSMW (Legacy System

Published by Team of SAP

All rights reserved. No part of this publication may be reproduced, stored in a

In CO you can upload the following master data:

1. Create a project, sub project and object

If you do not want this message to appear every time,

You can click on the check box

to create a new project

Update the following fields:

Create an object description

Now we will proceed to Recordings since we want to record a transaction (Create

Click on Goto Recordings

Update the following:-

Update the following:-

Update the following fields:

We do not want capture anything here.

to go to the next screen

to go to the next screen.

Update the following:-

Update the following:-

Update the following:-

to save the vendor master data.

to update the field name.

You can export these fields to an excel sheet as follows:-

to change the location

We will see the file later.

3. Maintain object attributes

Click radio button

4. Maintain Source Structure

Here we maintain the source structure for the LSMW.

Update the following:-

5. Maintain source fields

Position the cursor on

In step 1 recording we had downloaded a file with the fields.

All the fields shown in column J needs to be mapped

Position the cursor on field

to see the technical information

After updating all the fields

6. Maintain Structure relations

7. Maintain field mapping and conversion rules

Position the cursor on

Update the following:-

Position the cursor on

Position the cursor on NAME1 and click

Similarly map all the fields

8. Specify file for upload and create a file for upload

Use the file already downloaded for creating upload file

Copy column K and insert on a new worksheet

Remove the blank columns in between

Save this file as an excel template for upload of Vendor master.

Now click on File Save as

to close the file

Update the following:-

Now the file is ready for upload.

Close this file.