Analysis of BOM Consumption for a Specific Finished Goods Material Number

Hello Experts,

In our process, we consume raw materials by weight. Because of this our actual raw material consumption from order to order can vary. I am looking for a transaction that will allow us to review the historical raw material consumption of a particular finished goods material number.

For example,

Material A001 uses B001, C001, D001 and E001

Material A002 uses B001, C001 and E001

I want to be able to review the Production Order consumption history of A001 only within a given time frame.

If there is no transaction that will do this, I do know how to build basic queries so a breakdown of tables and field names would be helpful.

Thank you in advance for your information.

- TL