Average stock consumption

[Former Member]

Hi,

May i know which tcode or table is used to see the average consumption per month of a material.

[Former Member]

Hi,

Use T code - MCBE and add avarage consumption.

Abhinay Sachan

[Former Member]

Hi

U can use MC.9

after executing report press F6 and select Average consumption from pool

Vishal...

[Former Member]

HI Vishal and VK,

thanks for your response ,i wanna knwo which table should i use bcoz

VK u r saying that use MVER and in the tcode MC.9 it is mentioned that the table in which it is storing is S039 which is for Statistics: Inventory Controlling.

which will guide me to the correct data?

[Former Member]

Hi

MVER Material consumption is a correct table u can use same

Vishal...

[Former Member]

Hi Vishal,

Actually my client requierments are these:-

1.) Average consumption per month

2.) Average stock per month

if tcode MC.9 is for the avg. consumption per month and table is MVER then what will be the purpose of the tcode MB51 and the table MSEG .

can u plzz provide the guidelines for it?

[Former Member]

Hi

MB51 - Material Document List

MSEG material document (item level)

both these will give u material document list as per selection criteria

in MC.9 u will get both reports as per req. i.e period to analyze

1.) Average consumption per month (Average consumption)

2.) Average stock per month (Avg. total stock)

Vishal...

[Former Member]

hi vishal,

it means i have to use the MVER table which will solve my both requierments.

[Former Member]

Hi

MC.9 is a std report given by SAP for Both of ur requirements so no need to develop seperate report using MVER

in first screen of MC.9 u have to put period to analyse i.e no of months ..then in second screen press F6

add fields Average consumption and Avg. total stock which is as per ur requirement

1.) Average consumption per month (Average consumption)

2.) Average stock per month (Avg. total stock)

Vishal...

[Former Member]

hi,

i taked to my client and he said he want to have the ABAP report as it is going to be the addition of the previous report which i had made.

so should i use S031 table instead of MVER there i find similar data as MVER which does not have the date( month wise) where as it is present in the S031 table.

should i use it or not?

Edited by: abaper2008 on May 28, 2008 9:22 AM

[Former Member]

Hi

if ur comfortable with S031 info structure ..u can use same for report

Vishal...

[Former Member]

Hi,

T.code - MC.9

Table - MVER