topic Re: help needed in Application Development and Automation Discussions

help needed

Former Member — Mon, 25 Sep 2006 06:58:00 GMT

Hi expert,

i have written this code to fetch data from knvp table

select kunnr parvw kunn2 vkorg

from knvp

into table i_knvp

for all entries in i_knb1

where vkorg = p_vkorg

and parvw = 'RG'.

but it shows syntax error table: The WHERE condition does not refer to For All entries

please guide me how to write select statement.

Thanks,

venkat

Re: help needed

Former Member — Mon, 25 Sep 2006 06:59:13 GMT

select kunnr parvw kunn2 vkorg

from knvp

into table i_knvp

for all entries in i_knb1

where vkorg = i_knb1-vkorgand parvw = 'RG'.

Re: help needed

Former Member — Mon, 25 Sep 2006 07:01:05 GMT

in where cond u have to write cond in which data fetch from table knvp on the basis of i_knb1.

search the field which is common in both

for ex.

for all entries in i_knb1

where field1 = i_knb1-field1

vkorg = p_vkorg

and parvw = 'RG'.

Re: help needed

Former Member — Mon, 25 Sep 2006 07:01:29 GMT

Hi Ravi RAJAN,

there is no VKORG field in knb1 table.

please help me.

thanks,

venkat

Re: help needed

Former Member — Mon, 25 Sep 2006 07:02:02 GMT

Here u r using for all entries in i_knb1 and not using any of the refrence from this table in where cndition due to this u r getting error..

U have to modify this as follows:

If i_knb1[] is not initial.

select kunnr parvw kunn2 vkorg

from knvp

into table i_knvp

for all entries in i_knb1

where vkorg = p_vkorg ====>Here use some key ==================fields from ur i_knb1 ..

and parvw = 'RG'.

ENdif.

Re: help needed

anversha_s — Mon, 25 Sep 2006 07:02:46 GMT

hi venkat,

select kunnr parvw kunn2 vkorg

from knvp

into table i_knvp

for all entries in i_knb1

where vkorg = i_knvp-p_vkorg

and parvw = 'RG'.

rgds

anver

pls mark hlpful answers

Re: help needed

Former Member — Mon, 25 Sep 2006 07:03:27 GMT

hi Venkat,

The syntax is

FOR ALL ENTRIES IN itab WHERE ... col operator itab-comp ...

it means that in where condition u should use field from the internal table which u r using in for all wntries in

i_knb1.

Otherwise it will give u error like this.

Try out this .

-Umesh

Re: help needed

Former Member — Mon, 25 Sep 2006 07:04:53 GMT

Hi Venkat,

If you are using FOR ALL ENTRIES then you need to specify some common field between the two tables(KNVP and I_KNB1)in your WHERE clause.

This would be the reason for the error.

Regards,

Saurabh

Re: help needed

Former Member — Mon, 25 Sep 2006 07:07:32 GMT

Hi kishan negi,

Thanks a lot.

regards,

venkat

Re: help needed

Former Member — Mon, 25 Sep 2006 07:08:40 GMT

the proble is

where vkorg = p_vkorg

u can change

vkorg = itab1-vkorg.