BAPI inside LOOP having Performance Issue

[viva_kd]

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.

[RaymondGiuseppi · Accepted solution]

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

[viva_kd · Accepted solution]

thanks Raymond, will do that and update once again.

[RaymondGiuseppi · Accepted solution]

Also consider some parallelization to execute so many records

[r_lindemann]

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).

[viva_kd]

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