ARUN_STOCK_TYPE_MENGE

DDL: ARUN_STOCK_TYPE_MENGE SQL: ARUN_V_STOCK Type: view
9 Fields 1 Data Sources

Select stock based on stock identifier

ARUN_STOCK_TYPE_MENGE is a CDS View that provides data about "Select stock based on stock identifier" in SAP S/4HANA. It reads from 1 data source (I_MaterialStock) and exposes 9 fields.

Data Sources (1)

SourceAliasJoin Type
I_MaterialStock ms from

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName ARUN_V_STOCK view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
EndUserText.label Select stock based on stock identifier view

Fields (9)

KeyFieldSource TableSource FieldDescription
Material I_MaterialStock Material Vehicle Model
Plant I_MaterialStock Plant Valuation Area
StorageLocation I_MaterialStock StorageLocation StorageLocation
Batch I_MaterialStock Batch Lot No.
InventoryStockType I_MaterialStock InventoryStockType Stock Type
InventorySpecialStockType I_MaterialStock InventorySpecialStockType Special Stock Type
Supplier I_MaterialStock Supplier Supplier
StockQty I_MaterialStock MatlWrhsStkQtyInMatlBaseUnit Quantity
MaterialBaseUnit I_MaterialStock MaterialBaseUnit Valuation Unit

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 ARUN_STOCK_TYPE_MENGE.
-- 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.
-- SQL view name: ARUN_V_STOCK

CREATE VIEW ARUN_STOCK_TYPE_MENGE AS
SELECT
  ms.Material AS Material,
  ms.Plant AS Plant,
  ms.StorageLocation AS StorageLocation,
  ms.Batch AS Batch,
  ms.InventoryStockType AS InventoryStockType,
  ms.InventorySpecialStockType AS InventorySpecialStockType,
  ms.Supplier AS Supplier,
  ms.MatlWrhsStkQtyInMatlBaseUnit AS StockQty,
  ms.MaterialBaseUnit AS MaterialBaseUnit
FROM I_MaterialStock AS ms
;

Learn More