Skip to Content

Material yearly consumption report

Hi,

I have gone through many topics on getting the yearly consumption report of material but still could not get it.

We have just implemented SAP in our company and all transactions are being done from 1st Jan 2011. In Material Master we have added the consumption (under Forecast tab) month wise for the last four years.

Is there a way to see a report based on that, as I would like to accumulate the data year wise and see the last four years consumption.

Add a comment
10|10000 characters needed characters exceeded

Related questions

9 Answers

  • Best Answer
    Posted on Apr 22, 2011 at 06:41 AM

    Moved from Suggestions and Comments forum to MM forum

    thanks

    G. Lakshmipathi

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Apr 22, 2011 at 11:09 AM

    You can also find it using MB53,In report,Click consumption,You can see period wise total consumption.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Apr 23, 2011 at 05:54 AM

    Hi ,

    I would give you suggestion based on your question "Is there a way to see a report based on that, as I would like to accumulate the data year wise and see the last four years consumption."

    1st , are you using any PP related Production order ?

    This is very simple issue with movement type 261 if you are using PP.

    Since you would like to see accumulate the date year wise for last four years consumption , my suggest is based on the plan date from the last 4 years with 261 movement type for the raw material / semi finished in those order.

    Standard report

    COOIS Report - with movement type 261 based on order also possible to view.

    or

    MCRP- exact material consumption datewise or order wise.

    MC45 ,MCRE alternative report.

    For customize solution with abap,

    Please check with Table MVER - Material Consumption , MSEG (MENGE) and S026 (ENMNG)

    Pls restrict the selection condition for material with movement type 261 in table MSEG.

    If you using MRP area, perhaps you need check in table DVER - Material Consumption for MRP Area.

    Hope is clear and can help you.

    TQ

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Apr 23, 2011 at 05:59 AM

    Hi

    Use T-code SAP1 u will find all SAP standard reports

    Regards

    AKM

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Apr 22, 2011 at 07:00 AM

    Hi,

    MB51 - when going then into detail list (CtrlShiftF12) you

    can have all information you need in the layout

    Regards,

    Prashant

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Apr 22, 2011 at 07:11 AM

    Hi,

    Use t.code: MCRE & enter validity periods and execute.

    Regards,

    Biju K

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Apr 22, 2011 at 09:21 AM

    Hi dear,

    U can use T. codes MCRE,MCRX,MC45 to get the annual cosumption details.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Apr 22, 2011 at 10:21 AM

    Hi,

    You can get the data through MC.9

    You will get the details by selecting the varient.

    Regards,

    Manish Jain

    Edited by: Manish S Jain on Apr 22, 2011 1:29 PM

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Apr 22, 2011 at 01:57 PM

    Also Check MVER Table.

    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.