Apresentacao Lsmwpres ABAP 191201

Accelerating Data Migration: LSM Workbench ACE

Legacy System Migration Legacy System Migration WorkbenchWorkbench


What is

LSMW?


What is data migration? / Subject of LSM

Data transfer source: non-SAP systems (“legacy systems”) target: SAP R/3

Initial data transfer from non-SAP systems to SAP R/3 Move data from legacy system to SAP R/3 Switch off legacy system

Periodic data transfer (Interfacing) Exchange data between R/3 and other systems

Position of data migration Requires customized R/3 System (customizing must be finalized)


Relevance of data migration? Accounts for 15% - 20% of the total SAP R/3 implementation costs Smaller implementation projects: up to 40%

Why is data migration so expensive?

In many cases

you need to develop conversion programs (which can not be

used later on) you need to deal with lots of technical details and different

technologies data volume depends on the project volume the effort for programming does not depend on the data

volume


Data migration in 3 steps

preparatorysteps

1. step 2. step 3. step

checklist LSMW

start target

datain

legacy system

data on R/3 database

fieldmapping and

rules

data import


What is LSMW (Legacy System Migration Workbench) ?

LSMW is a tool based on R/3.

LSMW supports periodic and single data transfer from a non-SAP system to R/3.

LSMW uses standard R/3 interfaces.


Requirements

for the use of

LSMW


Organizational

Customizing of the R/3 applications must be finished

Know how in LSMW (1-2 days)

Knowledge of the source data (Which fields means what?)

Knowledge of the R/3 application (Which fields means what?)

technical know how

R/3 basis (batch input processing, IDoc processing)

ABAP

System requirements

for LSMW 1.6 (July 1999): R/3 release 4.0x, 4.5x or 4.6x

for LSMW 1.0 (Sept. 1998): R/3 release 3.0F or 3.1x


How does

LSMWwork?


DatenmigrationData Migration


Define source structures

Bank data

Contact person

Vendor masterDATA

MIGRATION

B1 B2 B3 ... C1 ...C2 C3 C4A1 A2 A3 A4 A5 A6 A7 ...


Define source fields

DATEMIGRATION

Vendor master

Bank data

Contact person

L1 L2 L3 L4 L5 L6 L7 ...

B1 B2

A1

B3 ...

...A2 A3 A4

DATA

MIGRATION

B1 B2 B3 ... C1 ...C2 C3 C4A1 A2 A3 A4 A5 A6 A7 ...


Define structure relationshipsVendor master

L1 L2 L3 L4 L5 L6 L7 ...

Bank dataB1 B2 B3 ...

Contact personA1 ...A2 A3 A4

...

DATA

MIGRATION

B1 B2 B3 ... C1 ...C2 C3 C4A1 A2 A3 A4 A5 A6 A7 ...


Fieldmapping and conversion rulesVendor master

L1 L2 L3 L4 L5 L6 L7 ...

Bank dataB1 B2 B3 ...

Contact personA1 ...A2 A3 A4

...

Mov

e

1:1 translation

Individual coding

Fixed value/ constant

DATENMIGRATION

DATA

MIGRATION

B1 B2 B3 ... C1 ...C2 C3 C4A1 A2 A3 A4 A5 A6 A7 ...


Most common conversion rules predefined

Initial value

Constant

Assign (“MOVE”)

Fixed value

1:1 translation

Translation via intervals

User-defined routines

Prefix

Suffix

Concatenate

Individual ABAP coding

D DEA ATF FR

001...100 10101...200 20201...300 30


Central conversion rules (reusable rules)

Assure consistent data conversion in different data objects

Material numberMaterial number

Material masterMaterial master

Sales orderSales order

Purchase requisitionPurchase requisition

Purchase orderPurchase order


Further steps read source data

data conversion

run import

DATA

MIGRATION


One or several files

R/3 S

tand

ard

Convert dataConvert data

Batch Input processingBatch Input processing

Legacy dataon PC

Legacy dataon PC

Read dataRead data

Converted data

Converted data

Read dataRead dataLegacy data

on application server

Legacy data on application

server

IDoc inboundprocessing

IDoc inboundprocessing

Direct Input processingDirect Input processing

How LSM Workbench works

Structure relations

Field mapping

Conversion rules

Structure relations

Field mapping

Conversion rules


H Customer #1 (header rec.)P Contact person #1P Contact person #2... ...

What kind of data can be read?

Data from spreadsheet-based applications

MS Excel, MS Access, etc.

Data from host systems on R/3 application servers

Fixed record length, end of record indicator or hexadecimal length field at the beginning

With and without separator

Code page conversion

“Hierarchical” data with “identifying field values”

IdentifyingIdentifyingstringstring

(H=header(H=headerP=position)P=position)


Which data can be migrated via LSMW?

==> all data where an interface exists Standard Batch Input, Standard Direct Input

precondition: application program

entries in tables SXDA* (DX-Workbench)

