微信搜索公众号:SAP中文学习网交流平台      SAP技术千人群: SAP中文学习网技术群      SAP技术交流2群:SAP技术交流2群      SAP新人群:SAP中文学习网新人群     

SAP中文学习网

查看移动平均价的历史记录?

来源: 互联网TAG标签: 作者:SAP中文学习网 点击:

两种方法

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

      查询两张表MBEW,MBEWH

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

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

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

       T-CODE:S_P00_07000139

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

 


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

 


 

MBEWH table is updated whenever there is change in Moving Average Price.
 

MBEWH is basically the History table for MBEW - Material Valuation table.
 

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. 
 

EXAMPLE: when the first activity occurs in period 3 (i.e., a goods receipt), an entry is written into the MBEWH table with a ‘current period’ number of 2. The quant and value updated to the ‘total stock’ and ‘total value’ fields are equal to the data that represents these fields PRIOR to the activity quant and value occurring in period 3.
 

If there is no activity for several periods, you will not have entries for every period in the MBEWH table.
 

What is difference between MBEWH & MCHBH table?

Why are stock in these table different?

I have two reports one is for Stock at PLANT level and one BATCH level . They used table for quantity MBEWH for PLANT level and MCHBH for BATCH level and whenever displaying quantity is different in both reports ?

MBEWH table is referring to total valuated stock

MCHBH table is referring to valuated stock with unrestricted

(编辑:cindy liu )
顶一下
(3)
60%
踩一下
(2)
40%
------分隔线----------------------------
您有可能感兴趣的文章