Select performance and its runtime

Former Member — Thu, 05 Feb 2009 06:00:43 GMT

hi,i have to fetch the vendor acc number and net value based on the date selection.

thbasic report contains company data,wen user clicks on a company,it displays the plantwise data,and wen the user clicks on any plant,it leads to next level storage locationwise report. now wen the user clicks on any location,it should display the supplier data.

here date is select-options and l_bukrs,l_werks and l_lgort are the user-clicked values in drilldown report...

Is the select statement works perfectly or shall i create any secondary index for this??. And how to get runtime for this select statement in my report itself??...

SELECT K~LIFNR

P~NETWR

INTO TABLE T_NET

FROM EKKO AS K INNER JOIN EKPO AS P

ON K_{EBELN = P}EBELN

WHERE K~BEDAT IN S_DATE AND

P~BUKRS = L_BUKRS AND

P~WERKS = L_WERKS AND

P~LGORT = L_LGORT.

Thanks,

Sri

Edited by: Sri on Feb 5, 2009 7:18 AM

Re: Select performance and its runtime

Former Member — Thu, 05 Feb 2009 11:49:54 GMT

can u just brief what urs requirment

Re: Select performance and its runtime

Former Member — Thu, 05 Feb 2009 14:18:04 GMT

You can add BSTYP to the WHERE with all of the domain values (that you want). That should make it use index EKKO~D.

Rob

topic Re: Select performance and its runtime in Application Development and Automation Discussions

Select performance and its runtime

Re: Select performance and its runtime

Re: Select performance and its runtime