【MM系列】SAP MM模块-查看移动平均价的历史记录

公众号:matinal
本文作者:matinal
 

【MM系列】SAP MM模块-查看移动平均价的历史记录

前言部分

大家可以关注我的公众号,公众号里的排版更好,阅读更舒适。

正文部分

有两种方法,给大家介绍一下,关注公众号:SAP Technical

1:查看月度的移动平均价

查询两张表MBEW,MBEWH

MBEW:查看当前账期的移动平均价

MBEWH:查看历史账期的移动平均价

关于这两张表的详细的更新逻辑如下:

As MBEW is supposed to contain current values, when it has to be changed (like when updating material current price, etc.), the current value gets written to MBEWH and the new value gets written to MBEW.

The current standard is always in MBEW. When the first activity in a ‘period’ takes place valuation or quantity update; a record is written to MBEWH to document the balance, std, price control, that existed BEFORE the "first activity.

The number that represents the previous period record being written into the MBEWH table is represented in the ‘current period’ LFMON field.

2:查看即时的移动平均价

T-CODE:S_P00_07000139

在这里可以看到每次货物移动之后的移动平均价的变化。