Skip to Content

Cast issue in where condition in CDS NUM3 to NUM2

Nov 01, 2016 at 07:58 PM


avatar image
Former Member


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.

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

0 Answers