topic Re: ABAP sql with null variable in Application Development and Automation Discussions

ABAP sql with null variable

Former Member — Mon, 23 Feb 2009 12:00:56 GMT

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 — Mon, 23 Feb 2009 12:09:24 GMT

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 — Mon, 23 Feb 2009 12:15:40 GMT

hi:

use as

WHERE not belnr is initiai.

Regards

Shashi

Former Member — Mon, 23 Feb 2009 12:15:56 GMT

hi:

use as

WHERE not belnr is initial.

Regards

Shashi