topic Re: Performance Issue with 'BAPI_USER_GET_DETAIL' DESTINATION in Application Development and Automation Discussions

Performance Issue with 'BAPI_USER_GET_DETAIL' DESTINATION

sreekanth_n2 — Mon, 01 Aug 2016 10:12:28 GMT

Hi Experts,

I have internal table having 20,000 records.

This internal table is looped and for every record the following BAPI is used:

CALL FUNCTION 'BAPI_USER_GET_DETAIL' DESTINATION lv_dest

Since this BAPI is being called for every record, it is taking 30 mins to come out from the loop.

IF this BAPI is commented then it takes only 2 sec but need user details hence cannot skip this BAPI.

Please let me know solution to overcome this performance issue.

Regards,

Sree

Re: Performance Issue with 'BAPI_USER_GET_DETAIL' DESTINATION

Sandra_Rossi — Mon, 01 Aug 2016 12:31:27 GMT

You can increase the performance using these 2 methods (can be combined) :

1) as you use RFC, avoid doing 20000 RFC calls, instead do only 1 call to a custom RFC-enabled function module, which calls the BAPI 20000 times locally.

EDIT :

As I read my answer a few days later, I realize that proposition "1" above is incorrect because it's not the purpose of RFC of doing mass processing as its execution is time-limited and should be short. So I propose another way:

1) Avoid doing 20000 RFC calls (RFC adds non-neglictible overhead) ; instead, you may run a background job on the RFCremote server, and query it from time to time until it's over.

2) BAPIs are great except when it's about mass processing and if the performance is bad. In this case, there are 2 ways to improve the performance :

either using directly SELECT instead of calling BAPIs,
or maybe you may keep your BAPIs, and add preliminary SELECT so that the database stores the whole data into memory, then the BAPIs will access these data more quickly,

Re: Performance Issue with 'BAPI_USER_GET_DETAIL' DESTINATION

Clemenss — Mon, 01 Aug 2016 16:41:43 GMT

Hi Sreekanth N,

BAPI_USER_GET_DETAIL is slow as every SAP function but not too slow.

As you do an RFC call, is it a remote system? If so, make sure the RFC connection is not estsablished for each and every SAP call. SAP will keep the RFC session in memory is the next call to and from the same system comes within a certain time (don't know eyactly but probably enough in your case).

Check your program if there is any call to functions RFC_CONNECTION_CANCEL or

RFC_CONNECTION_CLOSE. This should be avoided as it enforces reload of the program(s) which is performance-robbing,.

Also you can always try to make use of parallel processing to speed up the process.

Regards

Clemens

Re: Performance Issue with 'BAPI_USER_GET_DETAIL' DESTINATION

Former Member — Mon, 01 Aug 2016 18:56:40 GMT

Hi Sreekanth,

Based on the large number of destinations and information in ABAP Help, I suspect that 'STARTING NEW TASK IN GROUP' for 2000 records would be a better solution for Parallel processing as Clemens suggested. Please provide all the parameters required.

https://scn.sap.com/thread/3518253

Regards,

Hiran

Re: Performance Issue with 'BAPI_USER_GET_DETAIL' DESTINATION

Ashokv — Tue, 02 Aug 2016 12:02:36 GMT

Hi,

This FM may ultimately get values from tables i.e. USR* or US*. So you may also think of calling RFC_READ_TABLE in single call for 1 table at a time.

Thanks,

Ashok

Re: Performance Issue with 'BAPI_USER_GET_DETAIL' DESTINATION

sreekanth_n2 — Wed, 03 Aug 2016 13:38:38 GMT

HI Ashok, Can u share sample code on how to fetch user data for 20,000 users in single stretch with fm suggested by you

Re: Performance Issue with 'BAPI_USER_GET_DETAIL' DESTINATION

sreekanth_n2 — Wed, 24 Aug 2016 10:32:23 GMT

Improved the performance by implementing parallel processor techinque.

ealier it took 40 minutes to execute, post changes it took only 2 minutes to execute.