topic Re: quick table seacrh... in Application Development and Automation Discussions

quick table seacrh...

Former Member — Tue, 07 Nov 2006 15:05:02 GMT

Hi all. I'm looping over itab_1 into wa_itab_1. I want to select a single row of data from itab_2 based on a value in wa_itab_1. I don't need to llop over both tables do I? Isn't there a more terse way of selecting the record from itab_2?

regards,

Mat

Re: quick table seacrh...

Former Member — Tue, 07 Nov 2006 15:07:16 GMT


read table itab_2 with key field1 = wa_itab_1-field1
                           field2 = wa_itab_1-field2.

If your table is sorted by field1 and field2, you can add the BINARY SEARCH option to speed up the read.


read table itab_2 with key field1 = wa_itab_1-field1
                           field2 = wa_itab_1-field2
                           binary search.

Message was edited by: Michael Malvey

Re: quick table seacrh...

Former Member — Tue, 07 Nov 2006 15:08:34 GMT

hi,

loop at tb1 into struct

read tab2 into struct2with key keyparam = struct-value.

if sy-subrc = 0.

row found

endif.

endloop.

grtz

Koen

Re: quick table seacrh...

RichHeilman — Tue, 07 Nov 2006 15:08:59 GMT

Just to add to Michael's solution, add the words BINARY SEARCH to the READ statement.

read table itab_2 with key field1 = itab_1-field1
                           field2 = itab_1-field2
                                 <b> BINARY SEARCH</b>.

Regards,

Rich Heilman

Re: quick table seacrh...

Former Member — Tue, 07 Nov 2006 15:12:53 GMT

Hi,

You can use the read statement to get the corresponding single record of the second table.

read table itab_2 into wa_itab_2 with key field1 = wa_itab_1-field1

...

binary search.

When you are using binary search make sure you are sorting the internal table by the order of the fields which are used in the read statement.

using binary search is the quicker than the nomal read statement.

Regards,

Satya,