title: how can I select data similar to SQL WHERE LIKE from a parameter value
body: <p>I have the following CDS:</p>
  
  <pre><code>@AbapCatalog.sqlViewName: 'ZAMPAYERINFO'
  @AbapCatalog.compiler.compareFilter: true
  @AccessControl.authorizationCheck: #CHECK
  @EndUserText.label: 'Read payer information'
  define view zam_payer_info
  with parameters p_payer: abap.char(10)
  as select distinct from knvp 
     join kna1 on
     knvp.kunnr = kna1.kunnr
  {
      key knvp.kunnr as Payer,
      kna1.name1 as Name
  } where knvp.kunnr like $parameters.p_payer
  </code></pre>
  
  <p>that the compiler complains:</p>
  
  <pre><code>Comparison value of LIKE condition must be a character-type literalZAM_PAYER_INFO (Data Definition)
  As you can see on the CDS code, I am using character-type.
  </code></pre>
  
  <p>I understand, what LIKE statement do, for example:</p>
  
  <pre><code>@AbapCatalog.sqlViewName: 'ZAMPAYERINFO'
  @AbapCatalog.compiler.compareFilter: true
  @AccessControl.authorizationCheck: #CHECK
  @EndUserText.label: 'Read payer information'
  define view zam_payer_info
    with parameters
      p_payer : abap.char(10)
    as select distinct from knvp
      join                  kna1 on knvp.kunnr = kna1.kunnr
  {
    key knvp.kunnr as Payer,
        kna1.name1 as Name
  }
  where
    knvp.kunnr like 'a%'
  </code></pre>
  
  <p>Search all kunnr that starts with a. But my problem is, how to combine it with input parameter <code>p_payer</code>, at the end it should be <code>LIKE %p_payer</code>, where <code>p_payer</code> will be replace through the value that I passed.</p>
  
  <p>What can be wrong?</p>