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

[hubert_heitzer]

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

[RaymondGiuseppi]

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

[Sandra_Rossi]

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.

[RaymondGiuseppi]

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

[Sandra_Rossi]

Thanks for the information!

[abo]

Have you tried simply with

aedat = ''

?

[hubert_heitzer]

yes, I tried but did not work

[abityildiz]

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

Could you try like this:

aedat = '00000000'

[hubert_heitzer]

Yes thats it.

Raymond already led me to the solution.

[matt]

Better is

DATA zero_date TYPE d.

...

WHERE aedat = zerodate.

[Sandra_Rossi]

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