7 Replies Latest reply: May 13, 2011 6:03 AM by shammi murthy RSS

Migrating Absence quota data to SAP

shammi murthy
Currently Being Moderated

I am working on a SAP-HR project, which has completed the UAT phase. We are preparing for the u201CGo Liveu201D phase.  As  part of the legacy data migration, we need to migrate the leave balances. Only one absence quota (u201CEarned Leave (EL)) is applicable for all the employees. As per the requirement, the quota generation should be done on 1 Jan of every year, based on the employee attendance days during the previous year. What is the transaction data required by SAP system for uploading into SAP? As per my understanding, the quota balance as on the u201CGo Liveu201D date for every personnel number should be made available in the Excel  file format. Am I right?

Also, I do not know how much about BDC or LSMW, the data migration tools used for downloading/uploading data from/to SAP.  I will try to learn these tools & then come with queries if any. However, at this point, I would like to know which tool is ideal for my scenario above. Is it BDC or LSMW? (so that I can learn that tool first).  The customer has about 700 employees on rolls.



  • Re: Migrating Absence quota data to SAP
    Teresa Su
    Currently Being Moderated

    Hi Friend,


    LSMW is best tool if you know how to do it, if u do not know record the process and give ABAP team to develop BDC.




  • Re: Migrating Absence quota data to SAP
    Lata K
    Currently Being Moderated



    You can do it throgh LSMW.


    There is no differene whether we use LSMW or BDC for data upload.





  • Re: Migrating Absence quota data to SAP
    Prasanth Puthuveedu
    Currently Being Moderated



    This req you can do in three different way's


    1. LSMW

    2 .BDC

    3. By using the function module HR_INFOTYPE_OPERATION


    Differences between LSMW and BDC


    Batch Data Communication (BDC) is the oldest batch interfacing technique that SAP provided since the early versions of R/3. BDC is not a

    typical integration tool, in the sense that, it can be only be used for uploading data into R/3 and so it is not bi-directional.

    BDC works on the principle of simulating user input for transactional screen, via an ABAP program. Typically the input comes in the form

    of a flat file. The ABAP program reads this file and formats the input data screen by screen into an internal table (BDCDATA). The

    transaction is then started using this internal table as the input and executed in the background.


    In Call Transaction, the transactions are triggered at the time of processing itself and so the ABAP program must do the error handling.

    It can also be used for real-time interfaces and custom error handling & logging features. Whereas in Batch Input Sessions, the ABAP

    program creates a session with all the transactional data, and this session can be viewed, scheduled and processed (using

    Transaction SM35) at a later time. The latter technique has a built-in error processing mechanism too.


    Batch Input (BI) programs still use the classical BDC approach but doesnt require an ABAP program to be written to format the

    BDCDATA. The user has to format the data using predefined structures and store it in a flat file. The BI program then reads this and

    invokes the transaction mentioned in the header record of the file.


    Direct Input (DI) programs work exactly similar to BI programs. But the only difference is, instead of processing screens they validate

    fields and directly load the data into tables using standard function modules. For this reason, DI programs are much faster (RMDATIND - Material Master DI program works at least 5 times faster) than the BDC counterpart and so ideally suited for loading large volume data. DI programs are

    not available for all application areas.



    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


    Any issues reply back




  • Re: Migrating Absence quota data to SAP
    Jailakshmi Advani
    Currently Being Moderated



    I would suggest using LSMW as it is easier to use and you will not be dependent on any ABAPer.


    Once you learn the LSMW it will be helpful in many other scenario's too.


    Thanks and regards,


  • Re: Migrating Absence quota data to SAP
    Harshal Soni
    Currently Being Moderated

    LSMW is the best tool for a functional consultant...


    to learn LSMW you can use this link: http://wise.winshuttle.com/ input the search parameter as LSMW and download the pdf by Mitresh Kundalia


    You can try search by his name in google too and see if you find something... His article on LSMW is very good

  • Re: Migrating Absence quota data to SAP
    shammi murthy
    Currently Being Moderated

    Thanks to all for the info & help provided