I_SerialNumberValueHelp

DDL: I_SERIALNUMBERVALUEHELP Type: view_entity BASIC Package: LO_SN_DB
23 Fields 1 Data Sources 1 Associations

Selection Help for Serial Numbers

I_SerialNumberValueHelp is a Basic CDS View that provides data about "Selection Help for Serial Numbers" in SAP S/4HANA. It reads from 1 data source (I_Equipment) and exposes 23 fields with key fields SerialNumber, Material, Equipment. It has 1 association to related views. Part of development package LO_SN_DB.

Data Sources (1)

SourceAliasJoin Type
I_Equipment I_Equipment from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_EquipmentStockSegment _EquiStockSeg $projection.Equipment = _EquiStockSeg.Equipment

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Selection Help for Serial Numbers view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #BASIC view
ObjectModel.representativeKey SerialNumber view

Fields (23)

KeyFieldSource TableSource FieldDescription
KEY SerialNumber SerialNumber Serial Number
KEY Material Material Vehicle Model
KEY Equipment Equipment Equipment check
EquipmentHasStockInformation EquipmentHasStockInformation
Batch _EquiStockSeg Batch Lot No.
ManufacturerSerialNumber ManufacturerSerialNumber Mnf.serial no.
AssetManufacturerName AssetManufacturerName Manufacturer
ManufacturerPartTypeName ManufacturerPartTypeName Model number
ManufacturerCountry ManufacturerCountry Mnf. Cntry/Regn
ManufacturerPartNmbr
Plant _EquiStockSeg Plant Valuation Area
StorageLocation _EquiStockSeg StorageLocation StorageLocation
Customer _EquiStockSeg Customer Sold-to Party
Supplier _EquiStockSeg Supplier Supplier
SalesOrder _EquiStockSeg SalesOrder SD Document
SalesOrderItem _EquiStockSeg SalesOrderItem Sales Order Item
InventorySpecialStockType _EquiStockSeg InventorySpecialStockType Special Stock Type
WBSElementInternalID
WBSElement
InventoryStockType _EquiStockSeg InventoryStockType Stock Type
StockOwner _EquiStockSeg StockOwner Owner of stock
_Customer _EquiStockSeg _Customer
_Supplier _EquiStockSeg _Supplier

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_SerialNumberValueHelp.
-- 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_SerialNumberValueHelp AS
SELECT
  SerialNumber,
  Material,
  Equipment,
  EquipmentHasStockInformation,
  _EquiStockSeg.Batch AS Batch,
  ManufacturerSerialNumber,
  AssetManufacturerName,
  ManufacturerPartTypeName,
  ManufacturerCountry,
  cast( _CurrentTimeSegment.ManufacturerPartNmbr as abap.char( 40 ) ) AS ManufacturerPartNmbr,
  _EquiStockSeg.Plant AS Plant,
  _EquiStockSeg.StorageLocation AS StorageLocation,
  _EquiStockSeg.Customer AS Customer,
  _EquiStockSeg.Supplier AS Supplier,
  _EquiStockSeg.SalesOrder AS SalesOrder,
  _EquiStockSeg.SalesOrderItem AS SalesOrderItem,
  _EquiStockSeg.InventorySpecialStockType AS InventorySpecialStockType,
  cast( _EquiStockSeg.WBSElementInternalID as nsdm_wbselement_internal_id preserving type ) AS WBSElementInternalID,
  _EquiStockSeg._WBSElementByInternalKey.WBSElementExternalID AS WBSElement,
  _EquiStockSeg.InventoryStockType AS InventoryStockType,
  _EquiStockSeg.StockOwner AS StockOwner,
  _EquiStockSeg._Customer AS _Customer,
  _EquiStockSeg._Supplier AS _Supplier
FROM I_Equipment
LEFT OUTER JOIN I_EquipmentStockSegment AS _EquiStockSeg ON Equipment = _EquiStockSeg.Equipment  -- association [0..1]
;

Learn More