topic Re: Problems with SELECT ... WHERE ... IS NULL in Application Development and Automation Discussions

Problems with SELECT ... WHERE ... IS NULL

hubert_heitzer — Wed, 26 Oct 2022 15:05:23 GMT

Ahoi experts,

SELECT * FROM stpo INTO TABLE lt_stpo<br>
 WHERE stlty EQ 'P'        AND
       stlnr EQ '00191182' AND
       posnr EQ '0020'     AND
       lkenz NE abap_true  AND
       aedat IS NULL.

should yield the last entry of STPO as shown below.

but results in an SY-SUBRC=4. If I omit

aedat IS NULL

query yields 3 hits (lines 1, 2 and 4).

Can u pls tell me, what is wrong with

aedat IS NULL

Regards, Hubert

Re: Problems with SELECT ... WHERE ... IS NULL

RaymondGiuseppi — Wed, 26 Oct 2022 15:41:11 GMT

Do not confuse IS NULL (null value) with IS INITIAL (initial value of the dictionary type)

Re: Problems with SELECT ... WHERE ... IS NULL

abo — Wed, 26 Oct 2022 15:41:41 GMT

Have you tried simply with

aedat = ''

Re: Problems with SELECT ... WHERE ... IS NULL

Sandra_Rossi — Wed, 26 Oct 2022 15:54:08 GMT

I know what you mean, but just to clarify, IS INITIAL is not valid with SELECT. Instead, we must use = followed by the corresponding initial value in the database.

Re: Problems with SELECT ... WHERE ... IS NULL

hubert_heitzer — Thu, 27 Oct 2022 04:57:37 GMT

yes, I tried but did not work

Re: Problems with SELECT ... WHERE ... IS NULL

abityildiz — Thu, 27 Oct 2022 06:32:56 GMT

Hi,
I think like this,your aedat field is value '00000000' in the table.

Could you try like this:

aedat = '00000000'

Re: Problems with SELECT ... WHERE ... IS NULL

hubert_heitzer — Thu, 27 Oct 2022 06:47:17 GMT

Yes thats it.

Raymond already led me to the solution.

Re: Problems with SELECT ... WHERE ... IS NULL

matt — Thu, 27 Oct 2022 07:45:18 GMT

Better is

DATA zero_date TYPE d.

...

WHERE aedat = zerodate.

Re: Problems with SELECT ... WHERE ... IS NULL

RaymondGiuseppi — Thu, 27 Oct 2022 08:23:19 GMT

sandra.rossi , since 7.53 : 4. Relational Expression IS INITIAL

Re: Problems with SELECT ... WHERE ... IS NULL

Sandra_Rossi — Thu, 27 Oct 2022 13:34:50 GMT

Thanks for the information!

Re: Problems with SELECT ... WHERE ... IS NULL

Sandra_Rossi — Thu, 27 Oct 2022 13:39:31 GMT

To sum up both valid answers:

Before 7.53, from kamil.yildiz : WHERE aedat = '00000000' (or other variants as explained by matthew.billingham
Since 7.53, from raymond.giuseppi : WHERE aedat IS INITIAL