库存表更新规则

最新推荐文章于 2025-03-17 21:25:55 发布

原创最新推荐文章于 2025-03-17 21:25:55 发布 · 670 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#table #system #each

MM 专栏收录该内容

2 篇文章

订阅专栏

在系统升级到4.5版本后，前一期或更早时期的库存及评估数据被转移到历史表格中，如MBEWH等，而不再保存在当前库存数据表内。每期历史表最多记录一次变动，仅当库存或评估数据发生改变时才创建记录，且记录的是期末数值。当前期未发生货物移动则不记录。

As of Release 4.5, stock fields and valuation fields relating to the previous period or to an earlier period are stored in history tables (for example, MBEWH, MARDH, MCHBH), and no longer in those tables in which the current stock data is stored (for example, MBEW, MARD, MCHB).

These history tables can contain one entry for each period. An entry is created in the history table only if the stock-relevant data or valuation-relevant data changes. The value of the entry relates to the end of the period. The history tables do not contain any entries for the current period.

Example

Scenario
At the start of period 02, there are 10 pieces of material 4711 in stock.

Goods receipt
5 pieces are received in period 02.

System response
The system records a stock of 10 pieces in the history table for period 01. At the same time, the system increases the current stock to 15 pieces.

Goods receipt
2 more pieces are received in period 02.

System response
The history table is unaffected by this event because an entry already exists for period 01. The system increases the current stock to 17 pieces.

Goods issue
4 pieces are withdrawn from stock in period 04.

System response
The system records a stock of 17 pieces in the history table for period 03. At the same time, the system reduces the current stock to 13 pieces. (The history table does not contain an entry for period 02 because there were no goods movements in period 03.)

Rules

1、If the history table does not contain an entry for the previous period, the values for the previous period are the same as those for the current period.

2、If the history table does not contain an entry for a period n that precedes the previous period, the values for period n are the same as those for period n+1.

Since the second rule can be applied recursively, it is possible to determine (in accordance with both rules) the values for any periods as of the period in which Release 4.5 or a subsequent release was implemented.