topic Re: READ TABLE with INDEX in Application Development and Automation Discussions

READ TABLE with INDEX

Former Member — Tue, 31 Jul 2007 06:33:17 GMT

Hi Friends,

Please can u explain me what is the use of this READ statement, and why we use INDEX here.

READ TABLE z_tlines INDEX 1

Thank you,

Shreekant

Re: READ TABLE with INDEX

Former Member — Tue, 31 Jul 2007 06:33:42 GMT

hi,

Read table with index 1 will read the first record from ur internal table.... index denotes the row of ur internal table....

reward points if useful...

regards,

raksha

Re: READ TABLE with INDEX

Former Member — Tue, 31 Jul 2007 06:35:20 GMT

hi,

READ TABLE z_tlines INDEX 1

It reads only one record...Either by index or key.

READ TABLE MY_TAB INDEX 1.

READ TABLE MY_TAB WITH KEY CODE = 'ATG'.

when we use the INDEX 1, it reads the 1st record of the table.

Reading records with keys

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

Reading lines with Index

http://help.sap.com/saphelp_47x200/helpdata/en/fc/eb3730358411d1829f0000e829fbfe/content.htm

Rgds

Reshma

Re: READ TABLE with INDEX

Former Member — Tue, 31 Jul 2007 06:35:42 GMT

Hi,

If you need only the first record in the table you can use like this

Re: READ TABLE with INDEX

Former Member — Tue, 31 Jul 2007 06:35:51 GMT

Hi,

Read table is used when you want to read the contents of the internal table Z_tlines.

The option INDEX 1 is used to read the first line of the internal table.

Shruthi R

Re: READ TABLE with INDEX

seshatalpasai_madala — Tue, 31 Jul 2007 06:37:01 GMT

Hi,

READ TABLE isused to read from internal tables.

And INDEX can only be used with STANDARD and SORTED tables. INDEX can be used only with ORDERED and INDEXED tables like STADARD and SORTED tables.

This is to read from certain position.

Regards,

Sesh

Re: READ TABLE with INDEX

Former Member — Tue, 31 Jul 2007 06:37:02 GMT

hi,

Read table will get the first record that saitisfies the condition specified in the with key statement into the header.

if an itab contains the following data:

field1 field2

1 one

2 two

3 three

4 four

5 five

And if you read the itab like this:

read table itab into WA with key field1 = '3'.

if sy-subrc = 0.

write:/ wa.

endif.

The output will be

3 three.

The sy-tabix will hold the value of index of the current record.

REWARDS POINT

Regards,

ASHOK

Re: READ TABLE with INDEX

Former Member — Tue, 31 Jul 2007 06:37:48 GMT

Hi,

If I want to read all the lines from the internal table what should I do.

Pls. reply me.

Thanks,

Shreekant

Re: READ TABLE with INDEX

Former Member — Tue, 31 Jul 2007 06:38:28 GMT

Hi,

If u want to read all the lines either u just use the same table for the purpose of usage or just loop at this table and put it onto a wrk area and use the record for further processing

reward points if useful

Re: READ TABLE with INDEX

Former Member — Tue, 31 Jul 2007 06:40:03 GMT

hi,

read table st is used to read a record from internal table into workarea. with read statement we can do in 2 ways

1. using index

2. using key fields of the record

for ex:

loop at itab.

read table itab with index sy-tabix.

endloop.

reads all records of internal table with respect to index. here index is also used to read particular record it its given outside loop.

as similar usingkey field also we can read a record.

if helpful reward some points.

with regards,

Suresh Aluri.

Re: READ TABLE with INDEX

Former Member — Tue, 31 Jul 2007 06:40:05 GMT

Read table statement is used for Reading a particular internala table or a field it is used for selecting a single record.

READ TABLE sets SY-TABIX to the index of the table line read. If you use a binary search, and the system does not find a line, SY-TABIX contains the total number of lines, or one more than the total number of lines. SY-INDEX is undefined if a linear search fails to return an entry.

Check this sample code

READ TABLE itab INTO wa WITH KEY field1 = X.
IF sy-subrc <> 0.
  READ TABLE itab INTO wa WITH KEY field2 = Y.
  IF sy-subrc <> 0.
    READ TABLE itab INTO wa WITH KEY field3 = Z.
  ENDIF. 
ENDIF.
 
CHECK sy-subrc = 0. "Or an IF, of course

Reward all helpfull answers

Regards

Pavan

Re: READ TABLE with INDEX

former_member668243 — Tue, 31 Mar 2020 13:56:55 GMT

Read table is used to read the record from your internal table "z_tlines" and if you mention the INDEX 1 with it then it means it will read the First record.