Movement types

Hi all,

I want to get the movement types used in MSEG , for a perticular plant , storage location, fiscal year.

In order to obtain the result i have fetched all the movement types from T156,

and by looping the table , i have checked whether a the movement type exist or not using SELECT SINGLE . But this is taking a lot of time and even throwing a time out error. Can any body suggest me another way to over come this problem .

I have used for all entries but same problem persists.

thanks and regards,

sandeep .