regarding initial value

[Former Member]

Hi

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.

[seshatalpasai_madala]

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

[Former Member]

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.

[Former Member]

where ERFMG = ''

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

else

where ERFMG = ''

and ZLDAT = ''.

regards

shiba dutta

[Former Member]

Hi Ramesh,

Try this.

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

[varma_narayana]

Hi...

you can write like.

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

where ERFMG is INITIAL

and ZLDAT is INITIAL .

regards.

[Former Member]

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

and ZLDAT = initial value.

</b>

Regards,

Pavan.