topic Re: read table in Application Development and Automation Discussions

read table

Former Member — Wed, 18 Mar 2009 06:28:13 GMT

Please use more informative subject in future

hi,

I have a internal table as follows.

po no | item | state |

45 10 ap

45 10 sp

45 10 pp

46 10 sf

46 10 as

I am useing the read table syntax for this table .

for pono 45 and 46 i want read the records.

but read table is triggring for first record only.

can any body explain how read the record of 46 also.

thanks,

padmaja.

Edited by: Matt on Mar 18, 2009 7:46 AM

Re: read table

I355602 — Wed, 18 Mar 2009 06:30:24 GMT

Hi,

Read statement will read the very first line matching the condition.

So try using:


loop at itab where po_no = '45' or po_no = '46'.
  write: / itab-po_no, itab-item, itab-state.
endloop.

Hope this helps you.

Regards,

Tarun

Re: read table

Former Member — Wed, 18 Mar 2009 06:31:06 GMT

Hi,

You can LOOP statement with where clause or

Read Statement will work for each entry only when it is

inside the LOOP statement with KEY mentioned.

Regards

Mansi

Re: read table

Former Member — Wed, 18 Mar 2009 06:35:05 GMT

Hi,

Do like this.

loop at itab into wa.

read table itab into wa with key po_no = wa-po_no.

your logic, if any*************

endloop.

this will read every record.

Cheers,

Rudhir

Re: read table

Former Member — Wed, 18 Mar 2009 06:38:16 GMT

Hi,

Either used

At new po.

read table it into wa.

endat.

put loop it into wa.

endloop.

Regards,

Anagha Deshmukh

Re: read table

Former Member — Wed, 18 Mar 2009 06:39:48 GMT

Hi Padmaja

Use the Loop Statement instead of the Read statement since Read statement will give you the very first line of the matching condition.

Hope this helps.

Harsh

Re: read table

Former Member — Wed, 18 Mar 2009 06:42:34 GMT

hi,

use loop....end loop it select all th evalues in the internal table.

regards

Ritesh J

Re: read table

matt — Wed, 18 Mar 2009 06:47:34 GMT

Please use more informative subject in future

Re: read table

Former Member — Wed, 18 Mar 2009 06:48:44 GMT

Hi,

Loop the internal table with where condition or llop the table and use read statement within that.

Sort the internal table before that.

Thanks.

Re: read table

Former Member — Wed, 18 Mar 2009 06:59:43 GMT

Hi,

Reading the intrenal table will only be done either by using the READ statement within the loop -endloop or using the WRITE statement again with in the loop-endloop.

As both the statement will read the table at the curretn index only, to read the other entry you need to do it in loop-endloop or in lopp that run from first index to last value(sy-dbcnt).

Pooja

Re: read table

Former Member — Fri, 20 Mar 2009 04:43:55 GMT

answerd