ABAP_SYNTAX ... lhs $[NOT$] BETWEEN rhs1 AND rhs2 ...>
What does it do? Compares an interval in a condition> in a CDS view entity>. The relational expression is true if the value of lhs> is between the values of rhs1> and rhs2>. The expression has the same meaning as the following join of two comparisons>: ... lhs >= rhs1 AND lhs < = rhs2 ...> The operands lhs>, rhs1>, and rhs2> must stick to the context-dependent rules listed in topic CDS DDL - View Entity, cds_cond >, Operands>. Moreover, the data types of the operands must be comparable as described in topic CDS DDL - View Entity, cds_cond>, Comparable Types>.