cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Cast issue in where condition in CDS NUM3 to NUM2

Former Member
0 Likes
443

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.

Accepted Solutions (0)

Answers (0)