I_SerialNumberStockSegment

DDL: I_SERIALNUMBERSTOCKSEGMENT SQL: ISERNUMSTOCKSEG Type: view BASIC
27 Fields 2 Data Sources

Serial Number Stock Segment

I_SerialNumberStockSegment (Basic)

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

Database & Data Management

I_SerialNumberStockSegment is a Basic CDS View (Dimension) that provides data about "Serial Number Stock Segment" in SAP S/4HANA. It reads from 2 data sources (I_Equipment, I_EquipmentStockSegment) and exposes 27 fields with key fields Material, SerialNumber.

SAP API Hub

StateC1
Line of BusinessDatabase & Data Management
Application ComponentLO-MD-SN
CapabilitiesData Source in SQL Select, Association Target for Defining CDS Entities, Data Source for Defining CDS Entities, Analytical Dimension
PackageDatabase & Data Management for SAP S/4HANA Cloud Private Edition
Description <p></p> <p>This CDS view provides the prerequisites for answering the following business questions:</p> <ul> <li><p>In which plant are the material serial numbers currently?</p></li> </ul>

Documentation

Data Sources (2)

SourceAliasJoin Type
I_Equipment e inner
I_EquipmentStockSegment ess from

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName ISERNUMSTOCKSEG view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
EndUserText.label Serial Number Stock Segment view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
ObjectModel.representativeKey SerialNumber view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
Analytics.dataCategory #DIMENSION view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view

Fields (27)

KeyFieldSource TableSource FieldDescription
KEY Material I_Equipment Material Material Number
KEY SerialNumber I_Equipment SerialNumber Serial Number
Equipment I_EquipmentStockSegment Equipment Equipment Number
Plant I_EquipmentStockSegment Plant Valuation Area
StorageLocation I_EquipmentStockSegment StorageLocation Storage Location
Customer I_EquipmentStockSegment Customer Special stock customer account number
Supplier I_EquipmentStockSegment Supplier Account number of the vendor
SalesOrder I_EquipmentStockSegment SalesOrder Sales Order Number
SalesOrderItem I_EquipmentStockSegment SalesOrderItem Item Number in Sales Order
InventorySpecialStockType I_EquipmentStockSegment InventorySpecialStockType Special Stock Indicator
WBSElementInternalID I_EquipmentStockSegment WBSElementInternalID Work Breakdown Structure Element (WBS Element)
Batch I_EquipmentStockSegment Batch Batch Number
InventoryStockType I_EquipmentStockSegment InventoryStockType Stock Type of Goods Movement (Primary Posting)
StockOwner I_EquipmentStockSegment StockOwner Owner of stock
_Material I_Equipment _Material
_Equipment I_EquipmentStockSegment _Equipment
_Plant I_EquipmentStockSegment _Plant
_StorageLocation I_EquipmentStockSegment _StorageLocation
_SalesOrder I_EquipmentStockSegment _SalesOrder
_SalesOrderItem I_EquipmentStockSegment _SalesOrderItem
_Customer I_EquipmentStockSegment _Customer
_CustomerCompanyByPlant I_EquipmentStockSegment _CustomerCompanyByPlant
_Supplier I_EquipmentStockSegment _Supplier
_SupplierCompanyByPlant I_EquipmentStockSegment _SupplierCompanyByPlant
_InventoryStockType I_EquipmentStockSegment _InventoryStockType
_InventorySpecialStockType I_EquipmentStockSegment _InventorySpecialStockType
_WBSElementByInternalKey I_EquipmentStockSegment _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 I_SerialNumberStockSegment.
-- 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: ISERNUMSTOCKSEG

CREATE VIEW I_SerialNumberStockSegment AS
SELECT
  e.Material AS Material,
  e.SerialNumber AS SerialNumber,
  ess.Equipment AS Equipment,
  ess.Plant AS Plant,
  ess.StorageLocation AS StorageLocation,
  ess.Customer AS Customer,
  ess.Supplier AS Supplier,
  ess.SalesOrder AS SalesOrder,
  ess.SalesOrderItem AS SalesOrderItem,
  ess.InventorySpecialStockType AS InventorySpecialStockType,
  ess.WBSElementInternalID AS WBSElementInternalID,
  ess.Batch AS Batch,
  ess.InventoryStockType AS InventoryStockType,
  ess.StockOwner AS StockOwner,
  e._Material AS _Material,
  ess._Equipment AS _Equipment,
  ess._Plant AS _Plant,
  ess._StorageLocation AS _StorageLocation,
  ess._SalesOrder AS _SalesOrder,
  ess._SalesOrderItem AS _SalesOrderItem,
  ess._Customer AS _Customer,
  ess._CustomerCompanyByPlant AS _CustomerCompanyByPlant,
  ess._Supplier AS _Supplier,
  ess._SupplierCompanyByPlant AS _SupplierCompanyByPlant,
  ess._InventoryStockType AS _InventoryStockType,
  ess._InventorySpecialStockType AS _InventorySpecialStockType,
  ess._WBSElementByInternalKey AS _WBSElementByInternalKey
FROM I_EquipmentStockSegment AS ess
INNER JOIN I_Equipment AS e ON /* join condition not captured in parsed metadata */
;

Learn More