C_DefectRecordCodeVH

DDL: C_DEFECTRECORDCODEVH SQL: CDEFRECCDVH Type: view CONSUMPTION

Defect Code Value Help

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

1 data source(s) 6 fields

Data Sources (1)

SourceAliasJoin Type
I_DefectCodeStdVH I_DefectCodeStdVH from

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName CDEFRECCDVH view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION 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
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Defect Code Value Help view
Search.searchable true view
Consumption.ranked true view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY DefectCode DefectCode
KEY DefectCodeGroup DefectCodeGroup
DefectCodeText DefectCodeText
DefectInternalID
_Text _Text
_DefectCodeGroup _DefectCodeGroup 

@AbapCatalog.sqlViewName: 'CDEFRECCDVH'
@AbapCatalog.compiler.compareFilter: true
@ClientHandling.algorithm: #SESSION_VARIABLE

@VDM.viewType: #CONSUMPTION

@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']
@Metadata.ignorePropagatedAnnotations: true
@EndUserText.label: 'Defect Code Value Help'
@Search.searchable: true
@Consumption.ranked: true
define view C_DefectRecordCodeVH as select from I_DefectCodeStdVH 


{
    @ObjectModel.text.element: ['DefectCodeText']
    @Search: { defaultSearchElement: true, fuzzinessThreshold: 0.8, ranking: #HIGH }
    key DefectCode,
    
    @Search: { defaultSearchElement: true, fuzzinessThreshold: 0.8, ranking: #HIGH }
    @Consumption.valueHelpDefinition: [{ entity: { name: 'I_DefectCodeGroupStdVH', element: 'DefectCodeGroup' } }]
    key DefectCodeGroup,
    
    @Semantics.text: true
    @Search: { defaultSearchElement: true, fuzzinessThreshold: 0.8, ranking: #LOW }
    DefectCodeText,
    
    @Semantics.booleanIndicator: true
    case when CodeIsInactive = '' and _DefectCodeGroup.CodeGroupStatus = '2'
           then cast( 'X' as vdm_qcodeisassignable preserving type ) 
         else cast( ' ' as vdm_qcodeisassignable preserving type )
    end                                                                as CodeIsAssignable, 
    
    @Consumption:{
      filter.hidden: true,
      hidden: false
    }
    @UI.HiddenFilter: true
    @UI.lineItem.hidden: true
    cast( '            ' as qdeefectinternalid preserving type ) as DefectInternalID,
    
    _Text,
    @Consumption.hidden: true
    _DefectCodeGroup        
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_DEFECTCODEGROUP",
"I_DEFECTCODESTDVH"
],
"ASSOCIATED":
[
"I_DEFECTCODEGROUP",
"I_DEFECTCODETEXT"
],
"BASE":
[
"I_DEFECTCODESTDVH"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More