Data Conversion

[Former Member]

Hi Guys,

pls explain me about,

Is data converted from legacy system to production server or to development server?

as i know data is in EXCEL format in legacy system, Who actually takes care of entering master data in excel sheet? (enduser or functional consultant)

in what format data need to be entered in EXCEL SHEET?

points are assured.

thanq

with regards

chaitanya

[Former Member · Accepted solution]

Hi Chaitanya,

The data will be coverted/migrated from legacy system to Production system.

As a functional consultant your responsibilty is to get the template ready for data migration. Ensure you capture and map all required fields properly.

You need to capture the data in excel file initially, but later convert it to a flat file with some tab delimiter which will be used by the program to transfer data.

Once the data is ready, depending on the no. of records, you can decide on the data migration method. You will have to give your requirement to technical guys, who will write relevant programme for transferring this data.

Thanks

[Former Member · Accepted solution]

Thanks for your reply.

I got one more doubt.

what exactly the difference between LSMW and BDC in final o/p? Is there anything like in this sceneraion we have to use this tool?

anyway we are using BDC In LSMW for running batch input session.

am i correct.

thanx again for your reply AKK.

with regards

chaitanya

[Former Member]

Hi Chaitanya,

The Difference between LSMW and BDC are given Below:

1.Main difference when it comes to data is

LSMW is used to transfer Master Data

BDC is used for transactional Data.

2. LSMW can import data from legacy systems (e.g. in the form of Excel sheets or CSV files). For this, I guess, LSMW converts your data into batch input files automatically. If you use BDC, on the other hand, you have to write your batch input file yourself, line per line.

3. BDC (Batch Data Communication) is a technology used for data transfer. it is meant for transferring data thru SAP transactions itself. When u use BDC for data transfer, the sequence of steps is the same as when u use standard sap transaction screens for data upload. The only difference is that u can use different options for foreground/background processing.

LSMW on the other hand is a tool that helps migrate data from a legacy system (non-sap system) to SAP system. it offers u various options to use either batch input, direct input, BAPIs or idocs. It involves a series of some 17-18 steps to migrate data.

SMW: Legacy System Migration Workbench.

BDC: Batch Data Communication.

LSMW: It is used for migrating the data b/w the Non-SAP

and SAP application to do for that we can take the Non-SAP

application data and Converts the data into the Legacy data.

(Legacy data means Cleansing data and Purging the data

After the Legacy data creation convert the data in to

the "Flat file". That flat file is in the form of text file

or excel format. If the file is in the form of text format

we can create the ".txt" file ("ABC.txt") and in the form of

excel ".xls" file is created. flat file for dos and .xls

file for IBM.

The converted file (.txt/.xls)is either upload or download.

The Upload functionality if used for .txt file to SAP and

where as Downloading is the concept while SAP to .txt/.xls

file.

BDC: It is also used for migrating the b/w the non-sap to

sap applications.

In LSMW below 5000 records are updating or inserting

purpose we can use the LSMW.but where as above 5000 records

are uploaded we can use BDC.

4. Both are used to Transfer / Migration of the Data from LEGACY SYSTEM is to SAP SYSTEM.

LSMW (Legacy System Migration to Workbench):- No ABAP efforts are required for the SAP data migration. However, efforts are required to map the data into the structure according to the pre-determined format as specified by the pre-written ABAP upload program of the LSMW.

BDC (Batch Data Communication):- ABAPER's Help required and will write a Code to Migrate the Data from NON SAP SYSTEM (Legacy System) to SAP SYSTEM.

Ex:- Large / Huge data should be Transfer From Legacy System to SAP System Abaper will write code on this ( Data Migration in Create of Sales Orders in Large / Huge Quantity ).

Data can be uploaded using BDC programs, LSMW for master data and CATT is also being used.

Please Reward If Really Helpful,

Thanks and Regards,

Sateesh.Kandula

[Former Member]

thanx sateesh,

points are awarded.

thanx again.

chaitanya