2008 Oct 21 1:37 PM
there is SQL sentence.
---
DATA: BEGIN OF it OCCURS 0,
matnr LIKE mara-matnr,
laeda LIKE mara-laeda,
END OF it.
select matnr laeda
from mara
where laeda <> space.
How can I check the laead field is initial.
Regards.
2008 Oct 21 1:55 PM
I checked and IS NULL does not work either....
laeda is a date field, so the only correct solution is:
... laeda EQ '00000000'.
2008 Oct 21 1:39 PM
where laeda IS INITIAL.
2008 Oct 21 2:15 PM
this sentence can't used 'is initial'.
2008 Oct 21 1:40 PM
if it-laeda is initial.
2008 Oct 21 1:44 PM
Hi Cao,
Check the code which i have modified which you have post
from mara into it
where laeda = ''.
endselect.
Cheers!!
Balu
2008 Oct 21 1:45 PM
where laeda IS NULL
(IS INITIAL is definetly wrong)
2008 Oct 21 2:22 PM
I exect the sentence ,but the result is wrong.
when the field is null
display of select all DB data.
when the field is not null
can't select data from DB.
regards.
Hi,
Try this syntax
SELECT... WHERE s IS [NOT] NULL...
SELECT matnr laeda FROM mara INTOTABLE it_itab WHERE
laeda IS [NOT] NULL.
Regards
Bala Krishna
Bluesky
