I_BOERequestProcessStatusT

@AccessControl.authorizationCheck: #NOT_REQUIRED
@Analytics.dataExtraction.enabled: true
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.dataCategory: #TEXT
@ObjectModel.representativeKey: 'BillOfExchangeProcessStatus'
@ObjectModel.resultSet.sizeCategory: #XS
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.dataClass: #META
@ObjectModel.usageType.sizeCategory: #S

@Search.searchable: true
@VDM.lifecycle.contract.type: #PUBLIC_LOCAL_API
@VDM.viewType: #BASIC
@ObjectModel.modelingPattern: #LANGUAGE_DEPENDENT_TEXT
@ObjectModel.supportedCapabilities: [#LANGUAGE_DEPENDENT_TEXT,
                                     #CDS_MODELING_DATA_SOURCE,
                                     #EXTRACTION_DATA_SOURCE,
                                     #SQL_DATA_SOURCE,
                                     #SEARCHABLE_ENTITY]
/*+[hideWarning] { "IDS" : [ "KEY_CHECK", "CALCULATED_FIELD_CHECK" ] }*/
@EndUserText.label: 'BoE Request Process Status - Text'

@UI.presentationVariant: [{
  groupBy: [ 'StatusGroup' ],
  initialExpansionLevel: 1,
  sortOrder: [{ by: 'SortOrder', direction: #ASC }],
  visualizations: [{type: #AS_LINEITEM}]
}]
define view entity I_BOERequestProcessStatusT
  as select from dd07t
  association [0..1] to I_Language                         as _Language      on $projection.Language = _Language.Language
  association        to parent I_BOERequestProcessStatusVH as _ProcessStatus on $projection.BillOfExchangeProcessStatus = _ProcessStatus.BillOfExchangeProcessStatus

{
  key cast( substring( domvalue_l, 1, 2 ) as boe_request_process_status preserving type) as BillOfExchangeProcessStatus,
      @Semantics.language: true
      @ObjectModel.foreignKey.association: '_Language'
  key cast ( ddlanguage as spras preserving type)                                   as Language,
      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      @Search.ranking: #LOW
      @Semantics.text: true
      cast( ddtext as fis_val_text preserving type )                                as BOEProcessStatusDescription,
      @Analytics.hidden: true
      @Consumption.hidden: true
      dd07t.domvalue_l                                                              as DomainValue,

//      @EndUserText.label: 'Status Group'

//      @UI.lineItem: [{ position: 10 }]

//      @UI.selectionField: [{ position: 10 }]

//      case domvalue_l

//        when 'IE' then 'Data Extraction'

//        when 'EF' then 'Data Extraction'

//        when 'DN' then 'Data Readiness'

//        when 'RP' then 'Data Readiness'

//        when 'RW' then 'Data Readiness'

//        when 'PD' then 'Posting for Payment'

//        else 'Other'

//      end                                                                           as StatusGroup,

//

//      @UI.hidden: true

//      case domvalue_l

//        when 'IE' then 1

//        when 'EF' then 2

//        when 'DN' then 3

//        when 'RP' then 4

//        when 'RW' then 5

//        when 'PD' then 6

//        else 99

//      end                                                                           as SortOrder,


      _Language,
      _ProcessStatus
}
where
      dd07t.domname  = 'BOE_REQUEST_PROCESS_STATUS'
  and dd07t.as4local = 'A'
  and dd07t.as4vers  = '0000';