Ansicht
Dokumentation
ABENWHERE_LOGEXP_INTERVAL - WHERE LOGEXP INTERVAL
RFUMSV00 - Advance Return for Tax on Sales/Purchases Fill RESBD Structure from EBP Component StructureThis documentation is copyright by SAP AG.
- BETWEEN
... operand $[NOT$] BETWEEN operand1 AND operand2 ...
Effect
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 specified individually col 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.
- 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. This is also checked by the strict modes of the syntax check from Release and can raise an exception.
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.
Example
Reading of all flights within the next 30 days.
Fill RESBD Structure from EBP Component Structure General Data in Customer Master
This documentation is copyright by SAP AG.
Length: 2992 Date: 20240425 Time: 173400 sap01-206 ( 33 ms )