I_ReservationCreationCode

@EndUserText.label: 'Reservation Creation Code'
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel: {
                usageType: {
                             sizeCategory: #S,
                             serviceQuality: #A,
                             dataClass:#CUSTOMIZING
                           },
                resultSet.sizeCategory: #XS,
                representativeKey: 'ReservationCreationCode'
              }
@VDM: {
        viewType: #BASIC
      }
@Metadata: {
             ignorePropagatedAnnotations: true
           }
@Consumption.ranked: true
@Search.searchable: true
@ObjectModel.dataCategory: #VALUE_HELP
@ObjectModel.supportedCapabilities: [#VALUE_HELP_PROVIDER]
/*+[hideWarning] { "IDS" : [ "KEY_CHECK", "CALCULATED_FIELD_CHECK" ]  } */
define view entity I_ReservationCreationCode
  as select from dd07l
  association [0..*] to I_ResvnCreationCodeText as _ResvnCreationCodeText on $projection.ReservationCreationCode = _ResvnCreationCodeText.ReservationCreationCode
{
      @ObjectModel.text.association: '_ResvnCreationCodeText'
      @Search.defaultSearchElement: true
      @Search.ranking: #HIGH
      @Search.fuzzinessThreshold: 0.8
  key cast(SUBSTRING(dd07l.domvalue_l, 1, 4) as imrs_creation_code preserving type) as ReservationCreationCode,

      //Associations

      _ResvnCreationCodeText

}
where
  (
    dd07l.domname  = 'IMRS_CREATION_CODE'
  )
  and(
    dd07l.as4local = 'A'
  );