How to write multiple select statements while performing lookup from One lookup table

Hi All,

We have scenario where we need to perform the lookup from a DSO to another DSO by using Multiple conditions for different fields from but from the same lookup DSO.

example

condition 1:

select /bic/YMAT_2 /bic/YMAT_D5 from /bic/AYDSO_900 into corresponding fields of table it_tab1 for all entries in result_package where

/bic/YMAT_2 = result_package-/bic/YMAT_2.

Condition 2

select /bic/YMAT_2 /bic/YMAT_D10 from /bic/AYDSO_900 into corresponding fields of table it_tab1 for all entries in result_package where

/bic/YMAT_2 = result_package-/bic/YMAT_2 and /bic/YMAT_5 = result_package-/bic/YMAT_5.

Kindly suggest the end routine code how can we achieve this with performance. As of now we are using 2 internal tables and WA to achieve this.