Skip to Content

Legacy System Migration Workbench (LSMW) is handy tool for data uploads. In most of the big projects there is a separate development / data migration team is available. However, at times, it would be responsibility of the functional consultant to load the data such as vendor master, customer master and asset master etc. It would be real handy for a functional consultant to know LSMW (at least recording method) and it would help them to successfully complete the task. Hope this document would help many of our functional consultants, as I am seeing number of questions around LSMW. The simple rule is: Follow this document and practice is for number of times possible, then you will become master.

Go to Transaction Code “LSMW” and follow the following steps:

 

LSMW_1.png

Give some Unique name for Project, Subproject and Object. Click Create (Shift+F1). Now execute or press CTRL+F8.

LSMW_2.png

 

Give the description for Project, Sub Project and Object and say OK. Now execute or press CTRL+F8.

LSMW_3.png

Select Maintain Object Attributes and Execute (CTRL+F8)

LSMW_4.png

  

Click Display / Change (it will make you to change). Select the Radio Button Batch Input Recording. Now click on  “Goto” –
Recordings Overview. Click on Create Recording (Ctrl+F1).

LSMW_5.png

Click OK

LSMW_6.png

 

Give Required Transaction Code (In this case it is FK01)

LSMW_7.png

Create Vendor or Make changes for Entering Withholding tax details in the Vendor.

LSMW_8.png

Press Enter

LSMW_9.pngC

Press Enter

LSMW_10.png

Click on Save Button.

LSMW_11.png

Recording is saved now. Click on “Default All” Button.

LSMW_12.png

Click
Ctrl+Y, a + will come. With this, you can drag and copy whatever you want.  In case if any field is appearing twice you
need to change the field name by double clicking on that. Otherwise, your uploading will get failed.

  

Copy
the fileds to an excel file. 

LSMW_13.png

Remove the Blank Rows.

LSMW_14.png

Now the field name and descriptions are in one Column. I.e., “A”. You need to
segregate that. To do that, select Column “A” and Select in Excel “Data” – Text
to Column as shown in the following graph.

LSMW_15.png

Now Select the fixed with and say “Next”.

LSMW_16.png

Select Fixed Width and click next.

LSMW_17.png

Keep columns wherever you want by clicking.

Now say Next and then again say “Finish”. Now all fields and texts are divided into two Columns.

LSMW_18.png

Now copy the fields and texts as shown in the Sheet1 (Ctrl+C)

LSMW_19.png

Go
to Sheet2

  

Keep
the cursor in the Sheet 2 (A1) and then

  

Edit,

 

Paste
Special

 

Check
in Transpose as shown below and say OK.

LSMW_20.png

Now all your rows will become your columns as shown in the blow Screen.

LSMW_21.png

 

Now
fill the required details exactly as shown below. You should note that you have
to enter ‘0001 for payment method instead of 0001, since if you straight enter
0001 it will become 1, therefore you must ensure whenever it is starting with
“0” should be preceded with ‘.

LSMW_22.png

Now
select the whole sheet2.

  

Remove
all grids.

No colors should be there in the sheet.

No letter should be typed in different colors. All are in normal color only.

Keep the columns to “LEFT” Margin.

 

Now,

Format
=> Cells => Number => General as shown in the following screenshot.

LSMW_23.png

Now say OK.

Now copy the whole Sheet2 and paste it in the Sheet3.   Then
delete the header rows as shown below:

LSMW_24.png

Save
this file to your Hard Disk with a simple name. In this case I saved as Vendor.

 

Now
go to “SAVE AS” in Excel, and

Save
as Text (Tab Delimited) as shown in the above screen shot.

LSMW_25.png

Click on OK button as shown below.

LSMW_26.png

Click on “YES” button as shown below.

LSMW_27.png

Now, Click on “NO” button as shown below.

LSMW_28.png

Press F3 or Click on Back Button.

LSMW_29.png

Now, Click on “YES” to save.

LSMW_30.png

You will reach the below screen.

Again, press F3 or click on back Button.

LSMW_31.png

Click
F4 in the Recording Button, your structure will be populated. In this case it
is “VENDRECO”.

 

Now click on Save on Ctrl+S to save your recording.

 

After saving your recording click Back button or press Ctrl+F3 to go back.

LSMW_32.png

Now you will observe that few steps have been disappeared. Only few steps are left
out. This is because of the recording mode that you have been selected. Ideally
there should not be any Idoc related steps should be visible.

 

Now Step1 is being completed and the system automatically takes you to second step.
Now press CTRL+F8 or Executed.

LSMW_33.png

Click on Display / Change Button or press Ctrl+F1

LSMW_34.png

Now create a Structure by clicking “Create Structure” or Ctrl+F4.

LSMW_35.png

Give Source Structure Name and Description

LSMW_36.png

Your Source Structure Name and Description is shown. Click on Save button

LSMW_37.png

 

Now Press F3 or Click back button to go back.

  

Now the second step is completed and system automatically takes you to third step.

Click CTRL+F8 or Press Execute Button, which will take to maintain source fields.

LSMW_38.png

Click on Display / change as shown above OR press Ctrl+F1.

LSMW_39.png

