Skip to Content
author's profile photo Former Member
Former Member

Tracking Causes for change in standard cost of material

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Nov 22, 2011 at 12:54 PM

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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.