Query/report to find out Material consumption

[Former Member]

Hello,

Is there any report or T.code other than MB51 to find out whether a material has been consumed or not in the last 6 months or 1 year.

Regards

Goutham

[Former Member]

Hi,

Please use report MCBE to analyse material wise qty received ,Consumed and total usage as per month wise.

Hope this will solve your problem.

Thanks & Regards,

Bijay Pradhan

[former_member187989]

In MB53 Report,Click consumption to know about consumption for all periods.

[pardeep_malik]

Hi,

1. T code

MC42

MC43

MC.G

MC.4

This report will help you in getting the information of coverage of the material for production purpose based on the past consumption pattern. The report can be executed material wise, commodity type wise, material planner wise etc.

2.

MC46 This report will help you to identify slow moving items.

MC50 This report will help you to identify dead inventory

MC45 This report identifies the share of the usage value to the total usage. You can also see the report graphically for a selected material in detail screen.

Hope Help U !!

Regards,

Pardeep Malik

[rafael_zaragatzky]

Hi Goutham,

You might also want to check trs MC46 (slow movers) showing for each material when it was recently consumed, sorted from the longest period to the shortest and also showing their stock value.

Here's the documentation of the report: [http://help.sap.com/erp2005_ehp_02/helpdata/en/c1/3761bf449a11d188fe0000e8322f96/frameset.htm].

BR

Raf

Edited by: Rafael Zaragatzky on May 20, 2011 10:44 PM

[Former Member]

Check the material master Additional Data. You will have a tab called Consumption for every period.

Check MB5B, it will give you the issues for a particular period.

[amitbakshi3]

Hi,

Go to SE16 and enter Table MVER to get the consumption of the Material.

If you need to check the PO & GR as well, then enter Table EKBE and it will list the PO and GR.

Hope it helps,

Best regards

Amit Bakshi