topic internal table reading in Application Development and Automation Discussions

internal table reading

Former Member — Tue, 15 May 2007 06:33:01 GMT

Hi,

I have some data in my internal table.

Now my requirement is to read the table ITAB based on index as well as where clause.

So anybody will pls tell me how to code for the above requirement.

Pls tell me asap.

Re: internal table reading

Former Member — Tue, 15 May 2007 06:39:03 GMT

hi,

1.............

U can use the statement

READ ITAB INDEX 2.

Here 2 is the index for which u want to read the value in ITAB

2...........

go through this document & Syntaxes

Read an internal table

- READ TABLE itab. / READ TABLE itab INTO wa.

Read a list line

- READ LINE lin.

- READ LINE lin OF CURRENT PAGE.

- READ LINE lin OF PAGE pag.

- READ CURRENT LINE.

Read a program

- READ REPORT prog INTO itab.

Read text elements

- READ TEXTPOOL prog ...INTO itab ...LANGUAGE lg.

Read a file

- READ DATASET dsn INTO f.

Read a database table

- READ TABLE dbtab.

Determine calendar information

- In R/2: READ CALENDAR.

read table <Intenal Table Name> index <line number>.

pls reward if it helpful

Thanks

Vana

Re: internal table reading

Former Member — Tue, 15 May 2007 06:39:05 GMT

Hi Neha,

You cannot use both at a time. because when you give index you mean specific record ( position).

Ex for where:

READ TABLE html_viewer_tab

WITH KEY table_line->parent = container

INTO html_viewer.

Ex for index:

READ TABLE sflight_tab INDEX sy-index INTO sflight_wa.

Regds,

Younus

<b>Reward Helpful Answers!!!</b>

Re: internal table reading

Former Member — Tue, 15 May 2007 06:39:36 GMT

Hi,

You can directly pur your where condition while looping the itab.

see this:

Loop at itab where <Condition>. "So that only those records are looped.

........" Now read stmt.

READ TABLE itab INDEX sy-tabix.

.........

endloop.

Hope this info helps.

Regards,

Kumar.

Re: internal table reading

Former Member — Tue, 15 May 2007 06:40:57 GMT

check whether it works...

read table itab index n.

if sy-subrc eq 0.

if itab-xxx = aaa.

else.

endif.

Re: internal table reading

Former Member — Tue, 15 May 2007 06:41:48 GMT

You can loop if you need to read all the data from internal table

else if you need to fetch a particular row depending on the conditions then you can user READ statement

1.Loop at itab into wa.

write : wa.. " WA contains the data

endloop.

READ table ITAB into wa with key f1 = 'xx'

you can read Table with either index or with some keys both are not possible..

as per your requirement..

READ TABLE ITAB into wa index 'N'.

if sy-subrc = 0.

Now you can compare your fields

if wa-matnr = 'xx'.

write: / wa

endif.

rewards if useful

regards

nazeer

Message was edited by:

nazeer shaik

Re: internal table reading

Former Member — Tue, 15 May 2007 06:42:04 GMT

Hi,

Please refer to following link

Regards

Bala

Re: internal table reading

Former Member — Tue, 15 May 2007 06:42:48 GMT

hai neha ,

You can directly put your where condition while looping the itab.

Re: internal table reading

Former Member — Tue, 15 May 2007 06:46:37 GMT

you can do like this...

loop at itab where <..your where condition>.

if sy-tabix = <your value>.

else.

continue.

endif.

endloop.

regards

shiba dutta

Re: internal table reading

Former Member — Tue, 15 May 2007 06:52:27 GMT

Hi Neha,

Refer this code :

Loop at itab where <condition>.

Read table itab index sy-tabix.

endloop.

Regards,

Hemant

Re: internal table reading

Former Member — Tue, 15 May 2007 07:28:16 GMT

hi neha,

Now my requirement is to read the table ITAB based on index as well as where clause.

So anybody will pls tell me how to code for the above requirement.

using read statement you can read data from internal table to work area as

read table [tablename] into [workarea] with index [indexno].

ex: read table itab into wa_itab

read table itab into wa_itab with key field = 'fieldname'

helpful reward some points.

with regards,

suresh babu aluri.