I_PricingRelevanceText

@AbapCatalog.sqlViewName: 'IPRCGRLVNCETXT'
@VDM.viewType: #BASIC
@Search.searchable: true
@AbapCatalog.preserveKey:true
@ObjectModel.dataCategory: #TEXT
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #META
@AbapCatalog.compiler.compareFilter:true
@ObjectModel.usageType.serviceQuality: #C
@Metadata.ignorePropagatedAnnotations:true
@EndUserText.label: 'Pricing indicator Text'
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.representativeKey: 'PricingRelevance'

define view I_PricingRelevanceText
  as select from dd07t
  association [0..1] to I_PricingRelevance as _PricingRelevance on $projection.PricingRelevance = _PricingRelevance.PricingRelevance
  association [0..1] to I_Language         as _Language         on $projection.Language = _Language.Language
{
      @Semantics.language:true
      @ObjectModel.foreignKey.association: '_Language'
  key cast( ddlanguage as spras preserving type)                      as Language,

      @ObjectModel.foreignKey.association: '_PricingRelevance'
  key cast ( substring( domvalue_l, 1, 1 ) as prsfd preserving type ) as PricingRelevance,

      @Semantics.text: true
      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.9
      cast( ddtext as prsfd_text preserving type )                    as PricingRelevanceName,

      //Association

      _PricingRelevance,
      _Language
}
where
      domname  = 'PRSFD'
  and as4local = 'A'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"DD07T"
],
"ASSOCIATED":
[
"I_LANGUAGE",
"I_PRICINGRELEVANCE"
],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/