C_ChmlCmplncMktCountryVH

@EndUserText.label: 'Country / Region Value Help with Filter'

@AbapCatalog:
{
  sqlViewName: 'CCCMKTCNTRYVH',
  compiler.compareFilter: true,
  preserveKey: true
}

--Access Control: Authorization checks
@AccessControl:
{
  authorizationCheck: #CHECK
}

--Client Handling of the view
@ClientHandling.algorithm: #SESSION_VARIABLE

--VDM view type
@VDM.viewType: #CONSUMPTION

@ObjectModel:
{
  dataCategory: #VALUE_HELP,
  semanticKey:  [ 'Country' ],
  representativeKey: 'ChmlCmplncInfoUUID',
  usageType:
  {
    dataClass: #MIXED,
    sizeCategory: #S,
    serviceQuality: #C
  }
}

--Header information
@UI:
{
  headerInfo:
  {
    typeName: 'Country/Region',
    typeNamePlural: 'Countries/Regions'
  }
}

--Search
@Search.searchable : true
@Consumption.ranked: true


define view C_ChmlCmplncMktCountryVH
  with parameters
    P_ChmlCmplncInfoUUID : sysuuid_x
  --Select data from customizing table 'Country
  as select from    I_Country                as Country

  --Join data of draft CCI to get active CCI UUID
    join            I_ChmlCmplncInfoDraft    as ChmlCmplncInfoDraft on ChmlCmplncInfoDraft.ChmlCmplncInfoUUID = $parameters.P_ChmlCmplncInfoUUID


  --Join data for draft market requests to exclude the assigned countries
    left outer join I_ChmlCmplncMktCvrgDraft as Coverage            on  Country.Country             = Coverage.Country
                                                                    and Coverage.ChmlCmplncInfoUUID = $parameters.P_ChmlCmplncInfoUUID

  -- Association to I_ChmlCmplncInfo needed for DCL
  association [1..1] to I_ChmlCmplncInfo as _ChmlCmplncInfo on _ChmlCmplncInfo.ChmlCmplncInfoUUID = $projection.ActiveChmlCmplncInfoUUID

{

      -- Chemical Compliance UUID
      @UI.hidden: true
  key $parameters.P_ChmlCmplncInfoUUID                                    as ChmlCmplncInfoUUID,

      --Country
      @UI:
      {
        lineItem.position: 10,
        textArrangement: #TEXT_ONLY
      }
      @ObjectModel.text.element:  [ 'CountryName' ]
      
      @Semantics.text: true
      @Search:
      {
         defaultSearchElement: true,
         fuzzinessThreshold: 0.8,
         ranking: #HIGH
      }

  key Country.Country,

      --Active CCI UUID
      @UI.hidden: true
      ChmlCmplncInfoDraft.ActiveChmlCmplncInfoUUID,

      --Country name
      @UI.hidden: true
      @Semantics.text: true
      
      @Search:
      {
         defaultSearchElement: true,
         fuzzinessThreshold: 0.8,
         ranking: #HIGH
      }
      
      Country._Text[ 1: Language = $session.system_language ].CountryName as CountryName,

      /* Associations */
      _ChmlCmplncInfo

}
where
  --Select countries which are not assigned in market requests in the current draft table
  Coverage.ChmlCmplncInfoUUID is null