@AbapCatalog.sqlViewName: 'ZCDS_PRM'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'CDS with params'
define view zcds_params
  with parameters
    p_country_origin : char2
  as select from ztbl1 as t1
    inner join   ztbl2 as t2 on t1.id = t2.id
{
  key t1.id            as Id,

      t1.name          as Name,
      t1.lastname      as Lastname,
      t2.birthdate     as Birthdate,
      t2.cellphone     as Cellphone,
      t2.email         as Email,
      t2.countryorigin as Countryorigin
}
where
  countryorigin = $parameters.p_country_origin;