Skip to Content
0
Former Member
Aug 31, 2009 at 09:06 PM

Matl. Mstr Consumption data does not tie to MSEG or S026 table consumption

238 Views

Hello all;

I have a request to provide a report showing Weekly, Monthly, and Quarterly consumption of material on the same report line.

I have been using the MVER and DVER tables for monthly and quarterly consumption totals.

I figured that in order for me to obtain the Weekly configuration totals, I would either read through the MSEG table for the weekly date range for Movement Type 261 and sum up the quantities, or read through the S026 table for the data range.

But, the totals from the MSEG and S026 tables do not add up to the totals displayed on the monthly MVER/DVER tables.

We only have one MRP Area value, so the totals between the base and the MRP Area.

How exactly and with what are the MVER and DVER tables updated?

I know that in configuration for Movement Type's, there is a flag "Consumption" flag that denotes the movement type addes to consumption totals and we have those movment types as part of the MSEG selection.

Thanks.

Scott.