Skip to Content
4
Jul 09, 2018 at 07:03 AM

ABAP CDS-View: Select with Where and DEC15 "timestamp"

1471 Views

Hello,

i want to select from Table but021_fs (the business partner adress usage). I want to filter for the field "valid_to" which is DEC15.

I always get error messages.

If i use

where but021_fs.valid_to = '99991231235959' I get an data type conflict error

where but021_fs.valid_to = 99991231235959 I get an error with 4-Byte-Integer error

where but021_fs.valid_to = '99.991.231.235.959' I get an data type conflict error

and but021_fs.valid_to = 99991231235959.0 I get an error that the value is too big.

So, how to correctly make this statement?

Thanks for your help