What is C_StockQtyCurrentValue_2 in SAP S/4HANA?

C_StockQtyCurrentValue_2 is a consumption CDS view in SAP S/4HANA. Current stock quantity and value It contains 21 fields.

Which tables does C_StockQtyCurrentValue_2 read from?

C_StockQtyCurrentValue_2 reads data from: I_StockQuantityCurrentValue.

What VDM layer is C_StockQtyCurrentValue_2?

C_StockQtyCurrentValue_2 is classified as a Consumption view optimized for specific business scenarios and reporting.

C_StockQtyCurrentValue_2

DDL: C_STOCKQTYCURRENTVALUE_2 Type: view CONSUMPTION

21 Fields 1 Data Sources

Current stock quantity and value

C_StockQtyCurrentValue_2 (Consumption)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

Supply Chain

C_StockQtyCurrentValue_2 is a Consumption CDS View that provides data about "Current stock quantity and value" in SAP S/4HANA. It reads from 1 data source (I_StockQuantityCurrentValue) and exposes 21 fields.

SAP API Hub

State	C1
Line of Business	Supply Chain
Application Component	MM-IM-VDM-SGM
Capabilities	Analytical Query
Package	Supply Chain for SAP S/4HANA Cloud Private Edition
Description	<p>This CDS view provides the prerequisites for answering the following business question:</p> <ul> <li><p>What is the current material stock quantity and the current material stock value for a particular stock where "the stock value is valuated" by the price at period end?</p></li> </ul>

Documentation

Analytics with CDS Views — Build Analytics for S/4HANA Cloud Private Edition ABAP CDS views replicated to SAP Cloud Platform
CDS Views on SAP Business Accelerator Hub — Explore SAP S/4HANA Cloud Private Edition Private Edition CDS Views on SAP Business Accelerator Hub
Create CDS View as API — Create CDS views in SAP S/4HANA Cloud Private Edition and consume them as APIs
Custom CDS Views — Access data using a Custom Core Data Service view (Custom CDS view)
Key User Extensibility Tools — The Key User Extensibility Tools of S/4HANA
SAP Extensibility Explorer for SAP S/4HANA Cloud Private Edition — Explore SAP S/4HANA Cloud Private Edition Extensibility options by leveraging the sample scenarios from SAP
SAP S/4HANA Extensibility — SAP S/4HANA Extensibility Tutorial
VDM View Types — The Virtual Data Model in SAP S/4HANA Cloud Private Edition
View Browser — Search, browse and tag CDS Views

Data Sources (1)

Source	Alias	Join Type
I_StockQuantityCurrentValue	I_StockQuantityCurrentValue	from

Parameters (1)

Name	Type	Default
P_DisplayCurrency	nsdm_display_currency

Annotations (16)

Name	Value	Level
AbapCatalog.sqlViewName	CSTKQUANVALCUR2	view
AbapCatalog.preserveKey	true	view
AbapCatalog.compiler.compareFilter	true	view
AccessControl.authorizationCheck	#PRIVILEGED_ONLY	view
EndUserText.label	Current stock quantity and value	view
ObjectModel.usageType.sizeCategory	#XXL	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view
ObjectModel.modelingPattern	#ANALYTICAL_QUERY	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
VDM.viewType	#CONSUMPTION	view
VDM.lifecycle.status	#DEPRECATED	view
VDM.lifecycle.successor	C_STOCKQTYCURRENTVALUE_3	view
Analytics.query	true	view
OData.publish	true	view
Metadata.allowExtensions	true	view

Fields (21)

Field	Source Field	Description
defaultValueEUR
P_DisplayCurrencyProduct
Plant	Plant	Valuation Area
StorageLocation	StorageLocation	Storage Location
Batch	Batch	Batch Number (Stock Identifier)
Supplier	Supplier	Supplier for Special Stock
SDDocument	SDDocument	Sales Order Number of Valuated Sales Order Stock
SDDocumentItem	SDDocumentItem	Sales Order Item of Valuated Sales Order Stock
WBSElementInternalID	WBSElementInternalID	Valuated Sales Order Stock WBS Element
Customer	Customer	Customer for Special Stock
SpecialStockIdfgStockOwner	SpecialStockIdfgStockOwner	Add. Supplier for Special Stock
InventoryStockType	InventoryStockType	Stock Type of Goods Movement (Stock Identifier)
InventorySpecialStockType	InventorySpecialStockType	Special Stock Type
ProductGroup	ProductGroup	Product Sold Group
ProductType	ProductType	Product Type Group
MaterialBaseUnit	MaterialBaseUnit	Base Unit of Measure
Currency	Currency	Valuation Crcy
DisplayCurrency	DisplayCurrency	Display Currency
MatlWrhsStkQtyInMatlBaseUnit	MatlWrhsStkQtyInMatlBaseUnit	Stock Quantity in Base Unit of Measure
StockValueInCCCrcy	StockValueInCCCrcy	Stock Value in Company Code Currency
StockValueInDisplayCurrency	StockValueInDisplayCurrency	Stock Value in Display Currency

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view C_StockQtyCurrentValue_2.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- Parameters: P_DisplayCurrency : nsdm_display_currency

CREATE VIEW C_StockQtyCurrentValue_2 AS
SELECT
  defaultValue: 'EUR' AS defaultValueEUR,
  valueHelpDefinition: [{ entity: { name:'I_Currency', element:'Currency' AS P_DisplayCurrencyProduct,
  Plant,
  StorageLocation,
  Batch,
  Supplier,
  SDDocument,
  SDDocumentItem,
  WBSElementInternalID,
  Customer,
  SpecialStockIdfgStockOwner,
  InventoryStockType,
  InventorySpecialStockType,
  ProductGroup,
  ProductType,
  MaterialBaseUnit,
  Currency,
  DisplayCurrency,
  MatlWrhsStkQtyInMatlBaseUnit,
  StockValueInCCCrcy,
  StockValueInDisplayCurrency
FROM I_StockQuantityCurrentValue
;

Depth:

C_StockQtyCurrentValue_2 view

I_StockQuantityCurrentValue view