I decided to post this blog, because there is a topic coming up from time to time by our customers, which causes many confusion and misunderstanding, although it is not so complicated as it looks like to be for first.
I hope after reading my explanation many people will get the answer for their doubts.
When putting a structured article together of its’ components (movement 317)
or splitting it up eg. at the time of posting Goods Receipt (movement 319)
the calculation of the MAP (Moving Average Price) of the components will be detailed below.
Some basics first
The MAP calculation works basically as per this formula:
The current MAP is stored in MBEW table (field VERPR).
When looking for the history of a specific MAP, the CKMI1 table will show to necessary entries.
The key (KALNR field) value can be extracted from the MBEW table, by copying the KALN1 field.
It makes sense to enter also a range for the Date in CKMI1, reducing the relevant entries for those days, when the questionable movements have happened. As soon as we display the list of corresponding DB entries, we can easily follow the changes happened to the MAP by posting the different material documents (AWREF field in CKMI1).
MAP of Structured article
Let’s take an example for easier understanding:
|Cosmetics Gift||2 Lipsticks||+ 1 Perfume|
|MAP:||10 / PC||200 / PC|
The posting value of the components is calculated as per the following formula:
This is nothing else then distributing the posting value of the structured article proportionally to the components also considering the contribution of each components by weighting them in the formula.
If the sales set “Cosmetics Gift” is sold with value of 199, the formula applied for each components:
- Lipstick: 10 * 199 / ( 2 * 10 + 1 * 200) = 9.0454545
- Pefume: 200 * 199 / ( 2 * 10 + 1 * 200) = 180.909090
Checkback: 2 * 9.045 + 180.909 = 199 OK!
Similar example can be found on SAP help portal as well, with less explanation and without formulas.