performance issue

[Former Member]

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

[Former Member]

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 ?

[Former Member]

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

[Former Member]

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

Rob

[Former Member]

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

[Former Member]

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

Rob

[Former Member]

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

T4

[aarif_baig]

Hi.

See make sure whenever you r using all entries

use sy-subrc.

That wiil definitely increase the speed.