BOM - Report (Urgent)

Hi All,

I would like to know is there a transaction, where i can enter a material & find out how much quantity of it is used in the main assembly?

Eg: I should be able to enter

Material = Bearing-A

Main assembly = Car

& the output should show me 50

If no standard transaction or report exists, can i know which tables i need to join to extract this information?

Hope my problem is clear, await inputs.

Vivek