C_FormOfAddrPersnVHTemp

@AbapCatalog.sqlViewName: 'CFOAPERSNVH'
@ClientDependent: true
@AbapCatalog.compiler.compareFilter: true
//@Analytics : {dataCategory: #DIMENSION, dataExtraction.enabled : true}

@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #CONSUMPTION
@ObjectModel.representativeKey: 'FormOfAddress'
//@EndUserText.label: 'Form of Address Value Help'

@Search.searchable: true

@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #M
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.dataCategory: #VALUE_HELP
@Consumption.ranked: true

define view C_FormOfAddrPersnVHTemp
  as select from tsad3

  association [0..*] to C_FormOfAddressTextVHTemp as _Text on $projection.FormOfAddress = _Text.FormOfAddress

{
      @ObjectModel.text.association: '_Text'
      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      @Search.ranking: #HIGH
      @Consumption.filter.hidden: true
  key tsad3.title                                                                  as FormOfAddress,
      ////      @Search.defaultSearchElement: true

      ////      @EndUserText.label: 'Category'

      ////      case

      ////              when tsad3.person = 'X' then '1'

      ////              when tsad3.organizatn = 'X' then '2'

      ////              else '3'

      ////       end                                                                         as BusinessPartnerCategory,

      //                ,


      /*     @Consumption.filter.hidden: true
           @UI.hidden: true
            cast (
            case
            when tsad3.title = '0001'
            then '2'
            when tsad3.title = '0002'
            then '1'
            else ' '
            end  as char1 )                                                              as GenderCodeName, */

      _Text
}
where
  tsad3.person = 'X'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"TSAD3"
],
"ASSOCIATED":
[
"C_FORMOFADDRESSTEXTVHTEMP"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/