topic Re: Read Statement in Application Development and Automation Discussions

Read Statement

Former Member — Mon, 28 Jul 2008 08:46:30 GMT

Hi,

How to use READ statement to read the records lying in between two years..Can I use BETWEEN..?

Help needed.

Reg,

Prabakaran.S

Re: Read Statement

Former Member — Mon, 28 Jul 2008 08:49:08 GMT

hi,

no you cant use like that ...you can use loop and endloop

with loop at table where condition....

Re: Read Statement

Former Member — Mon, 28 Jul 2008 08:50:19 GMT

Hi,

I think you can not use READ statement with between or any other clause except WITH KEY.

May be you can use Loop Where.....or some other.

Hope this helps!!!

Regards,

Lalit

Re: Read Statement

Former Member — Mon, 28 Jul 2008 08:50:38 GMT

Hi,

you better work with key value in the READ statement and put the value of the year in it.

For detail.

http://help.sap.com/saphelp_nw70/helpdata/en/fc/eb35f8358411d1829f0000e829fbfe/content.htm

Regards,

Anirban

Re: Read Statement

bpawanchand — Mon, 28 Jul 2008 08:50:42 GMT

READ statement always reads only one single record from the internal table

Instead of that what you can do if write the READ statement in side a LOOP ...ENDLOOP.

Regards

Pavan

Re: Read Statement

Former Member — Mon, 28 Jul 2008 08:50:58 GMT

hiiii

you can only use EQ with READ statement..for your requirement you can only use LOOP statement with condtition..not READ.

regards

twinkal

Re: Read Statement

Former Member — Mon, 28 Jul 2008 08:51:50 GMT

hi,

With read table you can use either equal to value or index of the table. In your case you should make a loop and there use "in" with range type.

loop at i_table where field in r_values.

....

endloop.

/wg

Re: Read Statement

Former Member — Mon, 28 Jul 2008 08:52:02 GMT

Hi,

loop the internal table which has the year records and in the where condition give the condition.

Re: Read Statement

Former Member — Mon, 28 Jul 2008 08:52:57 GMT

Hi,

No...Use Loop and Endloop.

check the read statement..

http://help.sap.com/saphelp_nw2004s/helpdata/en/fc/eb35f8358411d1829f0000e829fbfe/content.htm

Regards,

Omkaram.

Re: Read Statement

Former Member — Mon, 28 Jul 2008 08:53:21 GMT

Hi Prabhakaran,

You cannot use BETWEEN with READ Statement.

You can try the following:

Loop at itab where <conditon>

endloop.

In the WHERE condition you can specify you date range.

Hope this helps you.

Regards,

Chandra Sekhar

Re: Read Statement

Former Member — Mon, 28 Jul 2008 08:55:32 GMT

Hi,

There is no option in READ statement to use BETWEEN and WHERE conditions.

You can use LOOP AT .... WHERE .

Regards,

Rajitha.

Re: Read Statement

Former Member — Mon, 28 Jul 2008 08:57:24 GMT

HI,

Try with this,

if Datefield GE ('DD/MM/YYYY')

and Datefield LE ('DD/MM/YYYY').

Read table

If sy-subrc <> 0.

error message

Endif.

endif.

Mohinder