C_InspLotUnplndInspSpecVH

@AbapCatalog.sqlViewName: 'CUNPLDINSPSPECVH'
@AbapCatalog.preserveKey: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Insp Spec VH for Unplanned Char'
@VDM.viewType: #CONSUMPTION

@Search.searchable: true
@ObjectModel: {
    usageType: {
        dataClass: #MASTER,
        sizeCategory: #M, //expected number of rows < 100.000

        serviceQuality: #C // includes A,B as well

    },
    dataCategory: #VALUE_HELP
}
//Don't know what it does, so commenting it out for now

//@ObjectModel.representativeKey: 'InspectionSpecificationVersion'

define view C_InspLotUnplndInspSpecVH
  as select distinct from I_InspSpecVersReldVH
{
      @Search: { defaultSearchElement: true, fuzzinessThreshold: 0.8 }
      @UI.selectionField: [{position: 10 }]
  key InspectionSpecification,
      @ObjectModel.foreignKey.association: '_InspSpecificationPlant'
      @Search: { defaultSearchElement: true, fuzzinessThreshold: 0.8 }
      @UI.selectionField: [{position: 20 }]
  key InspectionSpecificationPlant,
      @UI.selectionField: [{position: 30 }]
  key InspectionSpecificationVersion,

      @UI.selectionField: [{position: 40 }]
      ValidityStartDate,
      @Search: { defaultSearchElement: true, fuzzinessThreshold: 0.8 }
      @UI.selectionField: [{position: 50 }]
      InspectionSpecificationSrchTxt,
      @UI.selectionField: [{position: 60 }]
      InspectionSpecificationStatus,
      @Search: { defaultSearchElement: true, fuzzinessThreshold: 0.8 }
      @UI.selectionField: [{position: 70 }]
      InspSpecTransferType,
      @UI.selectionField: [{position: 80 }]
      InspSpecCharacteristicType,
      @UI.selectionField: [{position: 90 }]
      QltyMstrDataAuthorizationGroup,
//    C5314719 - Performance change  

      @Consumption.filter.hidden: true
      @UI.hidden: true
      InspSpecIsSamplingProcedRqd,   
//    End changes - C5314719


      /* Associations */
      @Consumption.filter.hidden: true
      _InspSpecificationPlant,
      @Consumption.filter.hidden: true
      _InspectionSpecification,
      //      @Consumption.filter.hidden: true

      //      I_InspSpecVersReldVH._Text as _InspectionSpecificationText,

      @Consumption.filter.hidden: true
      _InspSpecStatus,
      @Consumption.filter.hidden: true
      _InspSpecTransferType,
      @Consumption.filter.hidden: true
      _InspSpecCharcType,
      @Consumption.filter.hidden: true
      _QltyMstrDataAuthznGrp
//      _InspectionMethod.InspMethIsAssgmtToSpecInactive,

//      @Consumption.filter.hidden: true

//      @UI.hidden: true

//      cast(case

//      when _InspectionMethod.InspectionMethod  is not null then 'X'

//      else '' end as boolean preserving type) as InspMethIsExisting


}
where
      InspectionSpecificationStatus =  '2'
  and InspSpecTransferType          <> ' '