SAP WHERE LOGEXP INTERVAL



Get Example source ABAP code based on a different SAP table
  


Short Reference
• BETWEEN ABAP_OSQL_COND
• NOT BETWEEN ABAP_OSQL_COND

ABAP_SQLCOND - BETWEEN

ABAP_SYNTAX
... operand $[NOT$] BETWEEN operand1 AND operand2 ...

What does it do?
This relational expression is true if the content of the operand operand is (is not) between the values of the operands operand1 and operand2.
The following applies to operand:
Numeric SQL expressions except for aggregate expressions and window expressions can be specified.
A column col specified individually cannot be numeric.
In a HAVING clause, aggregate expressions can also be used.
The following applies to operand1 and operand2:
Elementary SQL operands can be specified.
Columns col must have a numeric data type and they need to be prefixed with the name of the data source using ~. In this case, operand must also be numeric.
Numeric SQL expressions except for aggregate expressions and window expressions can be specified.
Cast expressions can be specified.
The content of ABAP objects, that is, untyped literals, host variables, and host expressions must match the data type of operand in accordance with the rules for lossless assignments.
BEGIN_SECTION VERSION 5 OUT This is also checked by the strict modes of the syntax check from ABAP_RELEASE ABAP_740_SP08 and can raise an exception.
END_SECTION VERSION 5 OUT
The interval limits are included. The comparison is made in the same way as for
... $[NOT$] ( operand >= operand1 AND operand < = operand2 ) ...
and the corresponding rules and notes apply.

ABAP_EXAMPLE_VX5
Reads all flights within the next 30 days.
ABEXA 01400
ABAP_EXAMPLE_END