@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;