C_EmployeeValueHelp

@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.sqlViewName: 'CEMPLRESPVH'
@AbapCatalog.compiler.compareFilter: true
@VDM.viewType: #CONSUMPTION
@EndUserText.label: 'Employee Responsible'

@ObjectModel.representativeKey: 'PersonnelNumber'
@ObjectModel.dataCategory: #VALUE_HELP
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XL

@AccessControl.authorizationCheck: #MANDATORY
@AccessControl.personalData.blocking: #NOT_REQUIRED
@Search.searchable: true

define view C_EmployeeValueHelp 
  as select from I_PersonWorkAgreement_1 as Employment 
  association[0..1] to I_WorkforcePerson as Employee on Employee.Person = Employment.Person
{
      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      @Search.ranking: #HIGH
      key Employment.PersonWorkAgreement as PersonnelNumber,
      
      @UI.hidden: true
      Employee.Person, //Internal ID

      
      Employee.PersonExternalID as Employee,

      @Semantics.text
      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      Employee.FirstName,

      @Semantics.text
      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      Employee.LastName,

      @Semantics.text
      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      Employee.PersonFullName,
      
      // For Access control

      @Consumption.hidden: true
      @UI.hidden: true
      Employee.AuthorizationGroup,
      @Consumption.hidden: true
      @UI.hidden: true
      Employee.IsBusinessPurposeCompleted,
      @Consumption.hidden:true
      @UI.hidden:true
      Employee.DataControllerSet,
      @Consumption.hidden:true
      @UI.hidden:true
      Employee.DataController1,
      @Consumption.hidden:true
      @UI.hidden:true
      Employee.DataController2,
      @Consumption.hidden:true
      @UI.hidden:true
      Employee.DataController3,
      @Consumption.hidden:true
      @UI.hidden:true
      Employee.DataController4,
      @Consumption.hidden:true
      @UI.hidden:true
      Employee.DataController5,
      @Consumption.hidden:true
      @UI.hidden:true
      Employee.DataController6,
      @Consumption.hidden:true
      @UI.hidden:true
      Employee.DataController7,
      @Consumption.hidden:true
      @UI.hidden:true
      Employee.DataController8,
      @Consumption.hidden:true
      @UI.hidden:true
      Employee.DataController9,
      @Consumption.hidden:true
      @UI.hidden:true
      Employee.DataController10
}