10-21-2008 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.
10-21-2008 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'.
10-21-2008 1:39 PM
10-21-2008 2:15 PM
10-21-2008 1:40 PM
10-21-2008 1:44 PM
Hi Cao,
Check the code which i have modified which you have post
DATA: BEGIN OF it OCCURS 0,
matnr LIKE mara-matnr,
laeda LIKE mara-laeda,
END OF it.
select matnr laeda
from mara into it
where laeda = ''.
endselect.
Cheers!!
Balu
10-21-2008 1:45 PM
select matnr laeda
from mara
where laeda IS NULL
(IS INITIAL is definetly wrong)
10-21-2008 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.
10-21-2008 1:45 PM
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
10-21-2008 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'.