I_StockQuantityCurrentValue_2

Purpose
This CDS view retrieves the time-dependent records of quantity and value for a particular stock. This CDS view provides the prerequisites for answering the following business question: What is the current material stock quantity and the current material stock value for a particular stock at current prices? To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views .

Prerequisites
Configuration You have configured the currency conversion rates to use the value in reporting currency.

Structure
Business Objects The business object Material Stock provides information about absolute stock and stock changes derived from the business object Material Document . Parameters The view has the following input parameter: Reporting Currency The parameters of the CDS view are as follows: P_DisplayCurrency used to set the display currency for stock values. Fields used for filtering The main filters are as follows: Product used to select the materials of interest. Plant used to select the plant of interest. ValuationAreaType used to determine the correct inventory prices. This field must be set at either 1 or 3 . The correct values can be determined from view F_ValuationAreaType . Not setting this filter will result in incorrect data. Some important measures are: Material stock quantity in material base unit Material stock value in company code currency Material stock value in reporting currency Further important fields Important fields in this view include the following: Field Name Description Measure or Attribute Comment Product Material in Respect of Which Stock is Managed Attribute Plant Plant Attribute StorageLocation Storage Location Attribute InventoryStockType Stock Type of Goods Movement Attribute InventorySpecialStockType Special Stock Type Attribute MatlWrhsStkQtyInMatlBaseUnit Stock Quantity in Base Unit of Measure Measure StockValueInCCCrcy Stock Value in Company Code Currency Measure StockValueInDisplayCurrency Stock Value in Display Currency Measure

Calculation of Stock Values
Calculation Methods Caution Note that the stock value calculation in MM-IM Fiori apps and CDS views cannot be compared with the stock value calculation in Finance (FI) or in Material Ledger (ML). Variances are possible because of specific calculation procedures (including rounding) within MM-IM compared to Finance and Material Ledger. In MM-IM, the stock values are calculated to enable aggregation across materials with different base units of measure and therefore have a rather informational character and can’t be used for legal reporting. Comparison of Calculation Methods MM-IM Calculation Method Finance and Material Ledger Calculation Method The system calculates the stock value at a certain date and independent of the reporting date you have chosen, as follows: stock value = stock quantity (of a particular stock type and/or a certain date) * current material price Note Note that the current material price is also a calculated price. There are two ways to calculate the current material price: total amount / total quantity by price / price unit Rounding can occur as a result of these types of calculation of the stock value. If you also want to sum up stock values across different levels (unrestricted stock of batches of a material, for example), existing rounding is also summed up (unrestricted stock of material on plant, for example). The system calculates the stock value as follows: stock value = sum of all values received/issued/changed up to a certain date Example Sample Code cast( round( cast(MatlWrhsStkQtyInMatlBaseUnit as abap.dec( 21, 3 )) * division( cast(_Cur