Get Example source ABAP code based on a different SAP table
• WHERE ABAP_CDS_TRANS_QUERY
ABAP_CDS_DDL - WHERE, Transactional Query
ABAP_SYNTAX ... WHERE cds_cond ...
What does it do? Defines a WHERE condition for the result set of a CDS projection view. When the CDS projection view is accessed, the result set contains only the data from the projected entity cds_entity that meets the condition cds_cond specified after WHERE. The condition is either a single relational expression rel_expr or an expression constructed from the Boolean operators NOT, AND , and OR. In CDS projection views, the following rules apply to the operands and syntax of the WHERE condition:
Comparison operators, BETWEEN , LIKE, and IS [NOT] INITIAL are allowed as operators.
The Boolean operators NOT , AND, and OR are supported.
lhs expects a field of the projected entity. The field does not necessarily have to be included in the projection list.
rhs can be a field of the projected entity, an untyped literal, or a session variable. When using the operator LIKE , rhs must be a character literal. ABAP_NOTE typed literals are currently not supported in this position.
