The analytical app displays the Key Performance Indicator (KPI) Valuated Stock Value. You can display the closing valuated stock value based on a specific end date. This KPI enables warehouse managers to get an overview according to the dimensions plant, type of material, or product hierarchy. This information about the aggregated stock situation allows warehouse managers to react in a timely manner.
Calculation rule:
The closing valuated stock value is the key date value at the end of a specific time frame. To determine the valuated stock, all relevant postings, for example, all goods movements or price changes, are considered.
The point in time, in this case, the day on which a business process took place, is important to determine its share in the calculation result. This includes the calculation of average values and quantities.
To get a realistic calculation of averages for all average inventories, a specific weighting approach is used in the Inventory Management KPIs: for the calculation of each business process, such as a goods receipt, the posting date is considered in relation to the number of days within the specific time frame. The posting date of the business process itself is considered with half a day.
Example
The weighting factor for a goods receipt that increases the stock at the end of the specific time frame is lower than for a goods receipt that was posted at the beginning of the specific time frame.
Generic drill down:
You can use the following measures: AvgVltdStockValInCoCodeCrcy_E, ClsgVltdStockValInCoCodeCrcy_E
Corresponding Query view: sap.hba.r.ecc.MaterialValStockOnDateQuery
Displays the closing valuated stock value on a specific end date.
Note
The function Multidimensional Reporting for this query view is not available for generic SAP clients. That means that this query view cannot be used for other SAP Smart Business Apps.
KPI type: amount
Dimensions:
Input parameters: SAP client, start date, end date
Filter: company code, plant, material, material type, material group, product hierarchy, inventory valuation type, inventory special stock type, sales document, sales document item, WBS element, vendor, inventory valuation category, material valuation class, currency, material base unit, company code name, material name, MRP controller, purchasing group, unit of measure commercial name
The app consists of front-end components and back-end components. The back-end components and the front-end components are delivered in separate products and have to be installed in a system landscape that is enabled for SAP Fiori.
SAP Smart Business Product | SAP Smart Business 1.0 for SAP ERP SPS05 |
---|---|
Contains Virtual Data Model (VDM) | SAP HANA Live 1.0 for SAP ERP SPS09 |
SAP Business Suite Product | SAP enhancement package 7 for SAP ERP 6.0 SPS07 |
For more information about the installation of the front-end components, see Installation Requirements (Analytical Apps).
Fiori UI for Inventory Management (MM-FIO-IM)