Skip to Content
avatar image
Former Member

Cast issue in where condition in CDS NUM3 to NUM2

Hi..

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

WHERE

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