P_SrlNmbrStockDiffSrlNmbrStock

DDL: P_SRLNMBRSTOCKDIFFSRLNMBRSTOCK Type: view_entity COMPOSITE
16 Fields 1 Data Sources 3 Associations

Serial Number Stock Quantity

P_SrlNmbrStockDiffSrlNmbrStock is a Composite CDS View that provides data about "Serial Number Stock Quantity" in SAP S/4HANA. It reads from 1 data source (P_SrlNmbrStockDiffSrlStockSgmt) and exposes 16 fields with key fields Material, Plant, Batch, StorageLocation, InventoryStockType. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
P_SrlNmbrStockDiffSrlStockSgmt P_SrlNmbrStockDiffSrlStockSgmt from

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_ProductPlant _MaterialPlant $projection.Material = _MaterialPlant.Product and $projection.Plant = _MaterialPlant.Plant
[0..1] I_ValuationArea _CompanyCode $projection.Plant = _CompanyCode.ValuationArea
[0..1] I_Material _Material $projection.Material = _Material.Material

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Serial Number Stock Quantity view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.private true view
VDM.viewType #COMPOSITE view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY Material Material Vehicle Model
KEY Plant Plant Valuation Area
KEY Batch Batch Lot No.
KEY StorageLocation StorageLocation StorageLocation
KEY InventoryStockType InventoryStockType Stock Type
KEY InventorySpecialStockType InventorySpecialStockType Special Stock Type
KEY Supplier Supplier Supplier
KEY SalesOrder SalesOrder SD Document
KEY SalesOrderItem SalesOrderItem Sales Order Item
KEY WBSElementInternalID WBS Internal ID
KEY Customer Customer Sold-to Party
KEY StockOwner StockOwner Owner of stock
KEY CompanyCode _CompanyCode CompanyCode Receiver Company Code
SerialNumberQuantity
MaterialBaseUnit _Material MaterialBaseUnit Valuation Unit
SerialNumberProfile _MaterialPlant SerialNumberProfile SerialNoProfile

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 P_SrlNmbrStockDiffSrlNmbrStock.
-- 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 P_SrlNmbrStockDiffSrlNmbrStock AS
SELECT
  Material,
  Plant,
  Batch,
  StorageLocation,
  InventoryStockType,
  InventorySpecialStockType,
  Supplier,
  SalesOrder,
  SalesOrderItem,
  cast(WBSElementInternalID as nsdm_wbselement_internal_id preserving type ) AS WBSElementInternalID,
  Customer,
  StockOwner,
  _CompanyCode.CompanyCode AS CompanyCode,
  cast( count(*) as nsdm_stock_qty ) AS SerialNumberQuantity,
  _Material.MaterialBaseUnit AS MaterialBaseUnit,
  _MaterialPlant.SerialNumberProfile AS SerialNumberProfile
FROM P_SrlNmbrStockDiffSrlStockSgmt
LEFT OUTER JOIN I_ProductPlant AS _MaterialPlant ON Material = _MaterialPlant.Product AND Plant = _MaterialPlant.Plant  -- association [1..1]
LEFT OUTER JOIN I_ValuationArea AS _CompanyCode ON Plant = _CompanyCode.ValuationArea  -- association [0..1]
LEFT OUTER JOIN I_Material AS _Material ON Material = _Material.Material  -- association [0..1]
;

Learn More