topic Re: New Open SQL Syntax CDS - Like & Parameter in Application Development and Automation Discussions

New Open SQL Syntax CDS - Like & Parameter

former_member627384 — Fri, 30 Aug 2019 15:47:47 GMT

Hi,

I am looking to create a CDS with parameters and perform a like operation on the parameter. But I can't get the correct syntax. Any help would be appreciated.

@AbapCatalog.sqlViewName: 'zviewshipnum'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Get shipment numbers like the parameter'
define view zcds_view_shipment_num
    with parameters p_shipNum : abap.Lang,
    p_haulier : TSPID
as select from /SCMTMS/D_TORROT {
    TOR_ID
}
where TOR_ID like CONCAT('%', '%')

Re: New Open SQL Syntax CDS - Like & Parameter

UweFetzer_se38 — Mon, 02 Sep 2019 14:09:08 GMT

Looks like this is not possible. The error message and documentation say "Comparison value of LIKE condition must be a character-type literal". No variables/functions can be used here.

So you have to use the LIKE in the where statement of the calling select.

SELECT tor_id FROM zcds_view_shipment_num
  INTO TABLE @DATA(tor_ids)
  WHERE tor_id LIKE 'Whatever%'

Re: New Open SQL Syntax CDS - Like & Parameter

DoanManhQuynh — Tue, 03 Sep 2019 00:55:02 GMT

maybe you could try instr( tor_id, :parameter ) function instead (i think it for abap 7.50+).