Skip to Content
0
Former Member
Jan 10, 2007 at 08:21 AM

Warning when selecting from RESB

229 Views

Hi Experts,

Below query is giving a warning while doing a syntax check.

SELECT * FROM RESB WHERE RSNUM = CAUFV-RSNUM

AND NO_DISP = SPACE

AND FLGEX NE SPACE

OR DBSKZ = 'F'.

Warning : The field "FLGEX" used in the WHERE condition may contain NULL values.

This warning appears for all selects on RESB table that is an indexed table where selects are done based on AUFPL or APLZL or VORNR or FLGEX.

If only the key fields are used no warning appears and also, the other fields in the above select NO_DISP and DBSKZ give no problem.

They have a customixed secondary index on this table, non unique for columns MANDT and AUFPL.

There is also another INDEX which i think is standard.

Just need your help to find out why this warning appears and is there any solution.

Thanks in advance.

Regards

Raghunahth L