Now press on Table Maintenance as shown above by keeping your cursor on the Source
Structure (in blue color in the above screen shot).

LSMW_40.png

Copy those Fields from Sheet1 and copy it here. (from your excel file)

LSMW_41.png

In case if your fields are came twice in recording, none of the field should be
similar. As already advised that change the field names to different field
names. Whatever, field names that you have changed in the structure should also
appear here. Meaning that in case these fields does not map with your changed
fields in your Structure, uploading will fail.

LSMW_42.png

Enter the Field Type as “C” – Characteristic and Length as 60. If you know the length
enter the exact length. If you do not enter the maximum length 60. You should
not enter the length less than the actual length of the field.

  

Say “Save”.

LSMW_43.png

Press “Enter”. Save the results and Press
F3 or Click on back button to go back.

LSMW_44.png

Now Click Save in this screen and again press F3 to go back.

LSMW_45.png

Now system will automatically takes you to fourth screen.

Click CTRL+F8 or Click on Execute Button.

LSMW_46.png

Select the Structure and click on Display / change button or press Ctrl+F1

LSMW_47.png

Click on Relationship (Ctrl+F4)

LSMW_48.png

Though
it is customary step, you should go to this step. And say OK for the message
that the system has issued. “A source structure is already assigned to target
structure VENDRECO”.

  

Now press Save and PressF3 or Click on back button to go back.

 
It will take you to the next screen automatically.

LSMW_49.png

Press CTRL+F8 or Click on Execute Button.

LSMW_50.png

In the above screen, select the structure and then click display / change or (Ctrl+F1).

  

Again Select the Structure,

LSMW_51.png

Go select the auto filed mapping as showing above in the above screen shot.

LSMW_52.png

Say “OK” with this 50 number screen. Do not make any changes.

LSMW_53.png

Keep on Pressing “Accept Proposal” for all the proposal as shown above.

LSMW_54.png

Your entire field mapping should appear as above. Each field should have four rows as above.

Once it is being completed the system issues a statement that “Auto Field Mapping is completed”

LSMW_55.png

Click Save (Ctrl+S) and go back (F3).

LSMW_56.png

 

Nothing to do with “Maintain Field Values, Transactions, User Defined Routines”

LSMW_57.png

Now Go to “Specify Files” Screen Manually and press “Ctrl+F8” or Execute Button.

LSMW_58.png

 

Select the first row and click on Display / change Button.

LSMW_59.png

Now Click on Add Entry “Ctrl+F2” as shown above.

LSMW_60.png

Select the “TEXT (Tab Delimited)” file that you have already created and say Open.

LSMW_61.pngLSMW_62.png

Your file has come and Enter some relevant “Name”

Select “Tabulator” Radio Button and say OK.

LSMW_63.png

Now Save (Ctrl+S) and press F3 or Back Button to go back.

LSMW_64.png

 

Now the system will take you to next step i.e., “Assign Files”. Press Ctrl+F8 or
press Execute Button.

LSMW_65.png

Select Source Structure (as shown in blue colour above) and press Display / Change
Button (Ctrl+F1).

LSMW_66.png

Click on Assignment  (Ctrl+F2)

Though it is a customary step, you need to visit this step compulsory. The system will
issue a message stating that “A file has already been assigned to source
structure “VENDOR_RECORDING”. Say Ok.
 

Click on Save (Ctrl+S) and Press F3 or click on back button.

LSMW_68.png

The system will take you to next step i.e., “Read Data”. Click on Execute or Press Ctrl+F8.

LSMW_69.png

Remove the Checks for

Value
Fields -> 1234.56

Date
Value -> YYYYMMDD as shown above. There should not be any check in the above
two check boxes.

 

Now
Click on Execute (F8)

LSMW_70.png

The system will tell that total 8 records are being read.

  

Now Click on Back Button or press F3 TWICE, which will take you to initial screen.

LSMW_71.png

Now the system takes you to next step “Display Read Data”

Click on Execute or Press Ctrl+F8.

LSMW_72.png

Here you give the number of lines in your text file and say OK.

LSMW_73.png

Click on Any one row and see whether the fields in SAP and columns in your Text File
are matching.

LSMW_74.png

Once you are satisfied that everything is matching and going fine, press F3 or Click
on Back button TWICE, which will take you to initial screen.

LSMW_75.png

Now you are automatically in “Convert Data” Screen.

  

PressCtrl+F8 or Click on Execute Button.

LSMW_76.png

Just press F8 or Execute Button.

LSMW_77.png

The following screen will appear. See the screen and press Back Button (F3) twice,
which will take you to initial screen.

LSMW_78.png

Now the system will automatically takes you to “Display Converted Data”.

  

Press Ctrl+F8 or Click on Execute Button.

LSMW_79.png

Enter the number of lines From 1 to 8 in this case, to see how it is showing in
Converted Data and Say Ok. (Click on Rite Tick).

LSMW_80.png

Click on any one of the converted data line and see how the data is going.

LSMW_81.png

If you are satisfied that everything is going fine, then Click on Go back button
(F3) TWICE, which will take you to initial screen.

LSMW_82.png

