on 05-25-2017 3:12 PM
hi experts,
I have written a CDS Views with join on BKPF and BSEG i need to add BLDAT + ZBD1T shown below .
DATS_ADD_DAYS( bkpf.bldat , bseg.zbd1t ,'NULL' ) as duedate ,
The error thrown is ZBD1T is DEC type is not allowed only INT4 is allowed.
Can we have a solution for this.
Regards
Mohsin
DATS_ADD_DAYS(date,days,on_error)
so you firstly have to convert the DEC type to INT4.
e.g.
DATS_ADD_DAYS( bseg.augdt,ceil(bseg.zbd1t) ,'NULL' ) as AD
CEIL(arg)Smallest integer number not less than the value of arg.BTW, please actively use the F1 help document to check the error and/or google.
Best Regards,
Sean
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
94 | |
11 | |
10 | |
6 | |
5 | |
5 | |
4 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.