How to find the material based on the division.

Hi All,

My requirement is to read the all the material(products) in the division.

I have executed transaction code:COMMPR01 and seen division field in material tab.

I found the table CRMC_DIVISION but i did not find any maetial.

Please help me how to find the PRODUCT in the division.

Thanks,

Venkat