topic Re: Error in SELECT : unknown field in Application Development and Automation Discussions

Error in SELECT : unknown field

Former Member — Wed, 14 Mar 2007 10:34:05 GMT

Hi,

I'm getting strange compiler error by a simple SQL-Statement:

select * from KNVP into table CST_KNVP
  where KUNNR <> KUNN2.

Compiler complains that the Field KUNN2 is unknown.

If I write

where KUNN2 <> KUNNR.

it complains about KUNNR.

Strange, because both fields ARE in the KNVP table.

Do You have some advice how to deal with it?

Thanks in Advance

Daniel

Re: Error in SELECT : unknown field

Former Member — Wed, 14 Mar 2007 10:36:42 GMT

Hi,

i must declare KUNN2 in your program.

Regards,

Re: Error in SELECT : unknown field

Former Member — Wed, 14 Mar 2007 10:36:50 GMT

Hello Daniel,

U can't give the selection condition like this.

Change the code like this.


select * from KNVP into table CST_KNVP
  where KUNNR IN SO_KUNNR.     " From selection screen
loop at cst_KNVP.
if cst_KNVP-kunnr = cst_KNVP-kunn2.
delete cst_KNVP.
endif.
endloop.

Hope it helps you.

Regards,

Vasanth

Re: Error in SELECT : unknown field

Former Member — Wed, 14 Mar 2007 10:37:24 GMT

Hi,

In the select statements, all the fields mentioned on teh left handside of the where condition are known to the select statement, but the fields mentioned on the right hand side are unknown to the select statement.

That is why you are getting error.

You have use some selection screen field or some field which is already defined in the right hand side of the where condition.

Regards,

Anji

Re: Error in SELECT : unknown field

Former Member — Wed, 14 Mar 2007 10:37:26 GMT

use FM conversion_exit_alpha_input

cause 0001230133 = 1230133 ( wrong )

0001230133 = 0001230133 ( correct )

This check has to be carried out .

before the select convert the rhs value of Kunnr to compatible of lhs of where clause .

regards,

vijay

Re: Error in SELECT : unknown field

Former Member — Wed, 14 Mar 2007 10:37:48 GMT

Try this...

Report ytest.

parameters : p_kunnr for knvp-kunnr default '1000000'.

data : begin of CST_KNVP occurs 0.
           include structure knvp.
data : end of CST_KNVP.

select * from KNVP into table CST_KNVP
  where KUNNR <> p_kunnr..

Re: Error in SELECT : unknown field

Former Member — Wed, 14 Mar 2007 10:39:36 GMT

but it is not giving me error

data kunn2 like knvp-kunn2 value '123'.

select * from KNVP into table CST_KNVP

where KUNNR <> KUNN2.

regards

shiba dutta

Re: Error in SELECT : unknown field

Former Member — Wed, 14 Mar 2007 10:41:05 GMT

Daniel,

your query is wrong.Syntaxt problem

select * from KNVP into table CST_KNVP

where KUNNR <> KUNN2.

How KUNN2 will availble to select statement?

You have to pass this value.

ex : you can use various ways

loop at itab.

select * from KNVP into table CST_KNVP

where KUNNR <> itab-KUNN2.

endloop.

2. select * from KNVP into table CST_KNVP

for all entries in itab

where KUNNR <> itab-KUNN2.

pls. reward if useful