Skip to Content
author's profile photo Former Member
Former Member


how do you decide which method is more efficient for a data transfer,is it lsmw,bdc?on what basis do u decide? can u please explain me in detail?

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Apr 23, 2007 at 09:43 AM

    Hi Sahil,

    Depending onthe type of data and the amount of data we can choose the best method.

    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.

    What type of data we transfer using LSMW?

    LSMW is best suited for transferring master data.

    Actually BDC and LSMW are not comparable at all.

    for example LSMW itself can use BDC as a way of mass data transfer.

    BDC is a mass data transfer technique via screen logic of existing SAP Data entry transactions. It behaves as if you are manually making thousand of entires into sap system as a background job. And that is probably the reason why BAPI's are preffered over BDC's.

    On the other hand LSMW is a tool to facilitate DATA migration from other legacy systems ... It contains step by step procedure for data migration.

    Like Managing Data Migration Projects , Creating Source Structures , Mapping Source structures wid Target structures , etc etc

    LSMW internally might well be using the following techniqes for data transfer..

    1. IDOX

    2. Direct Input / BDC

    4. BAPI's

    LSMW is an encapsulated data transfer tool. It can provide the same functionality as BDC infact much more but when coming to techinical perspective most the parameters are encapulated. To listout some of the differences :

    LSMW is basicaly designed for a fuctional consultant who do not do much coding but need to explore the fuctionality while BDC is designed for a technical consultant.

    LSMW offers different techinque for migrating data: Direct input ,BAPI,Idoc,Batch input recording. While bdc basically uses recording.

    LSMW mapping is done by SAP while in BDC we have to do it explicitly .

    LSMW is basically for standard SAP application while bdc basically for customized application.

    Coding can be done flexibly in BDC when compared to LSMW

    "The Data Transfer Workbench (or DX Workbench, transaction SXDA) is an integrated SAP tool that supports data transfer and analysis. It

    does not have the built-in features for mapping for source structures to target structures, but it will allow you to integrate Legacy System Migration Workbench (LSMW) objects as processing tasks within a run definition. The DX workbench has many features for creating

    test data and performing data migrations - for example, logging of data migration runs.

    However, if you need to map or convert data, you should use the LSMW. Or, you can integrate

    your LSMW objects as task within a more user-friendly data migration run, in which the LSMW

    project steps "Read data", "Convert data," and "Start IDoc processing" are automated

    and use the features of both tools. If you donot need logging and automated data migration

    runs, you can perform your data migration without the DX Workbench."

    Hope this resolves your query.

    <b>Reward all the helpful answers.</b>


    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Apr 23, 2007 at 11:14 AM


    We use Lsmw to upload large amount of data.we use LSMW for standard tcodes and predefined objects.Almost 60% logic will be provided by system and error handling is also very easy.

    LSMW supports Session method and Direct Input only.It doesn't support all Transaction method.We can use BAPI's and IDoc's also.

    BDC is used for custom tcodes and applications.we can transfer large as well as small amount of data.large coding is requried.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Apr 23, 2007 at 10:06 PM


    LSMW can be used for both large and small amout of data transfers.

    The major difference between LSMW and BDC is that LSMW is not suited for frequent data transfer.For instance transactional data.

    LSMW and BDC are vastly different.

    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.




    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.