topic Re: Read single entry from an internal table in Application Development and Automation Discussions

Read single entry from an internal table

Former Member — Wed, 31 Jan 2007 05:12:57 GMT

hi abappers,

instead of select sibgle i want to read a single value from an internal tabel.

how can i use this....

provide the syntax.

regards,

mansi

Re: Read single entry from an internal table

Former Member — Wed, 31 Jan 2007 05:16:34 GMT

try using <b>read table</b>

Re: Read single entry from an internal table

Former Member — Wed, 31 Jan 2007 05:18:03 GMT

if its only 1 record

read table i_tab into wa_tab index 1. ? not too sure on this.

or if you have condition

read table i_tab into wa_tab WITH key FIELD = SEARCH_TERM

binary serach

transporting <FIELD>

that <field> is the fields that you want to use.

Re: Read single entry from an internal table

Former Member — Wed, 31 Jan 2007 05:19:30 GMT

Either use READ table

loop at itab where condition and move the value to a variable

Thanks

Shiva

Re: Read single entry from an internal table

seshatalpasai_madala — Wed, 31 Jan 2007 05:20:37 GMT

HI,

There are two ways using READ TABLE..

READ TABLE itab into wa_area INDEX 1.

READ TABLE itab into wa_area INDEX n.

READ TABLE itab into wa_area WITH KEY filed1 = value1. (Use key).

Regards,

Sesh

Re: Read single entry from an internal table

Former Member — Wed, 31 Jan 2007 05:20:43 GMT

Use READ statement

READ TABLE itab INTO wa_itab WITH key <FIELD> = <value>.

READ TABLE itab INTO wa_itab INDEX <num>.

Re: Read single entry from an internal table

Former Member — Wed, 31 Jan 2007 05:24:37 GMT

Hi,

To read a single entry from a table you ahve to use READ.

READ TABLE itab WITH INDEX 1. 

READ TABLE itab WITH KEY matnr = '10000010'.

After read u have to use a sy-subrc check and proceed.

If you want to read based on some values from a table then

LOOP AT itab.
CLEAR itab2.
READ TABLE itab2 WITH KEY matnr = itab-matnr.
IF sy-subrc = 0.
...........
ENDIF.
ENDLOOP.

Hope this solves ur query, please close the thread by rewarding points.

Re: Read single entry from an internal table

Former Member — Wed, 31 Jan 2007 05:31:01 GMT

Hi mansi,

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

Re: Read single entry from an internal table

Former Member — Wed, 31 Jan 2007 06:08:15 GMT

Hi Mansi,

You can use READ TABLE for reading a single entry.

You have your data in the internal table so just read the table inside the loop using index or the key.

READ TABLE <itab> WITH KEY <k1> = <f1>... <kn> = <fn> <result>.

READ TABLE <itab> INDEX <idx> <result>.

The system reads the line with the index <idx> from the table <itab>.

The <result> part can specify a further processing option for the line that is retrieved.

If an entry with the specified index was found, the system field SY-SUBRC is set to 0 and SY-TABIX contains the index of that line. Otherwise, SY-SUBRC is set to a value other than 0.

Regards,

Papiya.

Re: Read single entry from an internal table

Former Member — Wed, 31 Jan 2007 06:23:50 GMT

Hi,

Select Single is use d to read a single first matching line from the database table and not from the internal table.

To read a line from the internal table you have to use the READ TABLE itab with KEY fld1 = val1 BINARY SEARCH.

Addition of binary search improves performance, but the table should be sorted on that field.

Regards

Subramanian

Re: Read single entry from an internal table

Former Member — Wed, 31 Jan 2007 06:33:25 GMT

Hi Mansi,

use <b>READ TABLE itab into wa_area INDEX n</b>

reward point if helpful.