‎2007 Sep 11 9:04 AM
Hello
i've been given the task to create a large (50000+) user in a sap R/3 system, using info from another system.
The program is working fine, up to a point : on a small number of user, the program works flawlessly. However, on a large number, it begin to slow after 200 user, and after 800 user create, it takes nearly 1 minute to create a new user.
internal table are freed whenever its possible. No append are done on such table : they are allocated at the start of the program. i can't seem to find what's the problem on this one.
we are using BAPI_USER_CREATE1 to create these user.
doe anyone have a suggestion on this subject ?
regards
‎2007 Sep 11 9:08 AM
Hi!
Are you using the BAPI_TRANSACTION_COMMIT function module after each BAPI_USER_CREATE1 call?
You might try out to use the BAPI_TRANSACTION_COMMIT with the wait = 'X' parameter also...
The creation time should be a bit lower, but constant for each user...
Regards
Tamá
‎2007 Sep 11 9:08 AM
Hi!
Are you using the BAPI_TRANSACTION_COMMIT function module after each BAPI_USER_CREATE1 call?
You might try out to use the BAPI_TRANSACTION_COMMIT with the wait = 'X' parameter also...
The creation time should be a bit lower, but constant for each user...
Regards
Tamá
‎2007 Sep 11 11:00 AM
thanks a lot. we where not aware of this bapi... it works perfectly.
Eventually, by calling it only every 25 creation or so, we will limit the small hit we took for each user, but this will be done only if there a optimisation need.
thanks again for the solution
Best Regards
‎2007 Oct 05 2:12 AM
Hi Johann
I am very new to SAP. As a matter of fact, I have only completed the SAP - Programming last month. At the moment, I am still learning the new SAP stuff.
My SAP admin has given me a task (to create a large no of users) from an excel spread sheet - The task is mimilar to yours. I am wondering if you don't mind - Could I have a copy of your program So I can learn the way you do it - I will be very much appreciated if you could send me a copy. my email address is "liem_van_duong@leaseplan.com.au" - Thanks