Home > IT Answers > SAP > SAP Basis – Master data load
usvaradharajan
0 pts.
 SAP Basis – Master data load
SAP
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

Software/Hardware used:
ASKED: October 5, 2004  12:16 AM
UPDATED: October 6, 2004  11:40 AM
RELATED QUESTIONS
Answer Wiki:
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.
Last Wiki Answer Submitted:  October 5, 2004  4:16 am  by    0 pts.
All Answer Wiki Contributors:    0 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

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

Getmygto
 5 pts.
 

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.

Ssarnath
 0 pts.
 

Thank you very much for all of you for the prompt reply. It was very useful input for me.
Best regards
U.S.Varadharjaan

usvaradharajan
 0 pts.
 

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

Marcsw
 0 pts.