C_DFS_EquipSerialNumberVH

DDL: C_DFS_EQUIPSERIALNUMBERVH SQL: CEQUIPSERLVH Type: view CONSUMPTION

Equipment By Serial Number Seach Help

C_DFS_EquipSerialNumberVH is a Consumption CDS View that provides data about "Equipment By Serial Number Seach Help" in SAP S/4HANA. It reads from 1 data source (I_Equipment) and exposes 14 fields with key field Equipment.

1 data source(s) 14 fields

Data Sources (1)

SourceAliasJoin Type
I_Equipment _Equipment from

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName CEQUIPSERLVH view
EndUserText.label Equipment By Serial Number Seach Help view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #CONSUMPTION view
ObjectModel.dataCategory #VALUE_HELP view
AbapCatalog.preserveKey true view
Search.searchable true view
Consumption.ranked true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MASTER view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.representativeKey Equipment view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY Equipment Equipment
EquipmentName
Material I_Equipment Material
SerialNumber I_Equipment SerialNumber
UniqueItemIdentifier I_Equipment UniqueItemIdentifier
EquipmentCategory I_Equipment EquipmentCategory
Plant _SerialNumberStockSegment Plant
StorageLocation _SerialNumberStockSegment StorageLocation
Batch I_Equipment Batch
ManufacturerSerialNumber I_Equipment ManufacturerSerialNumber
ManufacturerPartTypeName I_Equipment ManufacturerPartTypeName
TechnicalObjectType I_Equipment TechnicalObjectType
_SerialNumberStockSegment _SerialNumberStockSegment
_EquipmentText _EquipmentText 
@AbapCatalog.sqlViewName: 'CEQUIPSERLVH'
@EndUserText.label: 'Equipment By Serial Number Seach Help'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #MANDATORY
@VDM.viewType: #CONSUMPTION
@ObjectModel.dataCategory:#VALUE_HELP
@AbapCatalog.preserveKey:true
@Search.searchable: true
@Consumption.ranked: true 
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #MASTER
@ClientHandling.algorithm: #SESSION_VARIABLE 
@ObjectModel.representativeKey : 'Equipment'
define view C_DFS_EquipSerialNumberVH 
as select from I_Equipment as _Equipment
{
  @Search.ranking: #LOW 
  @Search.defaultSearchElement: true
  @Search.fuzzinessThreshold: 0.9
  key Equipment,
  _EquipmentText[ 1:Language = $session.system_language ].EquipmentName,
  @Search.ranking: #LOW
  @Search.defaultSearchElement: true
  @Search.fuzzinessThreshold: 0.9
  _Equipment.Material,
  @Search.ranking: #HIGH 
  @Search.defaultSearchElement: true
  @Search.fuzzinessThreshold: 0.9
  _Equipment.SerialNumber,
  @Search.ranking: #LOW
  @Search.defaultSearchElement: true
  @Search.fuzzinessThreshold: 0.9
  _Equipment.UniqueItemIdentifier,
  @Search.ranking: #LOW
  @Search.defaultSearchElement: true
  @Search.fuzzinessThreshold: 0.9
  _Equipment.EquipmentCategory,
  @Search.defaultSearchElement: true
  @Search.fuzzinessThreshold: 0.9
  _SerialNumberStockSegment.Plant,
  @Search.defaultSearchElement: true
  @Search.fuzzinessThreshold: 0.9
  _SerialNumberStockSegment.StorageLocation,
  @Search.defaultSearchElement: true
  @Search.fuzzinessThreshold: 0.9
  _Equipment.Batch,  
  _Equipment.ManufacturerSerialNumber,
  _Equipment.ManufacturerPartTypeName,
  _Equipment.TechnicalObjectType,
  
  _SerialNumberStockSegment,
  _EquipmentText
}
where _Equipment.SerialNumber is not initial
      and _Equipment.HasEquipmentData = 'X'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_EQUIPMENT",
"I_EQUIPMENTTEXT",
"I_SERIALNUMBERSTOCKSEGMENT"
],
"ASSOCIATED":
[
"I_EQUIPMENTTEXT",
"I_SERIALNUMBERSTOCKSEGMENT"
],
"BASE":
[
"I_EQUIPMENT"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More