topic bdc uploading program with excel sheet in Application Development and Automation Discussions

bdc uploading program with excel sheet

Former Member — Thu, 03 Jan 2008 05:59:06 GMT

what is the differense between lsmw and bdc.

Re: bdc uploading program with excel sheet

Former Member — Thu, 03 Jan 2008 06:02:33 GMT

In BDC we can use call transaction and session method only and recording we have to do in another tcode

but in lsmw we can do recording over there only.

and in lsmw we can use bapi or idocs or bdcs

field mapping will be very easy and with out coding we can finish uploading

it will take less time

not only technical person, functonal guy can also do LSMW

Re: bdc uploading program with excel sheet

Former Member — Thu, 03 Jan 2008 06:14:47 GMT

BDC and LSMW both are use for loading data into SAP system

BDC the user has to write an ABAP program or use other utility to load legacy data.

BDC is the way to transfer data by writing a batch input program which can use either session or call transaction method.

LSMW used to transfer data without/less code.

LSMW is loading tool by SAP where you can use various methods to upload, massage data or cleansed your data while loading into SAP from legacy system. The method can be BDC, BAPI, Idocs

Regards,

Maha

Re: bdc uploading program with excel sheet

kesavadas_thekkillath — Thu, 03 Jan 2008 06:16:04 GMT

here r some known differences.

LSMW cannot be transported between servers.

certain authorizations for a tcode will be provided for end users for data upload

in such cases a functional performs performs a lsmw

BDC can be executed by a end user

can be transported between servers.

LSMW doesnot need a ABAP support for developing.

Re: bdc uploading program with excel sheet

Former Member — Thu, 03 Jan 2008 06:18:20 GMT

Hi,

In BDC you can use two types of uploading data :

1.Call transaction Method.

2.Session Method.

Call Transaction method : You can upload one transaction at a time.But it is faster and output can be modifiable.

Session method : You can upload more than one transaction at a time.It is a slow process.And output cannot be modifiable.

In LSMW :

LSMW creates a project to download the data in the system, several steps have to be implemented and it needs to have only few abap knowledge to implement them (the system'll generate all programs): only a good developer can create a bdc program.

A project can be created directly in every enviroment, bdc has to be created in development system and transport from dev to prod.

Every user can create a LSMW project, only developer can create a BDC program.

LSMW is me to more flexible and adaptable than BDC if some modifications have to be added after creating it.

I believe the problem on LSMW is the method to be used to load the data: if there are std methods (like BI or BAPI) there' no particular problem, but if there aren't you should register it, but sometimes these regitrations are not good and so you have to create an your own program.

So if there are std methods or it needs a simple BDC obtainable by registration I prefer to use LSMW.

Main difference is :

LSMW : For Master data and used when you are using standard tables.

BDC : For Transactional data and used when you are using large amount of data.

In BDC we can control the flow of data in programming and we can handle errors in BDC.

But in LSMW we cannot handle errors and not much programming effort required in LSMW as it mostly done by Functional consultant.

Hope you get some idea.

Thanks,

Sakthi C

*~~Rewards if useful~~*