I_StockQuantityValueByType

DDL: I_STOCKQUANTITYVALUEBYTYPE Type: view COMPOSITE
18 Fields 1 Data Sources 2 Associations

Stock Quantity and Value by Type

I_StockQuantityValueByType (Composite)

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

Supply Chain

I_StockQuantityValueByType is a Composite CDS View (Cube) that provides data about "Stock Quantity and Value by Type" in SAP S/4HANA. It reads from 1 data source (P_StkValueByType4) and exposes 18 fields with key fields Material, Plant, StorageLocation, InventoryStockType, InventorySpecialStockType. It has 2 associations to related views.

SAP Help Documentation

CategoryCDS Views for Stock and Material Documents
Data CategoryCube
Purpose
This CDS view returns the current stock quantities and values for given stock types and special stock types. This CDS view provides the data to answer the following business questions: What is the current quantity of my material in unrestricted stock type? What is the value of my stock in blocked stock type?

Prerequisites
Authorizations Users who want to use this CDS view must have a role with the following restriction types set to read access: Plant (Plant) You can use the Display Restriction Types app to find out in which business catalogs these restriction types are included. Users who want to use this CDS view must have the following authorization objects assigned: m_mate_werk (Material Master: Materials) You can choose from the following activity setting: Display (activity = 03)

Structure
Important Fields Important fields in this view include the following: Field Name Description Measure or Attribute Comment Material Material for Stock Management Attribute Plant Plant Attribute StorageLocation Storage Location SID Attribute Storage Location (Stock Identifier) InventoryStockType Stock Type Attribute Stock Type of Goods Movement (Stock Identifier) InventorySpecialStockType Special Stock Type Attribute MaterialBaseUnit Base Unit of Measure Attribute Currency Currency Attribute Currency Key ValuationAreaType Valuation Area Attribute Valuation Area Setting MatlWrhsStkQtyInMatlBaseUnit Measure StockValueInCCCrcy Stock Value CC Currency Measure Stock Value in Company Code Currency

View on SAP Help Portal →

SAP API Hub

StateC1
Line of BusinessSupply Chain
Application ComponentMM-IM-VDM-SGM
CapabilitiesData Provider for Analytical Queries
PackageSupply Chain for SAP S/4HANA Cloud Private Edition

Documentation

Data Sources (1)

SourceAliasJoin Type
P_StkValueByType4 P_StkValueByType4 from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_Currency _Currency $projection.Currency = _Currency.Currency
[0..1] I_ProductPlantBasic _ProductPlantBasic $projection.Material = _ProductPlantBasic.Product and $projection.Plant = _ProductPlantBasic.Plant

Annotations (16)

NameValueLevelField
AbapCatalog.sqlViewName ISTOCKVALBYTYPE view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
EndUserText.label Stock Quantity and Value by Type view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.modelingPattern #ANALYTICAL_CUBE view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
Analytics.dataCategory #CUBE view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY Material Material Material for Stock Mamangement
KEY Plant Plant Valuation Area
KEY StorageLocation StorageLocation Storage Location (Stock Identifier)
KEY InventoryStockType InventoryStockType Stock Type of Goods Movement (Stock Identifier)
KEY InventorySpecialStockType InventorySpecialStockType Special Stock Type
KEY MaterialBaseUnit MaterialBaseUnit Base Unit of Measure
KEY Currency Currency Valuation Crcy
KEY ValuationAreaType ValuationAreaType Valuation area setting
MatlWrhsStkQtyInMatlBaseUnit MatlWrhsStkQtyInMatlBaseUnit Quantity
StockValueInCCCrcy StockValueInCCCrcy Stock Value in Company Code Currency
_Product _Product
_Plant _Plant
_StorageLocation _StorageLocation
_InventoryStockType _InventoryStockType
_InventorySpecialStockType _InventorySpecialStockType
_Currency _Currency
_MaterialBaseUnit _MaterialBaseUnit
_ProductPlantBasic _ProductPlantBasic

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 I_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 I_StockQuantityValueByType AS
SELECT
  Material,
  Plant,
  StorageLocation,
  InventoryStockType,
  InventorySpecialStockType,
  MaterialBaseUnit,
  Currency,
  ValuationAreaType,
  MatlWrhsStkQtyInMatlBaseUnit,
  StockValueInCCCrcy
FROM P_StkValueByType4
LEFT OUTER JOIN I_Currency AS _Currency ON Currency = _Currency.Currency  -- association [1..1]
LEFT OUTER JOIN I_ProductPlantBasic AS _ProductPlantBasic ON Material = _ProductPlantBasic.Product AND Plant = _ProductPlantBasic.Plant  -- association [0..1]
;

Learn More