You will be automatically taken to “Create Batch Input Session”.

   

Click Ctrl+F8 or press “Execute” Button.

LSMW_83.png

Select “Keep Batch input Folder(s)?

 

Just Click on Execute Button (F8).

LSMW_84.png

One Batch input session will be created. The system will state that “1 batch input
folder with 8 transactions created” will be issued. Say OK. (Click Right),
which will take you to initial screen.

LSMW_85.png

Click Ctrl+F8 or Press on Execute Button.

LSMW_86.png

Now you are in SM35 Screen. Select the line that is being created to upload and
press Execute (F8) button as shown above.

LSMW_87.png

Select “Background” Radio Button.

Check in:

 

Extended log

Expert Mode

Dynpro Standard Size

As shown above and the click on “Process” button.

LSMW_88.png

See the log and click on Line, if there are any problems in your log.

   

Click on back button (F3) to come out of the session FOUR TIME, which will take you
to Easy Access Screen.

 

LSMW_89.png

Go to Report
“S_ALR_87012086”

Now You are Viewing the vendor records that you are uploaded. You can also follow
the same steps for Change also.

LSMW_90.png

Please let me know if you have any doubts.

To report this post you need to login first.

274 Comments

You must be Logged on to comment or reply to a post.

  1. Marianna Bilan

    Three years passed since publication, but this document is still valid and helpful. I was able to create my first LSMW project to change customer credit limits  with the reference to this tutorial. Everything works, thank you, Ravi, very much!!!

    (0) 
      1. Revs M

        hi ravi,

        i have followed all the same process mentioned above to create a material master but i cannot see materials in my material list.

        i have completed all the process but there was no log error also but how to see the materials created as i have followed all the process.

        (0) 
          1. Revs M

            Ok thanks i will execute in the foreground in the last step.

            one more question in the first step which object type and import method  for material master i should choose :

            1.Std batch/ Direct input or

            2.Batch input recording

            Thank you.

            Regards,

            Revs

            (0) 
              1. Jürgen L

                As said, recording is the wrong approach for material master. Better use the SAP given standard, which is either batch/direct input, IDOC or BAPI method, they all work pretty well, no need for an own recording.

                (0) 
  2. Murali Vemula

    Hi Ravi,

    Thank’s for sharing this ,it’s very useful & detailed explanation .Expecting some documents form your’s as like this.once again thank’s for your Handwork.

    Regards,

    Murali

    (0) 
  3. Lorena Lista Arenas

    Hi! I wish I had read this post sooner, It’s really helpful.

    I managed to successfully complete an LSMW but in a trial and error way. The thing is I did it in a PER client that was created only to test data uploads and now I have to do it in the real PER client and I don’t know if I should transfer the project to that client or if all changes done to the project are already there? I really need you help! Thank you in advance.

    (0) 
    1. Ranu Eugene

      Hi Lorena,

      You can always move your LSMW to from PER client to real PER client,now the call is yours.

      If your LSMW is working fine in PER client then you can move it to real PER, for doing this you

      need to click on extras and Export the LSMW and then you need to import the same in real PER client and if you think your LSMW in PER is not up to the mark then you can create another LSMW in PER and same can be moved to real PER or else you can create the LSMW in real PER directly,choice is entirely your’s.

      Hope this will make the things clear at your end.

      Regards

      Eugene

      (0) 
      1. Lorena Lista Arenas

        Hi Eugene! Thank you for answering. I finally realized LSMW is a “workbenck”, which means  the pojects are cross-client and, I don’t have to export and import them. They’re already there.

        (0) 
    2. Ravi Sankar Venna Post author

      You may need to export and import the LSMW as advised by Ranu. In such case you don’t need to record again. Just start from the step load your file.

      (0) 
  4. Rohtas Sharma

    Document is very helpful for being a Functional consultant because I have upload number of Master data in my current project without any coding.

    thanks Ravi

    (0) 
  5. Thomas Zierold

    What a nice blog – thank you for sharing this detailed manual.

    I’m trying to adapt this manual to my needs but I’m kind of stucked.
    Is there a way to use LSMW to create PPMs (/SAPAPO/SCC03) or the best solution would be to change the bucket consumption of a resource within the PPM (also /SAPAPO/SCC03).

    I think the problem is that I have to use the mouse to navigate inside the TA and I not just can use ‘return’ or any other shortcut to get where I want . Dear community, do you have any idea / best practice or something else ?

    Thank you in advanced!!!

     

     

    (1) 
  6. Chandra B

    Dear Ravi garu,

     

    I’m really happy the way you provided the step by step process i have become master in LSMW in my entire organisation, though there are 7 to 8 years experience guys are in my org.

    Just now i have uploaded a report for 5000 assets in production successfully.

    Thank you so much for you valuable knowledge.

     

    Regards,

    Chandra B

    bestachandra@gmail.com

    (0) 
  7. Kamil Kosiorowski

    Mr Ravi,

    Thanks a lot! This manual served me to upload costcenters massively and it worked! I work only few months as a SAP Specialist, but this gave me understanding on how LSMW works.

    best regards,

    Kamil Kosiorowski

    (0) 

Leave a Reply