I tried find a solution for report to check consumption like CKM3.From a real demand of CO consultant and End User is the end of every month (most project that i take part in), Costimate Accoutant and related departments must check and solve about consumption of Material for Finish Product, Semi-Finish Product (Repetitive Manufacturing) , Production Order , etc …
In order to cost estimate of Material match between Plan Price and Actual Price, they will have to (GI) good issue -(GR) good receipt – (TR) transfer … again to adjust value of Finish Product. And one of reports to analyze cost of Finish Product used regularly is (CKM3 – Material Price Analysis).
However most we feel lost time because this report only run result for one Material. Today, after somedays research and code, i want share for you Z report to check consumption for all material.
(Maybe this report will do not match with all, but i hope it useful for newbie or person need it)
Go on transaction code: SE11 to create Structure Table. This structure to use for Z-report.