C_StockQuantityValueByType

DDL: C_STOCKQUANTITYVALUEBYTYPE Type: view CONSUMPTION
17 Fields 1 Data Sources 1 Fiori Apps

Stock Quantity and Value by Type

C_StockQuantityValueByType is a Consumption CDS View that provides data about "Stock Quantity and Value by Type" in SAP S/4HANA. It reads from 1 data source (I_StockQuantityValueByType) and exposes 17 fields with key fields Material, Plant, StorageLocation, InventoryStockType, InventorySpecialStockType. It is used in 1 Fiori application: Overview Inventory Management.

Data Sources (1)

SourceAliasJoin Type
I_StockQuantityValueByType _StockQuantityValueByType from

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName CSTOCKVALBYTYPE view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
EndUserText.label Stock Quantity and Value by Type view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view
OData.publish true view
VDM.private false view
VDM.viewType #CONSUMPTION view
Analytics.query true view

Fiori Apps (1)

App IDApp NameTypeDescription
F2769 Overview Inventory Management Analytical This overview page displays KPIs and relevant information for inventory managers and related roles.

Overview Inventory Management

Business Role: Inventory Manager

The overview page Overview Inventory Management enables inventory managers to perform their daily tasks quickly and effectively without the need to open many different applications.Detailed information and access to underlying Fiori apps via the following cards is available via the overview page:Stock Value by Stock TypeStock Value by Special Stock TypeWarehouse Throughput HistoryMonitor Purchase Order ItemsRecent Material DocumentsOverdue Materials - GR Blocked Stock

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY Material Material Vehicle Model
KEY Plant Plant Valuation Area
KEY StorageLocation StorageLocation StorageLocation
KEY InventoryStockType InventoryStockType Stock Type
KEY InventorySpecialStockType InventorySpecialStockType Special Stock Type
KEY MaterialBaseUnit MaterialBaseUnit Valuation Unit
KEY Currency Currency Valuation Crcy
KEY ValuationAreaType ValuationAreaType Valuation area
MaterialGroup _Product ProductGroup Product Sold Group
MaterialType _Product ProductType Product Type Group
InventoryStockTypeName
InventorySpecialStockTypeName
PlantName _Plant PlantName Plant Name
MatlWrhsStkQtyInMatlBaseUnit MatlWrhsStkQtyInMatlBaseUnit Quantity
StockValueInCCCrcy StockValueInCCCrcy Total Value
_ProductGroup_2 _Product _ProductGroup_2
_ProductType _Product _ProductType

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_StockQuantityValueByType.
-- 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.

CREATE VIEW C_StockQuantityValueByType AS
SELECT
  Material,
  Plant,
  StorageLocation,
  InventoryStockType,
  InventorySpecialStockType,
  MaterialBaseUnit,
  Currency,
  ValuationAreaType,
  _Product.ProductGroup AS MaterialGroup,
  _Product.ProductType AS MaterialType,
  _InventoryStockType._Text[1: Language=$session.system_language].InventoryStockTypeName AS InventoryStockTypeName,
  _InventorySpecialStockType._Text[1: Language=$session.system_language].InventorySpecialStockTypeName AS InventorySpecialStockTypeName,
  _Plant.PlantName AS PlantName,
  MatlWrhsStkQtyInMatlBaseUnit,
  StockValueInCCCrcy,
  _Product._ProductGroup_2 AS _ProductGroup_2,
  _Product._ProductType AS _ProductType
FROM I_StockQuantityValueByType AS _StockQuantityValueByType
;

Learn More