on ‎2016 Nov 01 7:58 PM - last edited on ‎2024 Feb 03 5:48 PM by postmig_api_4
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.
Request clarification before answering.
| User | Count |
|---|---|
| 6 | |
| 6 | |
| 6 | |
| 5 | |
| 4 | |
| 4 | |
| 3 | |
| 3 | |
| 2 | |
| 2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.