LSMW and BDC

[Former Member]

HI Frendz,

Can anyone tell me when in which scenario we use BDC and LSMW.

Both the tools are to upload data from legacy system when exactly we decide which tool to use and why..?

Regards

Vijaya

[Former Member]

Hi,

LSMW is the new tool for data migration.its applicable only for certain transactions like XK01,MM01. for other transactions we have to use BDC (MK01,FK01).

this requires no coding and Functional Consultants will be mostly using this tool.

BDC requires coding and we use function modules for data migration.This can be use for any transaction code (XK01,MK01,FK01......)

The above techniques are used for data migration from non sap systems to

sap systems.

Hope this helps you,

rgds,

Prajith

[Former Member]

Hi,

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 .

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 applicatios.

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.

Regards

Gaurav

[navin_khedikar2]

Hai Vijaya

BDC:A bdc generally use for upload data particular transaction other than master data. If any complexity are like if we want to use IF-ENDIF / other control statement / manipulate some data / calculations , if this type of scenario then we must go with BDC coding.

LSMW:Its generally use for uploading master data even some times its use for transaction data but rarelly . Its tool for uploading data. Generally its use by functional people only , if any complexity then our role come to the picture.

I think ur issue clear.

Reward Points Useful.

With regards

Navin Khedikar

[Former Member]

HI laxmi,

both lsmw and bdc does the same thing, but to be precise if concerned functional consultant is strong enough to build lsmw tool for business requirement data upload lsmw would be used ,and also there are multiple steps to be followed for completing data base updation in sap.

but bdc is directly thru abap route ,it requires a small piece of code with XL file merge logic in y program with upload input directly from any path.

reward if helps !!!!!!