Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Usage of date in where clause or join in CDS view

former_member706668
Discoverer

‎2020 Oct 09 7:53 AM

0 Kudos
820

Hi.

i'm developing CDS view and i need to use timestamp fied in WHERE clause or in JOIN tabels. i need it to be equal to curtain value. e.g. " where field1 = 99993112235959" but when i do it i get errror like this: "Value of literal (-)99991231235959 is greater than a 4-byte integer" . thing is that in table this field value is 99993112235959, if i use this field in select it's 99993112235959(or another but with same length)

1 REPLY 1

michael_piesche
Active Contributor

‎2020 Oct 09 9:58 AM

0 Kudos
340

Did you check the following SAP note, are you on an ABAP version lower than ABAP 751?

Solution:

  • The support to the usage of DEC15 is implemented in SAP_BASIS 7.51 or higher.
  • As a workaround, it is possible to use a JOIN operation with a special table that contains the necessary comparison value.

PS: Searching by the errors content "Value of literal is greater than a 4-byte integer" would have led you to the above mentioned note.