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:

2) You will reached on below screen

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

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:

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.

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,

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:

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

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

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

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

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

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

Entries fills down:

For other recording, you also follow the same steps:

For other recording, you also follow the same steps:

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

Choose subtype 0010 – Email

Save data by pressing save button then you find below screen

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

Click on Table button to find below window:

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:

• 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:

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

Proceed for step 2, select it and execute it

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

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

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

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

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

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