Skip to Content
avatar image
Former Member

Cast issue in where condition in CDS NUM3 to NUM2


I have a requirement where I have CDS query like below -
define view ZXXXX

with parameters p_from_fis_period :numc3,

as select from BKPF

left outer join COVJ

on COVJ.belnr = BKPF.belnr


BKPF.MONAT = :p_from_fis_period AND

COVJ.PERAB = :p_from_fis_period.


The query is that I have defined the parameter p_from_fis_period as numc3 which is compatible with COVJ.PERB.

However it is not compatible with BKPF.MONAT as it is numc2.

I am not able to cast in Where condition or use ltrim functions.

Please suggest how to achieve this.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers