topic Re: READ Table With Key in Application Development and Automation Discussions

READ Table With Key

Former Member — Mon, 07 Jan 2008 18:45:16 GMT

I am trying to get the sy-tabix of a record in an internal table.

The key I am using is a field in the internal table that will be unique.

I get sy-sub = 4, so I assume I am not defining the key in full.

The code is:

CONCATENATE g_dimen i_bunit INTO l_nodename.

READ TABLE lt_e_t_rsnodes_lnk WITH KEY nodename =

l_nodename

BINARY SEARCH TRANSPORTING NO FIELDS.

Any suggestions? Thank-You.

Former Member — Mon, 07 Jan 2008 18:49:32 GMT

Did you sort your Internal table lt_e_t_rsnodes_lnk before reading?

VInodh Balakrishnan

former_member191735 — Mon, 07 Jan 2008 18:49:59 GMT

If you use binary search, you need to sort the internal table first.

before read to the internal table you need to sort your internal table. lt_e_t_rsnodes_lnk

Reward if helpful

Former Member — Mon, 07 Jan 2008 18:50:16 GMT

Is the table sorted by nodename?

Rob

Former Member — Mon, 07 Jan 2008 18:51:04 GMT

Try without binary search and see if it works.

Also check if concatenate statement is populating the string same as in your internal table. Sometimes spaces may lead to different values.

-Cheers

former_member194669 — Mon, 07 Jan 2008 18:51:14 GMT

Can you please check the values for the following

g_dimen

i_bunit

l_nodename.

may be try to use


CONCATENATE g_dimen i_bunit INTO l_nodename.
condense l_nodename no-gaps.

and also make sure your table lt_e_t_rsnodes_lnk will be sort properly

a®

former_member156446 — Mon, 07 Jan 2008 18:53:05 GMT

Hi Tom

I am asuusming that table lt_e_t_rsnodes_lnk have the value similar to that formed by concatenating g_dimen i_bunit.

if you are doing a binary search you need to sort the table for sure..

sort lt_e_t_rsnodes_lnk by nodename.

try the above if not...

becoz ur sy-subrc eq 4. looks like the table doesnt have a value similar to that formed by concatenating that fields. check ur data in the table.