I_DefectCodeStdVH

DDL: I_DEFECTCODESTDVH SQL: IDC__VH Type: view COMPOSITE

Defect Code

I_DefectCodeStdVH is a Composite CDS View that provides data about "Defect Code" in SAP S/4HANA. It reads from 1 data source (I_DefectCode) and exposes 7 fields with key fields DefectCodeGroup, DefectCode.

1 data source(s) 7 fields

Data Sources (1)

SourceAliasJoin Type
I_DefectCode I_DefectCode from

Annotations (16)

NameValueLevelField
AbapCatalog.sqlViewName IDC__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.representativeKey DefectCode view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #CUSTOMIZING view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Defect Code view
Search.searchable true view
Consumption.ranked true view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY DefectCodeGroup DefectCodeGroup
KEY DefectCode DefectCode
DefectCodeText
CodeIsInactive CodeIsInactive
DefectCodeGroupAndCode
_Text _Text
_DefectCodeGroup _DefectCodeGroup 
//GENERATED:003:GFBfhyK17jU{x0YpWBss2W

@AbapCatalog.sqlViewName: 'IDC__VH'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true

@VDM: { 
    viewType: #COMPOSITE,
    lifecycle.contract.type: #PUBLIC_LOCAL_API
}
@ObjectModel.supportedCapabilities: [ #VALUE_HELP_PROVIDER ]
@ObjectModel.dataCategory: #VALUE_HELP
@ObjectModel.representativeKey: 'DefectCode'

@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #M
@ObjectModel.usageType.dataClass: #CUSTOMIZING

@AccessControl.authorizationCheck: #CHECK
@AccessControl.privilegedAssociations: ['_Text']

@ClientHandling.algorithm: #SESSION_VARIABLE

@Metadata.ignorePropagatedAnnotations: true

@EndUserText.label: 'Defect Code'

@Search.searchable: true
@Consumption.ranked: true
define view I_DefectCodeStdVH as select from I_DefectCode {
  @ObjectModel.foreignKey.association: '_DefectCodeGroup'
  @Search: {
    defaultSearchElement: true,
    fuzzinessThreshold: 0.8,
    ranking: #LOW
  }
  key DefectCodeGroup,
  
  @ObjectModel.text.element: ['DefectCodeText']
  @Search: {
    defaultSearchElement: true,
    fuzzinessThreshold: 0.8,
    ranking: #HIGH
  }
  key DefectCode,
  
  @Semantics.text: true
  @Search: {
    defaultSearchElement: true,
    fuzzinessThreshold: 0.8,
    ranking: #LOW
  }
  _Text[ 1:Language = $session.system_language ].DefectCodeText,
  
  @Consumption.hidden: true
  CodeIsInactive,
  
  @ObjectModel.text.element: ['DefectCodeText']
  cast( concat_with_space( DefectCodeGroup, DefectCode, 1) as qdefect_code_group_and_code preserving type ) as DefectCodeGroupAndCode,
  
  _Text,

  @Consumption.hidden: true
  _DefectCodeGroup
}

Learn More