Skip to Content
0
Former Member
Mar 14, 2007 at 10:34 AM

Error in SELECT : unknown field

619 Views

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