is initial

[Former Member]

select kunnr vbeln from ztable into table itab1 where flag is initial.

this is giving me an error 'The operator IS can only be used in f is null or f is not null'

[Former Member]

Megan, that syntax works good in IF statements, but not in SELECT statements, you should use the suggestion syntax FLAG = SPACE

Regards,

RIch Heilman

[Former Member]

Hi,

Give FLAG = SPACE.

select kunnr vbeln from ztable into table itab1 where <b>flag = space</b>.

Thanks,

Naren

[Former Member]

yeah i know flag = space works

but shouldnt flag is initial work too

[RichHeilman]

Megan, that syntax works good in IF statements, but not in SELECT statements, you should use the suggestion syntax FLAG = SPACE

Regards,

RIch Heilman