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.
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.