topic Re: Performance tuning in Application Development and Automation Discussions

Performance tuning

Former Member — Tue, 13 Feb 2007 04:29:48 GMT

Hi,

I am creating a report which has tables like bsik, bsak, bseg, bkpf, rbkp. vbrk, likp. The report is taking too long to execute.

Also, when i enter the selection parameters, the reports hangs. On the other hand the reports runs faster with no selection parameter entered.

Can anyone let me know what could be the problem be?

Thanks,

Amit.

Re: Performance tuning

Former Member — Tue, 13 Feb 2007 04:38:13 GMT

Analyse the program and optimize the program

https://wiki.sdn.sap.com/wiki/display/HOME/ABAPPerformanceand+Tuning#ABAPPerformanceandTuning-WhatarethestepstooptimisetheABAPCode%3F

Please make your question more clear if you need a quick response.

Thanks

Wenceslaus

Re: Performance tuning

Former Member — Tue, 13 Feb 2007 04:40:23 GMT

Make sure that u have used the key fields in the query for retrieving data.

So that it will be faster.

Paste ur select query here.

Re: Performance tuning

anversha_s — Tue, 13 Feb 2007 05:06:49 GMT

hi,

chk this.

http://www.thespot4sap.com/Articles/SAPABAPPerformanceTuning_PerformanceAnalysisTools.asp

https://www.sdn.sap.com/irj/sdn/wiki?path=/display/home/abapPerformanceand+Tuning&

http://www.erpgenie.com/abap/performance.htm

http://www.sap-img.com/abap/performance-tuning-for-data-selection-statement.htm

https://www.sdn.sap.com/irj/sdn/wiki?path=/display/home/abapPerformanceand+Tuning&

http://help.sap.com/saphelp_nw2004s/helpdata/en/c6/617cafe68c11d2b2ab080009b43351/frameset.htm

http://help.sap.com/saphelp_nw2004s/helpdata/en/d1/801f7c454211d189710000e8322d00/frameset.htm

Regards,

Anver

Re: Performance tuning

Former Member — Tue, 13 Feb 2007 05:11:12 GMT

Hi,

I emailing my code below. Please let me know which part of the code can be improved.

Thanks,

Amit.

SELECT belnr gjahr bukrs lifnr ebeln ebelp vbeln FROM bseg

INTO TABLE i_bseg

FOR ALL ENTRIES IN i_bsik

WHERE bukrs EQ i_bsik-bukrs

AND belnr EQ i_bsik-belnr

AND gjahr EQ i_bsik-gjahr.

SELECT bukrs gjahr xblnr belnr FROM bkpf INTO TABLE i_bkpf

FOR ALL ENTRIES IN i_bseg

WHERE bukrs EQ i_bseg-bukrs

AND belnr EQ i_bseg-belnr

AND gjahr EQ i_bseg-gjahr.

ENDIF.

SELECT belnr waers bukrs FROM RBKP INTO TABLE i_rbkp

FOR ALL ENTRIES IN i_bkpf

WHERE gjahr EQ i_bkpf-gjahr

AND bukrs EQ i_bkpf-bukrs

AND xblnr EQ i_bkpf-xblnr.

Re: Performance tuning

anversha_s — Tue, 13 Feb 2007 05:16:35 GMT

hi,

1. chk the itab

i_bsik

is initial or not before the select query.

2. Same in the case of

i_bseg

and

i_bkpf

Otherwise it looks ok.

eg:

if i_bsik[] is not initial.

SELECT belnr gjahr bukrs lifnr ebeln ebelp vbeln FROM bseg
INTO TABLE i_bseg
FOR ALL ENTRIES IN i_bsik
WHERE bukrs EQ i_bsik-bukrs
AND belnr EQ i_bsik-belnr
AND gjahr EQ i_bsik-gjahr.

endif.

Regards

Anver

Re: Performance tuning

Former Member — Tue, 13 Feb 2007 05:26:14 GMT

y u r using bseg . u r already fetch data for vendor from table bsik.check the functionality again of ur requirment.

Re: Performance tuning

Former Member — Tue, 13 Feb 2007 06:50:54 GMT

hi amit

check the order of the fields in select statement,it should match with the order in the data dictionary.the oredr should be bukrs,belnr,gjahr....

check it...

Re: Performance tuning

Former Member — Wed, 14 Feb 2007 10:55:48 GMT

Hello Amit,

Please check the internal table whether it is initial or not. Because using internal table against FOR ALL ENTRIES with empty records will fetche all the records from the matching tables.

Regs,

Venkat Ramanan N