topic Re: Reg : Read statement using Binary Search.... in Application Development and Automation Discussions

Reg : Read statement using Binary Search....

Former Member — Thu, 16 Jul 2009 03:39:53 GMT

I have an Internal Table as below

Value Description

100 Product

2008 Production Year

05 Production Month

I am using Read statement with Binary Search for getting Production Month.

Read table itab with key Description = 'Production Month' binary search.

I am getting sy-subrc as 4 eventhough data is present in the table for Production Month.

What may be the problem.

vimalv — Thu, 16 Jul 2009 03:44:41 GMT

You have to sort the table by the KEY before using BINARY SEARCH.

say ur internal table is ITAB and you want to search with key PDATE,

then do SORT ITAB by PDATE.

then do.. READ TABLE ITAB .. WITH KEY PDATE = ... BINARY SEARCH.

former_member585060 — Thu, 16 Jul 2009 03:45:53 GMT

Hi,

First Sort the itab with Description field, then use the READ statement,

For BINARY SEARCH to be used, we have to sort the internal table before with the order of WHERE clause in READ statement.

Regards

Bala Krishna

Former Member — Thu, 16 Jul 2009 03:47:38 GMT

SORT internal table before you use BINARY SEARCH is the thumb rule.

Thanks

Kiran

Former Member — Thu, 16 Jul 2009 03:50:42 GMT

Hi suganya,

use

sort table itab ascending by <production month>.

Read table itab with key description = <production month> binary search.

Remember always, while using binary search always sort the internal table.

Regards,

Sakthi.