SAP Basis – Master data load

My query is reg. master data load in SAP R/3. We have to load 4 million Asset Master records and the client wants to have an estimate of, how much time it will take for the data load. Our DB server has 16 GB of RAM with 16 x 550 Mhz of CPU. For Assets we will have a seperate Application Server (HP) with 1000 SAPs. How to make such an estimate without a trail run as we are not in build phase and we are only in Solution Definition phase. Ofcourse around 50 % + / - is acceptable. The client just needs to have an idea to plan for the downtime. I could not find any such benchmark figures in SAP Quicksizer Thanks and regards U.S.Varadharajan SAP Basis consultant

Answer Wiki

Thanks. We'll let you know when a new response is added.

First I wonder why there should be a “downtime” at all? Normally loading data does not require to be executed in any kind of standalone mode.
Second, the time for loading the data depends on the method choosen to load the data. When inserting the records directly into the database tables with open sql will be faster than loading the data via bapi or direct input programs.
Third, the complexity of the master data is determining in some way the time requirement for loading. When only the minimal data content is loaded, the load will be faster than with fully filled data structures.
Intuitively I would roughly estimate a load time between 4 and 8 hours as an average. I’m eager for other experts’ opinions.

Discuss This Question: 4  Replies

There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • Getmygto
    Heiner has some good points. I have used the CATT tool to load/update materials. The transactions averaged between 5-10 seconds depending on qualtity of attributes. Again, there is no downtime although SAP will lock the material/asset during creation/edit. Good luck
    5 pointsBadges:
  • Ssarnath
    Heiner is right in all respects. The only reason I see a downtime is when you have to take snapshot before and after a load is done. I have been involved in some conversion projects and we used to take snapshots after some selected milestone acheivement (identified by us). Other than this I do not see a downtime. You will have to verify the type of load (BDC, DBload, Idocs, BAPIs) to determine the processing time.
    0 pointsBadges:
  • usvaradharajan
    Thank you very much for all of you for the prompt reply. It was very useful input for me. Best regards U.S.Varadharjaan
    0 pointsBadges:
  • Marcsw
    Hey, I've migrated asset master with a client using - batch input: 10 transaction per minute - direct input: 100-200 transaction/minute. Since both methods are not longer proposed (you should use BAPI instead), the performance may differ. You should NEVER write direct to the database, as you may get rid of the SAP support, or in case of trouble there may incurr some penaltys. Basicly no downtime (except for backup and reconciliation purposes) is required. Kind regards...Marc
    0 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.


Share this item with your network: