P_SrlNmbrStockDiffSrlStockSgmt

DDL: P_SRLNMBRSTOCKDIFFSRLSTOCKSGMT Type: view_entity COMPOSITE Package: ODATA_LO_SN_STOCK_QUANTITIES
28 Fields 1 Data Sources 1 Associations

Serial Number Stock Info

P_SrlNmbrStockDiffSrlStockSgmt is a Composite CDS View that provides data about "Serial Number Stock Info" in SAP S/4HANA. It reads from 1 data source (I_SerialNumberStockSegment) and exposes 28 fields with key fields Material, SerialNumber. It has 1 association to related views. Part of development package ODATA_LO_SN_STOCK_QUANTITIES.

Data Sources (1)

SourceAliasJoin Type
I_SerialNumberStockSegment I_SerialNumberStockSegment from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_ProductPlant _MaterialPlant $projection.Material = _MaterialPlant.Product and $projection.Plant = _MaterialPlant.Plant

Annotations (8)

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

Fields (28)

KeyFieldSource TableSource FieldDescription
KEY Material Material Vehicle Model
KEY SerialNumber SerialNumber Serial Number
Equipment Equipment Equipment check
Plant Plant Valuation Area
StorageLocation StorageLocation StorageLocation
Customer Customer Sold-to Party
Supplier Supplier Supplier
SalesOrder SalesOrder SD Document
SalesOrderItem SalesOrderItem Sales Order Item
InventorySpecialStockType InventorySpecialStockType Special Stock Type
WBSElementInternalID WBSElementInternalID WBS Internal ID
Batch Batch Lot No.
InventoryStockType InventoryStockType Stock Type
StockOwner StockOwner Owner of stock
SerialNumberProfile _MaterialPlant SerialNumberProfile SerialNoProfile
_Customer _Customer
_CustomerCompanyByPlant _CustomerCompanyByPlant
_Equipment _Equipment
_InventorySpecialStockType _InventorySpecialStockType
_InventoryStockType _InventoryStockType
_Material _Material
_Plant _Plant
_SalesOrder _SalesOrder
_SalesOrderItem _SalesOrderItem
_StorageLocation _StorageLocation
_Supplier _Supplier
_SupplierCompanyByPlant _SupplierCompanyByPlant
_WBSElementByInternalKey _WBSElementByInternalKey

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_SrlNmbrStockDiffSrlStockSgmt.
-- 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_SrlNmbrStockDiffSrlStockSgmt AS
SELECT
  Material,
  SerialNumber,
  Equipment,
  Plant,
  StorageLocation,
  Customer,
  Supplier,
  SalesOrder,
  SalesOrderItem,
  InventorySpecialStockType,
  WBSElementInternalID,
  Batch,
  InventoryStockType,
  StockOwner,
  _MaterialPlant.SerialNumberProfile AS SerialNumberProfile
FROM I_SerialNumberStockSegment
LEFT OUTER JOIN I_ProductPlant AS _MaterialPlant ON Material = _MaterialPlant.Product AND Plant = _MaterialPlant.Plant  -- association [1..1]
;

Learn More