I_DefectVH

DDL: I_DEFECTVH SQL: ID_VH Type: view COMPOSITE

Defect

I_DefectVH is a Composite CDS View that provides data about "Defect" in SAP S/4HANA. It reads from 1 data source (I_Defect) and exposes 12 fields with key field DefectInternalID. It has 1 association to related views.

1 data source(s) 12 fields

Data Sources (1)

SourceAliasJoin Type
I_Defect I_Defect from

Associations (1)

CardinalityTargetAliasCondition
[1..1] E_NotificationItem _Extension $projection.DefectInternalID = _Extension.Notification and _Extension.NotificationItem = '0000'

Annotations (17)

NameValueLevelField
AbapCatalog.sqlViewName ID_VH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.representativeKey DefectInternalID view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
ClientHandling.algorithm #SESSION_VARIABLE view
Search.searchable true view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Defect view
Consumption.ranked true view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY DefectInternalID DefectInternalID
Defect Defect
DefectText DefectText
DefectCode DefectCode
DefectCodeGroup DefectCodeGroup
Material Material
Plant Plant
InspectionLot InspectionLot
_InspectionLot _InspectionLot
DefectCategory DefectCategory
MainWorkCenter MainWorkCenter
MainWorkCenterPlant MainWorkCenterPlant 
  @AbapCatalog.sqlViewName: 'ID_VH'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@VDM.viewType: #COMPOSITE
@VDM.lifecycle.contract.type: #PUBLIC_LOCAL_API

@ObjectModel.dataCategory: #VALUE_HELP
@ObjectModel.supportedCapabilities: [#VALUE_HELP_PROVIDER]
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.representativeKey: 'DefectInternalID'
@AccessControl: { authorizationCheck: #CHECK }
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED
@ClientHandling.algorithm: #SESSION_VARIABLE

@Search.searchable: true

@Metadata.ignorePropagatedAnnotations: true

@EndUserText.label: 'Defect'
@Consumption.ranked: true


define view I_DefectVH as select from I_Defect 

  association [1..1] to E_NotificationItem as _Extension on  $projection.DefectInternalID = _Extension.Notification
                                                         and _Extension.NotificationItem = '0000'
                                                         
{
  @Search.defaultSearchElement: true
  @Search.fuzzinessThreshold: 0.7
  //set due to hidden field and calculated Defect field

  @Search.ranking: #MEDIUM 
  @UI.hidden: true
  key DefectInternalID,
  
  Defect,
   
  @Search.defaultSearchElement: true
  @Search.ranking: #HIGH
  @Search.fuzzinessThreshold: 0.7
  DefectText,
  
  @Search.defaultSearchElement: true
  @Search.ranking: #LOW
  @Search.fuzzinessThreshold: 0.7
  DefectCode,

  @Search.defaultSearchElement: true
  @Search.ranking: #LOW
  @Search.fuzzinessThreshold: 0.7
  DefectCodeGroup,
  
  @Search.defaultSearchElement: true
  @Search.ranking: #LOW
  @Search.fuzzinessThreshold: 0.7
  Material,
  
  @Search.defaultSearchElement: true
  @Search.ranking: #LOW
  @Search.fuzzinessThreshold: 0.7
  Plant,
  
  @Search.defaultSearchElement: true
  @Search.ranking: #LOW
  @Search.fuzzinessThreshold: 0.7
  InspectionLot,
  
  
  // ASSOCIATIONS

  /* Used for authorization check */
  @Consumption.hidden: true
  _InspectionLot,
  @Consumption.hidden: true
  DefectCategory,
  @Consumption.hidden: true
  MainWorkCenter,
  @Consumption.hidden: true
  MainWorkCenterPlant
  
}

Learn More