I_SerialNumberValueHelp

DDL: I_SERIALNUMBERVALUEHELP Type: view_entity BASIC

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.

1 data source(s) 23 fields

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
KEY Material Material
KEY Equipment Equipment
EquipmentHasStockInformation EquipmentHasStockInformation
Batch Batch
ManufacturerSerialNumber ManufacturerSerialNumber
AssetManufacturerName AssetManufacturerName
ManufacturerPartTypeName ManufacturerPartTypeName
ManufacturerCountry ManufacturerCountry
ManufacturerPartNmbr
Plant _EquiStockSeg Plant
StorageLocation _EquiStockSeg StorageLocation
Customer _EquiStockSeg Customer
Supplier _EquiStockSeg Supplier
SalesOrder _EquiStockSeg SalesOrder
SalesOrderItem _EquiStockSeg SalesOrderItem
InventorySpecialStockType _EquiStockSeg InventorySpecialStockType
WBSElementInternalID
WBSElement
InventoryStockType _EquiStockSeg InventoryStockType
StockOwner _EquiStockSeg StockOwner
_Customer _EquiStockSeg _Customer
_Supplier _EquiStockSeg _Supplier 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Selection Help for Serial Numbers'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.dataCategory:#VALUE_HELP
@ObjectModel.usageType:{
  serviceQuality: #X,
  sizeCategory: #S,
  dataClass: #MIXED
}
@VDM.viewType: #BASIC
@ObjectModel.representativeKey: 'SerialNumber'
define view entity I_SerialNumberValueHelp
  as select from I_Equipment
  association [0..1] to I_EquipmentStockSegment as _EquiStockSeg on $projection.Equipment = _EquiStockSeg.Equipment
{
  key   SerialNumber,
  key   Material,
  key   Equipment,
        EquipmentHasStockInformation,
        Batch,
        ManufacturerSerialNumber,
        AssetManufacturerName,
        ManufacturerPartTypeName,
        ManufacturerCountry,
        cast( _CurrentTimeSegment.ManufacturerPartNmbr as abap.char( 40 ) )                       as ManufacturerPartNmbr,
        _EquiStockSeg.Plant,
        _EquiStockSeg.StorageLocation,
        _EquiStockSeg.Customer,
        _EquiStockSeg.Supplier,
        _EquiStockSeg.SalesOrder,
        _EquiStockSeg.SalesOrderItem,
        _EquiStockSeg.InventorySpecialStockType,
        cast( _EquiStockSeg.WBSElementInternalID as nsdm_wbselement_internal_id preserving type ) as WBSElementInternalID,
        _EquiStockSeg._WBSElementByInternalKey.WBSElementExternalID                               as WBSElement,
        _EquiStockSeg.InventoryStockType,
        _EquiStockSeg.StockOwner,

        _EquiStockSeg._Customer,
        _EquiStockSeg._Supplier
}
where
      Material     <> ''
  and SerialNumber <> ''

Learn More