Skip to Content
0

Cast issue in where condition in CDS NUM3 to NUM2

Nov 01, 2016 at 07:58 PM

42

avatar image
Former Member

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers