Skip to Content
0
Former Member
Dec 31, 2007 at 09:32 AM

Performance Tunning

35 Views

Hi Friends,

I have an ZREPORT in SD, its taking long time during execution, so in T-code : SE30 i had done its run time analysis the readings where,

ABAP -


85 %

DB -


10 %

system---- 5 %,

i also done the sql trace in ST05 , its showing maximum time taken for the select statement given below ( down )

SELECT avbeln aauart a~audat

akunnr abstnk a~bstdk

avtweg avkorg a~knumv

awaerk bwerks b~pstyv

bposnr bmatnr b~kwmeng

bnetpr cspart c~extwg

cferth cmtart d~maktx

hlfsta hlfgsa e~kdgrp

fname1 fort01 g~country

j~sort1

INTO CORRESPONDING FIELDS OF TABLE it_result

FROM vbak AS a

INNER JOIN vbap AS b ON avbeln = bvbeln

INNER JOIN mara AS c ON cmatnr = bmatnr

INNER JOIN makt AS d ON dmatnr = bmatnr

INNER JOIN knvv AS e ON ekunnr = akunnr

INNER JOIN kna1 AS f ON fkunnr = ekunnr

INNER JOIN adrc AS g ON gADDRNUMBER = fadrnr

INNER JOIN vbup AS h ON bvbeln = hvbeln AND

bposnr = hposnr

INNER JOIN t001w AS i ON bwerks = iwerks

INNER JOIN adrc AS j ON iadrnr = jaddrnumber

WHERE a~vkorg EQ pr_vkorg AND

a~vtweg EQ pr_vtweg AND

a~auart IN so_auart AND

a~audat IN so_audat AND

a~vbeln IN so_vbeln AND

b~werks IN so_werks AND

b~abgru EQ ' ' AND

a~kunnr IN so_kunnr AND

f~name1 IN so_name1 AND

e~kdgrp IN so_kdgrp AND

g~country IN so_ctry AND

b~matnr IN so_matnr AND

d~maktx IN so_maktx AND

c~spart IN so_spart AND

c~ferth IN so_ferth AND

c~mtart IN so_mtart.

i have also created an INDEX for table VBAK for the fields used in these select statement.

SO what should i do to improve the analysis,,,,, and what should be the normal readings of ABAP DB and system values in SE30.

or should i change the select satatement

Regards

Kumar M