ABAP sql with null variable

[Former Member]

Hi

How to in SQL query add filter to get all record not NULL.

I have a field BELNR and this have value ' '

but in SQL WHERE belnr not equal ' ' OR NOT NULL

don't get me all records with not null values.

Edited by: Kosmo on Feb 23, 2009 1:01 PM

[Former Member]

Hi Kosmo,

What is the table you are using ?

Try it this way

SELECT *
FROM BSEG
INTO TABLE IT_BSEG UP TO 10 ROWS
WHERE BELNR NE space.

Regards

Edited by: Rajvansh Ravi on Feb 23, 2009 1:09 PM

[Former Member]

hi:

use as

WHERE not belnr is initiai.

Regards

Shashi

[Former Member]

hi:

use as

WHERE not belnr is initial.

Regards

Shashi