Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Warning when selecting from RESB

Former Member
0 Kudos

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

1 REPLY 1

Former Member
0 Kudos

hi L Raghunahth ,

See in your select statement....i made a chege it may works...

use single codes ( ' ' )then space for check for blank in that field...and in WHERE (RSNUM = CAUFV-RSNUM) before that user Inner join for CAUFV table...it may also cause a problem.

like :

SELECT * FROM RESB INNER JOIN CAUFV ON

RESBRSNUM = CAUFVRSNUM

WHERE RSNUM = CAUFV-RSNUM

AND NO_DISP = ' '

AND FLGEX NE ' '

OR DBSKZ = 'F'.

or go for this Statement

SELECT * FROM RESB WHERE RSNUM = CAUFV-RSNUM

AND NO_DISP = ' '

AND FLGEX NE ' '

OR DBSKZ = 'F'.

Souman

Message was edited by:

Souman Halder