topic READ Table With Key not working in Application Development and Automation Discussions

READ Table With Key not working

Former Member — Fri, 29 Aug 2008 11:40:16 GMT

The code is:

READ TABLE gt_findpartners WITH KEY

z3isptrxtyp = wa_z3isp_inv_conv-z3isptrxtyp

z3ispordno = wa_z3isp_inv_conv-z3ispordno

BINARY SEARCH TRANSPORTING NO FIELDS.

Odd because at one time I believe the code was working fine, not sure vwhat I could have changed to stop this from working. But the rec is definitely in the tab it is reading and I get a sy-sub = 4.

Thank-You

Re: READ Table With Key not working

Former Member — Fri, 29 Aug 2008 11:41:13 GMT

When using binary search you need to sort the table on the fields you are using as a key.

Re: READ Table With Key not working

kesavadas_thekkillath — Fri, 29 Aug 2008 11:41:58 GMT

check whether you have sorted gt_findpartners by z3isptrxtyp and

z3ispordno

if not sort it before reading it using binary search.

Re: READ Table With Key not working

rainer_hbenthal — Fri, 29 Aug 2008 11:42:04 GMT

The table is not sorted. Binary search is failing because of that.

Re: READ Table With Key not working

Former Member — Fri, 29 Aug 2008 11:42:11 GMT

Hello,

To use the binary search you need to have a sorted table by the keys that you want to search.

Regards.

Re: READ Table With Key not working

Former Member — Fri, 29 Aug 2008 11:42:41 GMT

Ignore, if you already used the SORT on the key fields.

It is always must to sort the table before binary search.

SORT gt_findpartners by z3isptrxtyp  z3ispordn.

READ TABLE gt_findpartners WITH KEY
z3isptrxtyp = wa_z3isp_inv_conv-z3isptrxtyp
z3ispordno = wa_z3isp_inv_conv-z3ispordno
BINARY SEARCH TRANSPORTING NO FIELDS.

Re: READ Table With Key not working

Former Member — Fri, 29 Aug 2008 11:45:29 GMT

Hi,

Remove the Binary Search.....

It will work...

Regards,

Kunjal

Re: READ Table With Key not working

Former Member — Fri, 29 Aug 2008 11:53:26 GMT

I hope your would have sorted the internal table if not sort it by the key fields.

If the addition TRANSPORTING NO FIELDS is used, the statement READ TABLE only checks whether the line that is being searched for exists, and fills the system field sy-subrc and sy-tabix. The system can then no longer access the content of the found fields.

So if you get sy-subrc eq 4 that record is not available in the internal table.

they record in the itab might have a prefix zero's or the value you r passing might have so it would result sy-subrc eq 4.

Thanks,

Karthik

Re: READ Table With Key not working

Former Member — Fri, 29 Aug 2008 11:55:03 GMT

Hi,

READ TABLE gt_findpartners WITH KEY
z3isptrxtyp = wa_z3isp_inv_conv-z3isptrxtyp
z3ispordno = wa_z3isp_inv_conv-z3ispordno
BINARY SEARCH TRANSPORTING NO FIELDS.

Once remove binary search and check the sy-subrc value,

if sy-subrc value is 0 then sort the table before read as all said.

Regards

Adil

Re: READ Table With Key not working

Former Member — Fri, 29 Aug 2008 12:07:40 GMT

Hi,

Binary Search can be used only once the sorting is performed in the internal table . sort the internal table or remove the binary search while reading.

Regards

Nanda Kishore