topic Re: read table query in Application Development and Automation Discussions

read table query

former_member530652 — Fri, 04 Jul 2008 07:53:40 GMT

READ TABLE it_583 WITH KEY pernr = pernr-pernr

begda <= month_end

endda >= month_begin.

i am getting error "=.." expected after "BEGDA"

i have changed le instead of <= and also ge instead of >=

but it's not working....

any idea how to deal with it??

Re: read table query

Former Member — Fri, 04 Jul 2008 07:56:40 GMT

You can not use relational operator like GE LE with read query.

instead read you need to put a loop.

Regards,

Azad.

Re: read table query

JozsefSzikszai — Fri, 04 Jul 2008 07:57:26 GMT

hi,

READ TABLE works only with =

as a workaround you can use LOOP AT ...

LOOP AT it_583 INTO ...

WHERE pernr = pernr-pernr

begda <= month_end

endda >= month_begin.

...

ENDLOOP.

you ahve to be prepared that you could have more than one result.

hope this helps

Re: read table query

Former Member — Fri, 04 Jul 2008 07:57:56 GMT

You cannot use greater than equal to option in read table with key.

Have a look at sap help for this.

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

Thanks,

Vibha

Re: read table query

Former Member — Fri, 04 Jul 2008 07:58:46 GMT

Use LT and GT

Thanks

Re: read table query

Former Member — Fri, 04 Jul 2008 08:09:03 GMT

This message was moderated.

Re: read table query

Former Member — Fri, 04 Jul 2008 08:49:19 GMT

Hi,

When you are reading records from internal table using READ

You can use KEY or INDEX value only.

1. READ TABLE itab INDEX 1.

2. READ TABLE itab WITH TABLE KEY k1 = v1 ... kn = vn [additions].

Regards,

Rajitha.