topic Re: Performance when call BAPI_SALESORDER_CHANGE ? in Application Development and Automation Discussions

Performance when call BAPI_SALESORDER_CHANGE ?

Former Member — Tue, 02 Dec 2008 13:58:48 GMT

Hi, All:

When I call the following function module to update partner associated to contract.

If there are about 30,000 partner associated this one contract. Updating performance is too bad.

Is there any good idea to improve performance for this case.

CALL FUNCTION 'BAPI_SALESORDER_CHANGE'

EXPORTING

salesdocument = v_vbeln ( contract number)

order_header_inx = li_bapi_ord_indx

TABLES

return = li_bapi_return

partnerchanges = li_partnerchanges. ( partners )

Any help is appreciated!

Re: Performance when call BAPI_SALESORDER_CHANGE ?

Former Member — Tue, 02 Dec 2008 14:06:48 GMT

how much time are you gettign now? there are 30K partners with one contract, so it is going to take time.

Re: Performance when call BAPI_SALESORDER_CHANGE ?

Former Member — Tue, 02 Dec 2008 14:07:46 GMT

It took long time about 2hrs. thanks.

Re: Performance when call BAPI_SALESORDER_CHANGE ?

Former Member — Tue, 02 Dec 2008 14:14:00 GMT

30k partners is a very big number, but u should try to understand where are the bottle necks, we can't help you without to know where the problem is.

Perhaps a your custom control in some user-exits could be the problem.

Max

Re: Performance when call BAPI_SALESORDER_CHANGE ?

Former Member — Tue, 02 Dec 2008 14:28:16 GMT

use SE30 in there to find the bottlebnecks as Max mentioned. if its one of your own code, then see what you can do there. if its SAP, then I guess you have to live with that

Re: Performance when call BAPI_SALESORDER_CHANGE ?

Former Member — Tue, 02 Dec 2008 14:34:35 GMT

Actually, changing 30,000 sales orders in 2 hours sounds pretty good to me. You might try splitting it into multiple processes, but then you might end up with locking issues.

Rob

Re: Performance when call BAPI_SALESORDER_CHANGE ?

Former Member — Mon, 12 Jan 2009 21:58:14 GMT

closed