Skip to Content
0

DATS_ADD_DAYS CDS views not working

May 25, 2017 at 02:12 PM

78

avatar image
Former Member

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

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

1 Answer

Best Answer
Sean Zhang
May 26, 2017 at 02:30 AM
1

DATS_ADD_DAYS(date,days,on_error)

  • The actual parameter days must have the predefined data type INT4.

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

Share
10 |10000 characters needed characters left characters exceeded