lsmw user manual - mm01 - hfil.doc

mySAP ECC IMPLEMENTATION

Data Migration ofNon-SAP Systems to SAP-Systems

Quick Introduction to Working with theLegacy System Migration WorkbenchVersion 4.0.0

LSMW Nine Benefits for LSMW Users The Legacy System Migration Workbench...

Provides maximum data consistency in uploaded data Can be used without knowledge of ABAP Easy of use steps leads you smooth data migration From SAP Service Marketplace it can be downloaded easily and quickly It is as a highly flexible tool to Meets your requirements It is independent from SAP R/3 releases Comes with different control functions Allows reusability of data mapping and conversion rules Export & Import options provide great flexibility to use LSMW Project in

different client.

LSM Workbench

The LSM Workbench is an SAP-based tool that supports transferring data from non-SAP systems ("Legacy Systems") to SAP systems once or periodically. Furthermore, the LSM Workbench provides a recording function that allows generating a "data migration object" in an entry or change transaction

Basic Principles of the LSM Workbench

The LSM Workbench was developed on the basis of the R/2-R/3 Migration Workbench that has been used many hundred times in the past and is still used presently.The following concepts and techniques from the R/2-R/3 Migration Workbench were adopted:Business objects instead of individual tables or field contents are migrated.The conversion rules to be defined are flexible and can be customized in the frame of migration customizing to meet the actual situation in the project in the user system.Preprogrammed conversion programs are not delivered. These programs are rather generated on the basis of the defined rules.The LSM Workbench was developed on the basis of the following principles:Most of the functions should reside in the SAP system. No collection of individual programs on different platforms.The quality and consistence of the data imported into the SAP system should be more important than speed and performance of data migration.Existing knowledge and coding should be used.The developed "mapping" and rules should be reusable and thus be used repeatedly in projects.On this basis, a concept was developed that is represented in the following chart:

Schematic Flow of Data Migration with the LSM Workbench

The main advantages of the LSM Workbench: Part of the SAP system and thus independent of individual platforms Creation of data migration objects on the basis of recorded transactions Interface for data on fronted Mass uploading of the Data to overcome the time factor of Data Entry

Process

1. Transaction Code LSMW

Enter Project NameEnter Sub Project NameEnter Object Name

Select Create Entry Button (Shift+F1)

Enter Project, Sub Project and Object Descriptions

Press Enter Button

Create entry

Select Continue Button (F8)

Continue button

Select Execute Button (Ctrl+F8)

Execute button

Select Batch Input Recording Radio Button

Give Recording

Select Recordings Overview Button

Recording Overview

Recording

Select

Select Create Recording Button (Ctrl+F1)

Create Recordinggg

Give Recording and Description

Press Enter Button

Recording

ecording

Give Transaction Code : MM01

Press Enter Button

Transaction Code

