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