Tracking Causes for change in standard cost of material

[Former Member]

Hi,

I want to track all the materials whose standard cost changes when comparing previous and current periods, along with the reason for change in standard cost ( like BOM CHANGES, Routing Changes, labor cost change etc).

In Mm03, costing tab2 we have standard price for PREVIOUS & CURRENT PERIOD, based on that 2 periods, I written program that tracks all changes.

I will explain my problem with an example. I have a Material costing run for period 08/2011 & 09/2011 whose values are 100 & 200. In 08/2011, after costing is run, a BOM is changed. So When costing is run again in 09/2011, value is changed to 200 due to change of BOM.

Since my requirement to track the reasons for change of standard cost, I wrote program as taking both period as 08/2011 and 09/2011 and got all BOMs and routing during those 2 periods and compared BOM's, ROUTING ETC. But my program is not showing this material in my ALV o/p because, after my costing is run, bom is changes in period 08.2011 only and no further chnages at all. So while comparing 08/2011 and 09/2011 BOMs are same.

So, Instead comparing whole period 08/2011 and 09/2011, I want to compare the BOM and routings, from the day the costing is run for previos period to Current costing period run dat e i.e 10th aug, 2011 to 10th sep 2011 not 1st aug 2011 to 31st Oct 2011.

Current cost is stored in table MBEW, but not previous costing Date. I debugged MM03 many times, but still didnot find it.

Any suggestions .

Thanks in Advance

[Former Member · Accepted solution]

Instead of looking at the material master, you may want to look at the cost estimates themselves. You could then look at any cost estimates that were released in a given period of time, which would change the standard cost of the material. You could then compare the itemization of the new cost estimate to the itemization of the previous cost estimate to see the differences.

Have a look at the various bapis for cost estimates, using transaction code BAPI, then controlling-> product cost controlling-> cost estimate. specifically, getList, getDetail, and getItemization.

To know when the cost changed, you could look at change documents for the material, searching CDHDR and CDPOS, looking for changes to MBEW-STPRS in CDPOS.

just an idea...