Batch Input Recording

Recording a transaction

Flat target structure (no header-position constellations with variable amount of positions)

Methods for Business Objects („BAPIs“)

All BAPIs for which an ALE-IDoc interface has been generated(by SAP development)

IDocs

All


What does

LSMWlook like?


Define project, subproject and object

Define project, subproject and object


Select migration step

Select migration step


Maintainattributes


Enter structures of

legacy system in R/3

Enter structures of

legacy system in R/3


Define conversion rules and

field mapping

Define conversion rules and

field mapping


Generated conversion

program

Generated conversion

program


Interface for data on PC

Interface for data on PC


Overview of migration

object


object



object


object


Migration customizing:

translation table

Migration customizing:

translation table


recordingrecording


Transport of Mapping and Conversion Rules

PurposeMapping and conversion rules that have

been used in a R/3 system should be used in another R/3 system.

PurposeMapping and conversion rules that have

been used in a R/3 system should be used in another R/3 system.

ProcedureUse the export and import function of LSMW

Or: create a change request to use the standard transport system of R/3

ProcedureUse the export and import function of LSMW

Or: create a change request to use the standard transport system of R/3

Condition Both R/3 systems have the same LSMW-version

(to transport rules from version 1.0 to 1.6 you must either convert the rules to 1.6 format before the export or import to version 1.0 and then do the upgrade of the rules)

Condition Both R/3 systems have the same LSMW-version

(to transport rules from version 1.0 to 1.6 you must either convert the rules to 1.6 format before the export or import to version 1.0 and then do the upgrade of the rules)

LSM-Version

1.6

LSM-Version

1.6


Periodic Transfer of Data (/SAPDMC/SAP_LSMW_INTERFACE)

LSMW:additionalprogram Job

Read data (only files on the application server can be used)

Data conversion

Data import

to bescheduled


What LSMW can do

organize the data migration project

project, subproject, object

document the data migration project

define data conversion per object

select target business object (p.e. customer master, material master) method (p.e. create, change) import technique (p.e. batch-input, IDoc)

define source structure of the source data (segments, fields, file attributes etc)

define relations between source and target (SAP R/3) on record level and on field level

define rules transfer of field contents


What LSMW can do

read data (technical conversion)

convert data (conversion of values)

import data

with a standard import technique

batch-input

direct input

method for a business-object (“BAPI”)

IDoc technique

this means:

LSMW does not write data into the databases of the applications

precondition for the use of LSMW is the availability of a data transfer interface in the R/3 application


What LSMW can do

transport the data migration object

via download and upload

via R/3 transport system

What LSMW cannot do

extract data from the legacy system

“outbound”: transfer data from SAP R/3 into another system


Advantages and strengths at a glance:

Part of R/3 and therefore platform-independent

Wide range of data conversion techniques (fixed values, translation, ABAP coding, etc.)

Migration customizing: no literals in rules

Conversion program generated from conversion rules

User guidance: data migration in 14~20 steps

Interface for data in spreadsheet format

Check against R/3 Customizing before processing the import

Free of charge for SAP’s customers and partners


Advantages and strengths at a glance:

Migrated data in R/3 is consistent

user friendly

only basis ABAP knowledge necessary

in most cases only few programming has to be done

supports data transfer for the most important master and transaction data


Examples of positive feedback:

“... Just wanted to let you know us here at ... We are very pleased with the LSM product. We are using it for most of our conversions and have found it to be of tremendous help and quality. ...”

“The LSM Workbench saved the day. Without it, we would never have been finished on time.”

“...in our opinion, the major benefit is LSM’s flexibility, which allows us to respond very quickly to changing requirements...”


Examples of positive feedback:

“...within two and a half hours, we managed to generate our own migration object for the material master transfer, and successfully migrate the material masters from the EXCEL sheet. It was a complete success! ...”

“...the transfer of master data on June 12, and of the open items on June 19, 1998, meant that we could go live the same day.”

“...I used the LSMW to transfer customers and creditors, and I was really impressed by how fast and flexible it was! Fantastic! ...”

Accelerating Data Migration: LSM Workbench ACEInformation

Support

Training

LSMW


Information

Main information medium: SAPNet

www.service.sap.com.de/LSMW

Download of

software (LSMW16.CAR) and further material

installation guide

quick guide (“HowToGuide”)

contact

e-mail: [email protected]

Support

Online-Service-System: component XX-LSM


Training

upon request

part of the data migration training BC420 in release 4.6

self-study via examples in SAPNET


Beyond

LSMW


New DX-Workbench (Release 4.6)

Organize your data migration projects

Generate test data

Use LSMW (or third-party tool) as mapping engine

Fast data load via BAPIs

Handle import errors (restart etc.)


Release 4.6

New-DX Workbench and LSMW

Release 5.0

Unified solution for alldata migration issues


Legacy System Migration Workbench

[email protected]

Documents

Apresentacao Lsmwpres ABAP 191201