cancel
Showing results for 
Search instead for 
Did you mean: 

BAPI inside LOOP having Performance Issue

viva_kd
Participant
0 Kudos
183

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.

viva_kd_1-1720509963147.png

 

Accepted Solutions (1)

Accepted Solutions (1)

raymond_giuseppi
Active Contributor

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
Participant
0 Kudos
thanks Raymond, will do that and update once again.
raymond_giuseppi
Active Contributor
0 Kudos

Also consider some parallelization to execute so many records

Answers (1)

Answers (1)

r_lindemann
Explorer

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
Participant
0 Kudos
As there was no escape from BAPI, we went for Parallel Processing.