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. It is exposed through 1 OData service (UI_INSPLOT_RSLTRECG). It is used in 1 Fiori application: Record Inspection Results (Version 2).

1 data source(s) Exposed by 1 service(s) Used in 1 Fiori app(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

OData Services (1)

ServiceBindingVersionContractRelease
UI_INSPLOT_RSLTRECG UI_INSPLOT_RSLTRECG V2 C1 NOT_RELEASED

Fiori Apps (1)

App IDApp NameTypeDescription
F1685A Record Inspection Results (Version 2) Transactional An application to record results for inspection characteristics.

Record Inspection Results (Version 2)

Business Role: Quality Technician

With the new Record Inspection Results app, you can record and process results for characteristics for one or more inspection lots effectively. You can also use this app to create defects manually for different categories, such as inspection lots, inspection operations, and characteristics.

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        
}

Learn More