Ansicht
Dokumentation
MBMAPCHANGES - Moving Average Price Change Analysis
SUBST_MERGE_LIST - merge external lists to one complete list with #if... logic for R3up TXBHW - Original Tax Base Amount in Local CurrencyThis documentation is copyright by SAP AG.
Purpose
The purpose of this report is to provide a tool that enables the analysis of moving average price changes of certain materials. There can be numerous documents that change the V-price: material documents, invoice documents, account maintenance documents, material ledger documents, production settlement documents, etc., therefore it is not always easy to determine why and how the V-price changed. This tool provides a central access point to display all these documents and enables the end-users to determine a threshold % over which moving average price changes are to be considered "significant".
Features
The report can be executed for both price control types S and V however the statistical MAP changes of the standard price controlled materials are not always reliable therefore these document lists and figures should be interpreted accordingly. (See section "Statistical moving average price changes")
It is possible to navigate to the corresponding reference documents by double-clicking lines of the output list.
In case the status icons are double-clicked a pop-up will be opened with additional information and further navigation options to the reference documents or the application documentation.
Display legend:
- Blue lines:
Documents where the price change falls into the highlight threshold percentage.
- Red lines:
Documents where a V-price controlled material's price change exceeds the threshold percentage.
(See section "Significant moving average price changes")
- Yellow lines:
Documents where a S-price controlled material's price change exceeds the threshold percentage.
(See section "Statistical moving average price changes")
- Yellow lines with red highlight:
Documents posted in the previous period where the price change exceeds the threshold percentage.
(See section "Back posting scenarios ")
- Yellow lines with blue highlight:
Documents posted in the previous where the price change falls into the highlight threshold percentage.
(See section "Back posting scenarios ")
Selection criteria
The selection screen contains six blocks:
1) "Material data": In case you wish to analyze normal
stocks' valuation you only have to fill out data in this block. Material and valuation area are obligatory
parameters, whereas valuation type will be requested in case the material is split valuated. This leads to selections from database table MBEW.
2) "Additional data for sales order stock valuation": If you have materials that use sales order stock valuation you can additionally fill out the special stock indicator and the reference sales order and its item. This leads to selections from database table EBEW.
3) "Additional data for sales order stock valuation": If you have materials that use project stock valuation you can additionally fill out the special stock indicator and the reference WBS element. This leads to selections from database table QBEW.
4) "Posting date restrictions": ~ can restrict the list of documents displayed for:
o posting years
o posting periods
o entry dates
5) "Reference document restriction": Here you can restrict
the list of documents displayed up to/from a certain reference document chronologically. If these selection
parameters are filled the "Posting date restrictions" will not be applied even if these were filled.
6) "Output settings": The threshold percentage can be set here for defining a significant price
change. Changes over this percentage will be highlighted red for V-Price materials, yellow for S-Price
materials. Price changes that cannot be expressed as a percentage (changing from/to zero) will be automatically highlighted as well. By leaving this field empty or by entering zero you can turn off the highlighting.
You can also create custom layouts for the output of this report and set up standard / default layouts.
Authorizations
During the execution of this report the system checks the following authorizations:
Display company code: authorization object F_BKPF_BUK / activity 03
Display authorization for transactions: MIGO, CKMPCD, MIR4, MR11SHOW, CKMB, KO8B
About the V-price calculations:
Materials with price control V:
The moving average price is always a dynamically calculated value
that is determined as the quotient of the total_stock_value and total_stock_quantity. Whenever a posting is made in the system that affects either of these, the moving average price will also be updated.
Materials with price control S:
When using standard price controlled materials the system will still
calculate the moving average price in the background, this is what we call the statistical moving average price. This value is being calculated similarly to the normal V-price.
Special cases:
A) When the total stock is removed the moving average is retained and will not change to 0. This behavior is explained in SAP note 518485 point 4.
B) For negative valuated stocks, a special posting logic must be followed for determining the stock posting for moving average price. This behavior is explained in SAP notes 196505 and 212286.
Significant moving average price changes:
If the threshold% entered on the selection screen is exceeded the line will be highlighted and marked
as "significant price change". In such cases you should check the reference document that resulted in the price change by double-clicking the highlighted line.
Typical reasons for MAP changes:
o Unexpected or incorrect order price in the reference purchase order
o Unexpected external price used in goods movements
o Unexpected or incorrect price changes, account maintenances, invoices, credit memos or settlements
In case the current moving average price is not satisfactory the easiest and most recommended way is to post a new price change document using transaction MR21 or changing the price directly in the material master (MM02).
Back posting scenarios:
If a document is posted in the previous period the application logs the effects in two separate lines:
- One that alters the previous period data
- One that alters the current period data
In the line of the previous period data the system reads the "total valuated stock before posting" and the "total stock value before posting" from the corresponding history tables (MBEWH/EBEWH/QBEWH).
This data will be the basis of determining the old and new moving average prices of the "back posting line.
The quantity and value of the postings will be directly copied from the reference document and used to calculate the new moving average price in the previous period using the following formula:
( total_value_before_posting + value_posted ) / ( total_stock_before_posting + quantity_posted )
In the line of current period the system reads the "total valuated stock before posting" and the "total stock value before posting" are read from the current valuation tables (MBEW/EBEW/QBEW).
This data will be the basis of determining the old and new moving average prices of the "current period
posting". The quantity posted will be copied from the reference document however the value of posting
will be split between the current period and the previous one. To determine the actual V-price change
the value of the current period's line will be adjusted with the "back posting" value as follows:
( total_value_before_posting + [ value_posted_in_previous_period + value_posted ] ) / ( total_stock_before_posting + quantity_posted )
If the entire stock is removed in the previous period the moving average price of the previous period will be retained, whereas the moving average price in the current period MAY be (even significantly) changed. If the stock in the current period is the same as the stock was in the previous period both MAP values will be retained.
Statistical moving average price changes:
Documents that only change the statistical moving average price are not logged in the standard system. These changes are only visible if the postings also impact the total_quantity or the total_value. Due to this the statistical V-price calculations of this report are not reliable and not supported.
The change logs can be displayed however to provide an access point to documents that are actually logged, however the output columns "New V-Price" and "New V-Price Per Unit" and highlights for significant pricechanges are not displayed.
In case of material documents field MSEG-BUALT contains the value that were to be posted in case the material had the alternative price control. This may be used for individual analysis however this report does not provide the full functionality of statistical V-price change logs.
Limitations:
1. The report does NOT display documents in the output list which have no corresponding accounting entry.
For example: price change documents which change the moving average price of a material when the total stock is zero will not be included in the list even though they change the MAP.
2. The document list of materials which have undergone price unit change(s) after documents have already been posted cannot be displayed correctly by the report. These special cases are handled as follows:
- Warning message is issued
- "New V-Price" and "New V-Price Per Unit" columns are not displayed
- Highlights for significant price changes are not displayed
Purpose
Integration
Prerequisites
Features
Selection
Standard Variants
Output
Activities
Example
rdisp/max_wprun_time - Maximum work process run time RFUMSV00 - Advance Return for Tax on Sales/Purchases
This documentation is copyright by SAP AG.
Length: 10571 Date: 20240531 Time: 091139 sap01-206 ( 186 ms )
