topic Re: select statement in Application Development and Automation Discussions

select statement

Former Member — Thu, 24 Aug 2006 10:08:30 GMT

I used select statement in my coding as"

select kunnr parvw kunn2 pernr

into table loc_int_knvp

from knvp for all entries in t_reqd

where kunnr = t_reqd-kunnr

and ( parvw = wc_zn or parvw = wc_zi ).

But performance point of view it is taking somuch time .

So could u please give any alternative solution for that

Please send to jonam38@yahoo.co.in urgently

Re: select statement

Former Member — Thu, 24 Aug 2006 10:14:13 GMT

IF you are using FOR ALL ENTRIES addition to SELECT first check that table is not initial.

<b>if t_reqd[] is not initial.</b>
select kunnr parvw kunn2 pernr 
into table loc_int_knvp 
from knvp for all entries in t_reqd 
where kunnr = t_reqd-kunnr 
and ( parvw = wc_zn or parvw = wc_zi ). 
<b>endif.</b>

Re: select statement

Former Member — Thu, 24 Aug 2006 10:15:14 GMT

sort the t_reqd table on kunnr field before the select.

sort t_reqd by kunnr.

select kunnr parvw kunn2 pernr

into table loc_int_knvp

from knvp for all entries in t_reqd

where kunnr = t_reqd-kunnr

and ( parvw = wc_zn or parvw = wc_zi ).

REgards,

Ravi

Re: select statement

Former Member — Thu, 24 Aug 2006 10:15:19 GMT

put like this.

if t_redq[] is not initial.

select kunnr parvw kunn2 pernr

into table loc_int_knvp

from knvp for all entries in t_reqd

where kunnr = t_reqd-kunnr

and ( parvw = wc_zn or parvw = wc_zi ).

endif.

and check WC_ZN also.

Regards

Prabhu

Re: select statement

Former Member — Thu, 24 Aug 2006 11:24:21 GMT

good

wrong->

select kunnr parvw kunn2 pernr

into table loc_int_knvp

from knvp for all entries in t_reqd

where kunnr = t_reqd-kunnr

and ( parvw = wc_zn or parvw = wc_zi ).

write->

select kunnr parvw kunn2 pernr

into corresponding fileds of table loc_int_knvp

from knvp for all entries in t_reqd

where kunnr = t_reqd-kunnr

and ( parvw = wc_zn or parvw = wc_zi ).

it may reduse of the original time period as itis taking now .

thanks

mrutyun