I_AllocationContextTypeText

@AbapCatalog.sqlViewName: 'IALLOCCONTEXTTXT'
@AbapCatalog.compiler.compareFilter: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.representativeKey: 'AllocationType'
@ObjectModel.dataCategory: #TEXT
@ObjectModel.usageType.dataClass: #CUSTOMIZING
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #L
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #BASIC
@EndUserText.label: 'Allocation Context Text'
@ObjectModel.resultSet.sizeCategory: #XS
define view I_AllocationContextTypeText
  as select from dd07t

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

{
  //key cast( substring( domvalue_l, 1, 30) as ipknz ) as DatabaseTable,

  key cast( substring( domvalue_l, 1, 30) as fco_allocation_context ) as AllocationType,

      @ObjectModel.foreignKey.association: '_Language'
      @Semantics.language: true
  key cast( ddlanguage as spras )                   as Language,

      @Semantics.text: true
      cast(ddtext as fco_tab_text)                  as AllocationContextTypeText,
      _Language

}
where
      domname  = 'FCO_ALLOCATION_CONTEXT'
  and as4local = 'A';