topic Re: regarding initial value in Application Development and Automation Discussions

regarding initial value

Former Member — Thu, 12 Jul 2007 08:45:57 GMT

in the condition

ERFMG = initial value

and ZLDAT = initial value.

this condition i hav to write in the select query where condition how can i ?

what it mean initial value.

Re: regarding initial value

seshatalpasai_madala — Thu, 12 Jul 2007 08:49:42 GMT

Hi,

You can as well check as ERFMG IS NULL.

Or you can declare same type variabe and check

<b>DATA: ERFMG_INIT TYPE ERFMG.

CLEAR ERFMG_INIT.

In the select use WHERE ERFMG = ERFMG_INIT.</b>

Regards,

Sesh

Re: regarding initial value

Former Member — Thu, 12 Jul 2007 08:51:30 GMT

Hi Ramesh,

Try This,

If ERFMG is initial and ZLDAT is initial.

Perform read.

Endif.

Form Read.

Select -

> here you can write your select querry.

EndForm.

Thanks.

Re: regarding initial value

Former Member — Thu, 12 Jul 2007 08:53:48 GMT

where ERFMG = ''

and ZLDAT = '0'." if zldat is a date field ...

else

where ERFMG = ''

and ZLDAT = ''.

regards

shiba dutta

Re: regarding initial value

Former Member — Thu, 12 Jul 2007 08:56:18 GMT

Hi Ramesh,

Try this.

Select ....
  WHERE  ERFMG IS INITIAL 
          and ZLDAT IS INITIAL.

Re: regarding initial value

varma_narayana — Thu, 12 Jul 2007 08:57:47 GMT

Hi...

you can write like.

SELECT <Fields> from <DB TABLE> into table <itab>

where ERFMG is INITIAL

and ZLDAT is INITIAL .

regards.

Re: regarding initial value

Former Member — Thu, 12 Jul 2007 08:58:46 GMT

<b>select <some fields> into <table> from <database table>where ERFMG = initial value

and ZLDAT = initial value.

</b>

Regards,

Pavan.