Question Re: BAPI inside LOOP having Performance Issue in Technology Q&A

BAPI inside LOOP having Performance Issue

viva_kd — Tue, 09 Jul 2024 07:33:14 GMT

Dear Experts,

My Report taking 8 hours to execute , as it has 3 Lakhs of Data. and inside loop its runing BAPI

"BAPI_CTRACCONTRACTACCOUNT_GBAL" , along with this many loops there. but when i find out exact reason, is this FM and specially thru SAT/SE30 got to know "WAIT for RFC" process taking much time,

any idea , how to suppress this "WAIT for RFC" processing.

Note : All Peformance Improvement Logic already applied and i looking answer regarding this BAPI and my functional told , if we go thru daa fetching from Database table, it will will again painstaking job.

Re: BAPI inside LOOP having Performance Issue

RaymondGiuseppi — Tue, 09 Jul 2024 08:23:25 GMT

Could you reduce the number of call of FM SAPGUI_PROGRESS_INDICATOR (RFC connexion to SAP GUI)

e.g. Only call it when percentage actually changed
Else identify any other RFC call by filtering on performance/trace display

Re: BAPI inside LOOP having Performance Issue

viva_kd — Tue, 09 Jul 2024 08:45:23 GMT

thanks Raymond, will do that and update once again.

Re: BAPI inside LOOP having Performance Issue

r_lindemann — Wed, 10 Jul 2024 12:50:17 GMT

Without really knowing what you're trying to accomplish, I think you might be having a design problem. The BAPI you're calling reads a lot of data from a lot of tables, and can easily take several 100 milliseconds, depending on many factors. So, if you're really calling this 300'000 times, it is bound to take a moment (100 milliseconds x 300'000 = 8 hours).

Re: BAPI inside LOOP having Performance Issue

RaymondGiuseppi — Wed, 10 Jul 2024 12:59:13 GMT

Also consider some parallelization to execute so many records

Re: BAPI inside LOOP having Performance Issue

viva_kd — Fri, 12 Jul 2024 05:03:00 GMT

As there was no escape from BAPI, we went for Parallel Processing.