Skip to Content
Author's profile photo Bashir Ahmad

MASTER DATA UPLOAD PROGRAM FOR BEGINNERS


I am writing this document for the assistance of all beginners who trying to upload master data files via LSMW upload program. I also believe there are some other documents available with same content on SCN forum, hope all experts appreciate this input from my side.


Document Benefits

  • How to create LSMW upload program with single batch input recording
  • How to create LSMW upload program with multiple recording while having same Project, Sub-project and Object
  • How to use same LSMW program on different Clients or Systems Landscape (DEV -> QAS -> PRD)


Legacy System Migration Workbench (LSMW)


SAP provides you with the Legacy System Migration Workbench (LSMW), a tool that supports the one-time or periodic transfer of data from a variety of sources without any programming. You define the mapping and the rules for the changeover and the LSMW then uses this definition to generate an ABAP data transfer program. This gives you considerable support during the migration.


For more: http://scn.sap.com/docs/DOC-26158?url_id=text-search-best-best-scn-doc-26158


In this tutorial, I shall show you how to create LSMW upload program by having same project, sub-project and object and how to reuse your already created LSMW program to other clients or systems.

Note:

For attached screenshot, I am working on IDES System with EHP6 and using NWBC Desktop 5.0 so your screens may differ from attached one.


LSMW Upload steps are:

1)    Access Transaction Code = LSMW

After pressing enter you will reached on below windows popup message click on green tick mark button to move forward:

  LSMW-01.JPG

2) You will reached on below screen

LSMW-02.JPG

3) Enter details of Project, Sub-project and Object as per your requirements/domain here I am putting example of Human Capital Management – HCM domain.

Project:

You can specifies the name of the data transfer project, Enter any abbreviation with a maximum of ten characters and no blank characters. You can assign more than one sub-project to a project. As I am entering name of my project HCM-LSMW

Sub-project:

You can specifies the name of the sub-project, Enter any abbreviation with a maximum of ten characters and no blank characters. A sub-project can have an unlimited number of objects. As I am entering name of my sub-project HCM-PA

Object:

Object name. An object corresponds to a business object. It might be a HR master, client master, material master, financial documents. An object is assign to a sub-project; you can specifies the name of the object, Enter any abbreviation with a maximum of ten characters and no blank characters. As I am entering name of my object Infotype IT0006

LSMW-03.JPG

4) After entering short text of Project, Sub-project and its object click on create button and enters detail description against Project, Sub-project, Object one by one as per your requirement and understanding. How to proceeds ahead have a look on below screens shots:

LSMW-04.JPG

LSMW-05.JPG

LSMW-06.JPG

5) After entering all details, you will reach back on below window, and then you click on Clock icon button to execute your LSMW project, sub-project and its object.

LSMW-07.JPG

6) After executing your project you will reached on below window, where you find Process step from 1 – 20, kindly note after completing first step successfully, these reduced from 1 – 14 so no need to worry,

LSMW-08.JPG

Kindly note after completing first step successfully, these reduced from 1 – 14 as shown below screen, so no need to worry


7) Select process step 1 and press execute button to proceeds ahead:


LSMW-08.JPG

8) You will reach on below screen and find tabs as:

a. Attributes:

Here you select once only option

b. Object Type and Import Method

Select Batch input recording radio option

LSMW-09.JPG


Click on overview button in front of batch input recording option that leads you below mention screen


LSMW-10.JPG

Keep cursor on recording section and then click on create button then you will find below screen

LSMW-11.JPG

Provide Recording name, recording description as per your requirement and understanding then click on green tick button that leads you towards below screen:


LSMW-12.JPG

Enter your required transaction code as here I put PA30 for Employee Master Data maintenance data in down screen


LSMW-13.JPG


Enter all necessary data that you want to include during your recording like here:

  • Employee #:          41546
  • Info type #:          0006
  • Sub type#:            3
  • Period:                  24.11.2014 – 31.12.9999

Then press create button to proceeds ahead your recording I am recording here only mandatory fields

  • Postal Code #:      30301
  • City #:                    Riyadh

LSMW-14.JPG


Entries fills down:


LSMW-21.JPG

For other recording, you also follow the same steps:


LSMW-16.JPG

For other recording, you also follow the same steps:


LSMW-18.JPG


Add information as per your requirement for rest of recording as I am doing below for IT0105 communication against email subtype: 0010 E- mail


LSMW-19.JPG

Choose subtype 0010 – Email


LSMW-20.JPG

Save data by pressing save button then you find below screen

LSMW-21.JPG

Click on “Default All” and press save button and then click back button to reach on below window

Before proceeding towards step 2, click on Object Overview button, then you reached on below screen

LSMW-26.JPG

Click on Table button to find below window:

LSMW-27.JPG

This step is very important and help you to create source fields mapping and master data template files

  • Source Fields:

Source fields are those fields, which have already recorded, in your previous step of recording so in step you simply copy not all fields starting from Personnel Number (PERNR) kindly include Transaction code and Table name field that not required:

Note: copy these fields with help of Ctrl + Y, then make selection, paste these fields on any Microsoft Excel sheet, cut Field Description column, and put it on end as show in below:

LSMW-29.JPG

  • Master data Template file:

For your easy, to create your master data template or Upload file template copy all fields from above table and paste them from column to rows shape as show below:

LSMW-28.JPG

Like this your master data template get ready easily and well mapped with recording

Proceed for step 2, select it and execute it

LSMW-25.JPG

Select step number 2 and click execute button, where you just save entries and came back. You will reached below window screen


LSMW-32.JPG

Select step # 3, and maintain source fields by clicking on Table maintenance button as below:

LSMW-33.JPG

Click save button and back button and you will reached on below button:

LSMW-34.JPG

Proceeds for step # 5, maintain field mapping where I suggest choose auto mapping from menu toll bar

LSMW-37.JPG

Go to menu, choose extra, and then choose auto mapping


LSMW-38.JPG

Go to menu, choose extra, and then choose auto mapping as shown below:


LSMW-39.jpg

LSMW-40.JPG

LSMW-41.JPG

LSMW-42.JPG

LSMW-43.JPG

LSMW-44.JPG


LSMW-45.JPG

LSMW-46.JPG


LSMW-47.JPG

LSMW-48.JPG

LSMW-49.JPG

LSMW-50.JPG


Assigned Tags

      8 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Very well effort

      Author's profile photo Former Member
      Former Member

      well done .great job

      Author's profile photo Bashir Ahmad
      Bashir Ahmad
      Blog Post Author

      Thanks for your comments Najia,

      Regards;

      Bashir

      Author's profile photo Syed Quadri
      Syed Quadri

      Great Job!

      Step wise procedure for LSMW is very helpful. Thanks for your knowledge sharing.

      Author's profile photo Bashir Ahmad
      Bashir Ahmad
      Blog Post Author

      Thanks brother for your feedback regarding the documents

      Regards

      Bashir

      Author's profile photo Muhammad Altaf
      Muhammad Altaf

      Really brilliant effort and potentially useful documents.

      much appreciate the knowledge sharing attitude and dedicated effort behind it.

      Author's profile photo Bashir Ahmad
      Bashir Ahmad
      Blog Post Author

      Thanks Muhammad Altaf for your feedback comments and appreciation,

      Regards;

      Bashir Ahmad

      Author's profile photo Bob C
      Bob C

      Hi Bashir,

      Each step in this document is very well explained.

      I want to get your contact details,can you please provide.

      Thank you

      SAP HR professional