Enter Material (If Number Range Assignment is Internal, System will take automatically or External we will give the Number

Give Industry Sector

Give Material Type

Press Enter Button

Industry Sector

Material Type

Select Views (Selection through F9)

Press Page Down Button

Select View (Selection through F9)

Press Enter Button

Give Plant

Give Storage Location

Press Enter Button

Plant

Storage Location

Give DescriptionGive Base Unit of MeasureGive Material GroupGive Old Material Number if AvailableGive Division

Press Enter Button

Give Industry Standard Description (If Data Available)

Press Enter Button

Give Class Type

Press Enter Button

Give Class

Press Enter Button

Press Next Entry button or (F8)

Next Entry

Give Purchasing GroupSelect Batch Management Check BoxGive Purchasing Volume KeyGive GR Processing TimeSelect Source List Check Box

Press Enter Button

Ignore the warning message Press Enter Button

Give MRP TypeGive MRP ControllerGive Lot Size

Press Enter Button

Give Storage Location for External ProcurementGive Planned Delivery TimeGive Schedule Margin Key

Press Enter Button

Ignore the warning message Press Enter Button

Give Availability Check

Press Enter Button

Give Individual Collective Requirement

Press Enter Button

Give Temperature ConditionsGive Minimum Remaining Shelf LifeGive Total Shelf Life

Press Enter Button

Ignore the warning message Press Enter Button

Give Profit Center

Press Enter Button

Press Insp.Setup(Inspection Setup) Button

Press Inspection Types Button

Give Inspection TypesSelect Active Check Box’s Against Inspection Types

Press Enter Button

Give Inspection Interval DaysSelect QM Procurement Active Check BoxGive QM Control KeyGive Certificate Type

Press Enter Button

Ignore the warning message Press Enter Button

Give Valuation CategoryGive Valuation ClassGive Moving Price

Press Enter Button

Press Enter Button

Here With Qty Structure And Material Origin if necessary select check box’s It is depends on by the Material Type.

Press Enter Button

Press Enter Button

Press Enter Button, Then it will be Saved

Here Select Default All Button(Ctrl+F2)

Default All

From Menu Bar Go to SystemListSaveLocal File

Select Spread Sheet Radio Button

Press Enter Button

Select Directory Path

Give File Name

Select Generate Button

Double Click on Generated File on the Desktop

Delete Selected Columns (Column ‘A’ to ‘H’)

Delete Selected Rows (Row ‘1’ to ‘7’)

From Menu Bar Go to DataFilterAuto Filter

Select Column ‘B’ Filter

Select all the Lines

Delete All the Lines

Then Remove Filters

Select All the Line Items

From Menu Bar Go to DataFilterAdvanced Filter

Select Copy to Another Location Radio Button

Select Unique Record only Check Box

Position Curser on the ‘Copy To’ Box

Then Curser Position into the excel sheet

Select Copied Data

Insert Excel Sheet

Right Click on the Sheet

Select Paste Special

Select Values Radio Button

Select Transpose Check Box

Press OK button or Enter Button

Change Lines in Order Like

Description

Field Name

Data

Fill the Data, what we want to Upload

Select All the Data without Description Line

Go to Start In Task Bar

Select Run

Give Note Pad

Press Enter Button

Copy Data into the Note Pad

Give the File Name And Destination

Press Save Button

Select Save Button

Select Back Arrow Two Times

Select Save Button

Select Back Arrow

Select Execute Button

Select Create Structure Button(Ctrl+F40

Select Save Button

Select Back Arrow

Select Execute Button

Position Curser on the Source FieldSelect Copy Fields Button (Ctrl+F8)

Select From Data File Radio Button

Press Enter Button

Copy Fields

Enter Number of fields

Enter Max. Record Length

Press Enter Button

Press Enter Button

Select Source File

Press Enter Button

Select Table Maintenance Button (Ctrl+F9) If you want change the Field Length.

Table Maintenance

If you want change the Field Length, You can change here.

Select Back Arrow (F3)

Select Save Button

Select Back Arrow (F3)

Select Execute Button (F8)

Select Save Button

Select Back Arrow (F3)

Select Execute Button (F8)

From Menu Bar Go to Extras Auto Field Mapping

Here Select Below Radio Buttons Only

Edit All Target FieldsOnly Edit Initial Target FieldsMaintain Fields With The Same NameOnly Apply Rule Transfer (Move)No Confirmation

Press Enter Button

Press Enter Button

Select Save Button

Select Back Arrow (F3)

Select Specify Files Radio Button

Select Execute Button (F8)

Select Source FileSelect Tabulator Radio ButtonDeselect Semi-Colon Radio ButtonSelect Field Names At Start of File Check BoxDeselect Field Order Matches Source Structure Definition

Select Enter Button

Select Save Button

Select Back Arrow(F3)Select Execute Button (F8)

Select Save Button

Select Back Arrow(F3)

Select Execute Button (F8)

Select Execute Button Once Again

Select Back Arrow (F3)

Select Execute Button (F8)

Press Enter Button

Select Back Arrow Two Times

Select Execute Button

Select Execute Button Once Again

Select Back Arrow Two Times

Select Execute Button

Press Enter Button

Double Click on line Item you can view Line Item Data

Select Back Arrow Two Times

Select Execute Button

Select Keep Batch Input Folders Check Box

Select Execute Button

Press Enter Button

Select Execute Button

Select Batch Input Line Item

Press Process Button

Select Extended Log Check Box

Press Process Button or Enter Button

Process

Pres Enter Again and Again till you get the Save message

Go to Systems ServicesBatch InputDisplay Errors Only

System Will Upload the Data Automatically

Select Session Overview Button

Select Batch Input Line Item

Select Analysis Button

Analysis

It shows all the Uploaded Data Analysis.