I_ConsCharAttributeText

@AbapCatalog.sqlViewName: 'ICNSCHARATTRT'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations: true

@ObjectModel.usageType: {
  dataClass: #MASTER,
  serviceQuality: #C,
  sizeCategory: #L
}
@ObjectModel.dataCategory: #TEXT

@VDM.viewType: #BASIC
@EndUserText.label: 'Charcteristics Attribute Text'

@Search.searchable: true

define view I_ConsCharAttributeText
  as select from I_CnsldtnAllCharsAttribute

    inner join   dd04t as DD on I_CnsldtnAllCharsAttribute.AttributeDataElement = DD.rollname

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

  association [0..1] to I_CnsldtnAllCharsAttribute as _CnsldtnAllCharsAttribute on  $projection.ConsolidationAttributeName = _CnsldtnAllCharsAttribute.ConsolidationAttributeName
                                                                                and $projection.ConsolidationMDCharcName   = _CnsldtnAllCharsAttribute.ConsolidationMDCharcName

  association [0..*] to I_CnsldtnAllChars          as _CnsldtnAllChars          on  $projection.ConsolidationMDCharcName = _CnsldtnAllChars.AdditionalCharcFieldName
{

       @Search: {defaultSearchElement: true, fuzzinessThreshold: 0.8, ranking: #HIGH}
  key  ConsolidationAttributeName,

       @Search: {defaultSearchElement: true, fuzzinessThreshold: 0.8, ranking: #HIGH}
  key  ConsolidationMDCharcName,

       @Semantics.language
  key  DD.ddlanguage as Language,

       @Consumption.hidden: true
       rollname      as AttributeDataElement,

       //@Search: {defaultSearchElement: true, fuzzinessThreshold: 0.8, ranking: #HIGH}

       @Semantics.text
       ddtext        as ConsolidationAttributeFldText,

       @Semantics.text
       scrtext_m     as ConsolidationAttributeMedText,

       @Semantics.text
       scrtext_l     as ConsolidationAttributeLongText,


       _Language,
       _CnsldtnAllCharsAttribute,
       _CnsldtnAllChars
}
where
  DD.as4local = 'A'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CNSLDTNALLCHARSATTRIBUTE",
"DD04T"
],
"ASSOCIATED":
[
"I_CNSLDTNALLCHARS",
"I_CNSLDTNALLCHARSATTRIBUTE",
"I_LANGUAGE"
],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/