Select performance and its runtime

[Former Member]

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

[Former Member]

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

[Former Member]

can u just brief what urs requirment

[Former Member]

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