topic Re: tracking NULL values in Application Development and Automation Discussions

tracking NULL values

Former Member — Fri, 24 Nov 2006 15:38:17 GMT

Hi All,

there is a condition in a query where i have to check for a char field is NULL or not.

how do I do it ??

select count(*) into count1 from DFKKOP

WHERE blart = 'CO'

AND betrw < 0

and augbl is NULL.

the field 'augbl' is a char type field. when i write the above query, it gives me a incorrect result. actually i want to retrieve the field(augbl) where the field value in the table DFKKOP is a space.

plz tell me how to write the query in this case.

thanks..

prad

Re: tracking NULL values

Former Member — Fri, 24 Nov 2006 15:39:18 GMT

use INITIAL

select count(*) into count1 from DFKKOP
WHERE blart = 'CO'
AND betrw < 0
and augbl is INITIAL.

Re: tracking NULL values

uwe_schieferstein — Fri, 24 Nov 2006 15:40:23 GMT

Hello Prad

It should look like this:

select count(*) into count1 from DFKKOP
WHERE blart = 'CO'
AND betrw < 0
and augbl = space.

Regards

Uwe

Re: tracking NULL values

Former Member — Fri, 24 Nov 2006 15:40:38 GMT

select count(*) into count1 from DFKKOP

WHERE blart = 'CO'

AND betrw < 0

*and augbl is NULL

<b>and augbl eq space</b>

regards,

vijay

Re: tracking NULL values

Former Member — Fri, 24 Nov 2006 15:45:01 GMT

Here we go :

select count(*) into count1 from DFKKOP

WHERE blart = 'CO'

AND betrw < 0

and augbl = ' ' .

select count(*) into count1 from DFKKOP

WHERE blart = 'CO'

AND betrw < 0

and augbl IS INITIAL .

Cheers.

Re: tracking NULL values

Former Member — Fri, 24 Nov 2006 15:55:24 GMT

is INITIAL is used for NULL values ..... so that is not working ....

i have tried all the other options , such as space /' ' ......... none of the options are working ...

please let me know ur thoughts

Re: tracking NULL values

Former Member — Fri, 24 Nov 2006 16:06:06 GMT

hi pradipta,

just check the table BSIK with a valid entry of a vendor having more than 1 item ..

execute the code and cross check with the table entries this will give u a clear picture . also dfkkok is a structure cause im not able to see that in 4.6c.

data: count1 type i.

select count(*) into count1 from bsik
 WHERE lifnr eq '0000010010'
 and augbl eq space .

check sy-subrc eq 0.

write:/ count1.

regards,

vijay

Re: tracking NULL values

Former Member — Fri, 24 Nov 2006 16:18:53 GMT

Does betrw allow negative values?

Rob