topic performance issue in Application Development and Automation Discussions

performance issue

Former Member — Thu, 17 Jul 2008 13:28:50 GMT

Hi,

My program i am using FMIFIIT,FMIOI,BSEG,BKPF tables it take time to retrivee data.In select statement i am using index ,primarykey,for all entries still it take time.Can you tell me any other option to reduce time.

Thanks,

Deesanth

Re: performance issue

Former Member — Thu, 17 Jul 2008 13:33:31 GMT

Post the SELECT statement(s) here if you think they can be optimised further. Have you done any performance analysis against the code, removing loops within loops, etc ?

Re: performance issue

Former Member — Thu, 17 Jul 2008 14:01:26 GMT

hi,

do not access BSEG table directly. use FM FI_DOCUMENT_READ. get the data from BKPF first and the use the FM to retrieve the data from BSEG. it will definitely improve the performance. I have done the same in my code.

regards,

madhu

Re: performance issue

Former Member — Thu, 17 Jul 2008 14:16:39 GMT

There is absolutely no performance problem accessing BSEG direcltly if you know BUKRS, BELNR and GJAHR.

Rob

Re: performance issue

Former Member — Fri, 18 Jul 2008 00:34:18 GMT

Try to delete duplicated records on the comparison table with FOR ALL ENTRIES.

[https://wiki.sdn.sap.com/wiki/display/ABAP/Performance|https://wiki.sdn.sap.com/wiki/display/ABAP/Performance]

Hope this would help you.

Regards

Re: performance issue

Former Member — Fri, 18 Jul 2008 10:49:18 GMT

Hi Rob,

I actually used Select on BSEG pasisng BELNR, GJAHR AND BUKRS in one of the my programs. The report was taking 1.5 hrs to execute. So, I was given an option to use the FM mentioned and the time taken was reduced to 25mins(approx).

Regards,

Madhu

Re: performance issue

Former Member — Fri, 18 Jul 2008 13:11:15 GMT

I'd like to see the before and after code.

Rob

Re: performance issue

aarif_baig — Sat, 19 Jul 2008 08:36:03 GMT

Hi.

See make sure whenever you r using all entries

use sy-subrc.

That wiil definitely increase the speed.