material consumption history MVER

[Former Member]

Dear all,

I need to get the material consumption history from table MVER, But my problem is that the Data is only at the Fiscal & Plant level for particular material.

We have Storage Locations (LGORT), I need to show the Consumption history at storage location level, I am not able to find out how. I tried using Table MSEG but did not succeded.

Please help me in getting the Material Consumtion data based on plant and storage location level.

[Former Member]

Hi sanjeev,

If i'm not going wrong material consumption data conbe retrived from S031 table it does contain the fields spmon(period to analyze month) SPTAG(current date)and matnr werks and lgort material consumption is calculated on field AGVBR u can add up this value for the various storage locations and have the consumption data.

thanks and check if this works for u

[Former Member]

Hi sudhakar,

thanks a lot for the solution. I got the material consumption data at the storagge location level using the field spmon(fiscal month) & MGVBR (total consumption) in table S031.

Regards,,

sanjeev.