I_MaterialStockReportStepT

@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Material Strock Report Step - Text'
@ObjectModel.usageType.serviceQuality:#C
@ObjectModel.usageType.sizeCategory:#S
@ObjectModel.usageType.dataClass: #MASTER
@Search.searchable
@VDM:{
  viewType: #BASIC,
  private:false
}
@ObjectModel.dataCategory:#TEXT  
define view entity I_MaterialStockReportStepT 
as select from dd07t 
 association [0..1] to I_MaterialStockReportStep as _MatDocItmSetStep on $projection.MaterialStockReportStep = _MatDocItmSetStep.MaterialStockReportStep
 association [0..1] to I_Language          as _Language        on $projection.Language = _Language.Language

{
      @ObjectModel.text.element: ['MaterialStockReportStep']
  key  cast(substring(dd07t.domvalue_l, 1, 2) as matdocitmsetstep preserving type) as MaterialStockReportStep, //TODO: change to new domain, data element

       @ObjectModel.foreignKey.association: '_Language'
       @Semantics.language:true
  key  cast( ddlanguage as spras )                                                   as Language,     
      @Semantics.text: true
      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      @Search.ranking: #LOW
       cast ( substring ( ddtext, 1, 60 ) as val_text )                              as MaterialStockReportStepText,
       _MatDocItmSetStep,
       _Language
  
}
where
  (
    dd07t.domname  = 'MATDOCITMSETSTEP'
  )
  and(
    dd07t.as4local = 'A'
  );