Syntax check warning key field "DATAB" does not test for equality

[Former Member]

Hii guyz..

Need help...!

I am not able to get rid of this warning...

Syntax check warning

This warning is only displayed in SLIN.

In "SELECT SINGLE ...", the WHERE condition for the key field "DATAB" does not test for equality. Therefore, the single record in question may not be unique.

Here is the code...

SELECT SINGLE hkunnr

FROM knvh

INTO v_hkunnr

WHERE hityp EQ c_a

AND kunnr EQ wa_kna1-kunnr

AND vkorg EQ c_4315

AND vtweg EQ c_zero2

AND spart EQ c_zero2

AND datbi GE sy-datum

AND hkunnr NE space.

What do I do with this variable .

Please help...

Thanks

....Jaif

[Former Member]

hi

in where condition u just add that field , u ll not get that.

if u dont know the value for that, just ognore it.

regards

karthik

[Former Member]

Hi Jaif

Since you are not using all the primary keys..please use

SELECT ...UP TO 1 ROWS ..instead of select single

Regards

Arun