Material yearly consumption report

[faisal_khan]

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.

[Lakshmipathi · Accepted solution]

Moved from Suggestions and Comments forum to MM forum

thanks

G. Lakshmipathi

[Former Member]

Hi

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

Regards

AKM

[Former Member]

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

[Former Member]

Also Check MVER Table.

[former_member187989]

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

[faisal_khan]

Hi,

Thanks for the tip. I used MB53 to see the consumption data by using the Consumption button. I was wondering if it is possible to copy the data from Consumption to excel. Presently the system does not allow me to copy the whole sheet. I user Ctrl + Y and then have to copy data three to four times by scrolling. Is there a way to copy the data in one go?

Regards

Faisal

[Lakshmipathi]

From MVER table, you can dowload the data into excel (System > List > Save > Local File)

thanks

G. Lakshmipathi

[former_member187989]

Possible,try with help of developer,for importing datas to excel(add an icon in screen,write code to achieve it), from screen.

There are reports available in (logistics information system,which you can drill down report to year in standard itself.Check it.

[Former Member]

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

[former_member533946]

Hi dear,

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

[BijayKumarBarik]

Hi,

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

Regards,

Biju K

[Former Member]

Hi,

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

can have all information you need in the layout

Regards,

Prashant