topic Re: How to read an internal table using binary search. in Application Development and Automation Discussions

How to read an internal table using binary search.

Former Member — Wed, 29 Nov 2006 14:09:03 GMT

Hi all,

when I was reading an internal table with binary search I was not getting proper results but when I was reading internable without binary search means I was getting perfect results .What might be the reason.

Thanks,

Balaji.

Re: How to read an internal table using binary search.

Former Member — Wed, 29 Nov 2006 14:10:43 GMT

A pre-requisite to use binary search is that you should have sorted the table by the field with which you are searching.

Have you done that.

Regards,

Ravi

Note - Please mark all the helpful answers

Re: How to read an internal table using binary search.

Former Member — Wed, 29 Nov 2006 14:11:45 GMT

Hi Balaji,

Sort the internal table, before you use the binary search.

sort itab by key1.
read table itab with key key1 = value1 binary search.

Hope this helps.

Re: How to read an internal table using binary search.

Former Member — Wed, 29 Nov 2006 14:12:49 GMT

Hi Balaji,

Before read the internal table you have to sort the internal table what you are reading for example

SORT IT_EKKO BY EBELN.

READ TABLE IT_EKKO WITH KEY EBELN = IT_EKPO-EBELN BINARY SEARCH.

Thanks

Vikranth Khimavath

Message was edited by:

Khimavath Vikranth

Re: How to read an internal table using binary search.

Former Member — Wed, 29 Nov 2006 14:13:00 GMT

hi Balaji,

Check

http://help.sap.com/saphelp_erp2005vp/helpdata/en/fc/eb373d358411d1829f0000e829fbfe/frameset.htm

Regards,

Santosh

Re: How to read an internal table using binary search.

Sandeep_Panghal — Wed, 29 Nov 2006 14:13:10 GMT

HI,

Sort the internal table on the key always before using binary search.

Sort itab by key1.

read table itab with key1 = value binary earch.

Hope this helps.

Re: How to read an internal table using binary search.

Former Member — Wed, 29 Nov 2006 14:13:41 GMT

Hi Balaji,

You need to SORT the internal table with the field you are using in BINARY SEARCH.

SORT ITAB BY MATNR.

READ TABLE ITAB WITH KEY MATNTR = <VALUE> BINARY SEARCH.

Thanks,

Vinay

Re: How to read an internal table using binary search.

Former Member — Wed, 29 Nov 2006 14:15:27 GMT

You internal table should be sorted by the key (all the fields in WITH KEY) what you are using for READ. Use the fields in <b>Order</b> in both the places.

Regards

Surya.

Re: How to read an internal table using binary search.

Former Member — Wed, 29 Nov 2006 14:24:28 GMT

Hi,

It is required to sort the internal table by the fields that you are using to read the table.

If you want to read table t_itab with vbeln and posnr and use binary search then you need to sort

t_itab by vbeln posnr.

read table t_itab into wa_itab with key vbeln = <sales order>

posnr = <item >

binary search.

If the table is sorted then only binary search works else not..

Hope this makes it clear.

Regards,

Shahu

Re: How to read an internal table using binary search.

Former Member — Wed, 29 Nov 2006 16:45:11 GMT

Hi all,

thanks for all your replies.I sorted the internal table as u all said.Suppose I have three fields field1,field2,field3 in the internal table itab.I am sorting using only field1 and field2 but not field3.I am reading the internal table with all the three fields.In this scenarion I am using binary search .But the results are not perfect .The results are perfect in the absence of binary search in this scenario.

So do I need to sort all the three fields field1,field2,field3 to get correct results.

Thanks,

Balaji

Re: How to read an internal table using binary search.

Former Member — Wed, 29 Nov 2006 16:47:25 GMT

Yes.

Rob

Re: How to read an internal table using binary search.

Muthyal_Reddy — Thu, 23 May 2024 09:40:07 GMT

Hello,

sort your internal table.

SORT itab BY EBELN.

LOOP AT itab2 ASSIGNING FIELD-SYMBOL(<WA_ITM>).

READ TABLE itab INTO DATA(WA) WITH KEY EBELN = <WA_ITM>-ebeln BINARY SEARCH.

endloop.