I_DEFECTCODESTDVH

CDS View

Defect Code

I_DEFECTCODESTDVH is a CDS View in S/4HANA. Defect Code. 2 CDS views read from this table.

Used by 2 CDS view(s)

CDS Views using this table (2)

ViewTypeJoinVDMDescription
C_DefectRecordCodeVH view from CONSUMPTION Defect Code Value Help
C_MfgDefectCodeVH view from CONSUMPTION Defect Code 
//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
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_DEFECTCODE",
"I_DEFECTCODETEXT"
],
"ASSOCIATED":
[
"I_DEFECTCODEGROUP",
"I_DEFECTCODETEXT"
],
"BASE":
[
"I_DEFECTCODE"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More