I_LogisticalProductCatText

@AbapCatalog.sqlViewName: 'ILOGPRODCATTXTV'
@EndUserText.label: 'Get long text for Logistical Product Category'
@Search: {
  searchable: true
}
@VDM.viewType: #BASIC
@ObjectModel.dataCategory: #TEXT
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.representativeKey: 'LogisticalProductCategory'

@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory : #S
@ObjectModel.usageType.dataClass: #MASTER
@ClientHandling.algorithm: #SESSION_VARIABLE

define view I_LogisticalProductCatText
  as select from dd07t

  association [0..1] to I_Language as _Language on $projection.Language = _Language.Language

  //  association [0..1] to I_ProductCategory as _ProductCategory on $projection.ProductCategory = _ProductCategory.ProductCategory


{
      @Semantics.language
  key cast( ddlanguage as spras preserving type )                                   as Language,

      //      @ObjectModel.foreignKey.association: '_ProductCategory'



  key cast ( domvalue_l as logisticalproductcategory )                                        as LogisticalProductCategory,
      

      @Semantics.text
      @Search: {
      defaultSearchElement: true,
      fuzzinessThreshold: 0.8
      }
      //      cast ( substring ( ddtext, 1, 60 ) as val_text )                              as Name,

      cast ( ddtext as val_text )                                                   as LogisticalProductCategoryText,


      _Language



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