C_StockQtyCurrentValue_3

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
Authorizations One of the following business catalogs needs to be assigned to a user to be able to use this CDS view: Materials Management - Material Stock API ( SAP_MM_BC_IM_MAT_STOCK_API_PC ) Note SAP recommends using the OData service Current Stock Quantity and Value ( C_STOCKQTYCURRENTVALUE_3_CDS ) included in the Business Catalog Materials Management - Material Stock API ( SAP_MM_BC_IM_MAT_STOCK_API_PC ). Users who want to use this CDS view must have a role that includes authorization based on at least one of the business catalogs listed above. In this role, the following restriction types must be set to read access: Plant 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. 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 di