topic is initial in Application Development and Automation Discussions

is initial

Former Member — Mon, 19 Mar 2007 21:13:19 GMT

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 — Mon, 19 Mar 2007 21:16:10 GMT

Hi,

Give FLAG = SPACE.

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

Thanks,

Naren

Former Member — Mon, 19 Mar 2007 21:18:18 GMT

yeah i know flag = space works

but shouldnt flag is initial work too

RichHeilman — Mon, 19 Mar 2007 21:54:05 GMT

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

Regards,

RIch Heilman