business-controlling How to view the history of the moving weighted average of materials

Purpose:  We need to get the history of the weighted average for a material.

Transaction SE16N - General Purpose database table viewer

SE16N is a general program that can output any system table from the system. The table that holds the weighted average history is MBEW.

The following selection outputs the data for product 50805-MCT6:

The output is:

In the example we observe that this item was uploaded from JDE with piece cost of 0,38 BGN/ Piece (MBEWH is always in local currency). Then production in May 2019 upped the price cost to 0,54 BGN / Piece and then production in June 2020 moved the unit cost to 0,81 BGN / Piece.