Ansicht
Dokumentation
ABENCDS_PATH_EXPRESSION_FILTER_V2 - CDS PATH EXPRESSION FILTER V2
Addresses (Business Address Services) ROGBILLS - Synchronize billing plansThis documentation is copyright by SAP AG.
- CDS View Entity, path_expr, Filter
... $[WHERE$] cds_cond ...
Effect
Filter condition for the current CDS association. If the join type is explicitly defined with INNER$|${LEFT OUTER$}, the addition WHERE must be specified explicitly. If this is not the case, WHERE must not be specified.
A filter condition is a condition cds_cond implemented as an expanded condition for the join when transforming the CDS association into a join.
For the operands of the filter condition of a path expression of a CDS view entity, the following rules apply:
- All relational operators are allowed.
- The Boolean operators NOT, AND, and OR are allowed.
- lhs expects a field of the association target of the current CDS association.
- rhs expects a field of the association target of the current CDS association, a literal, a parameter, a session variable, or a built-in function.
- if the operator LIKE is used, then rhs must be a character literal.
- Path expressions are not supported.
- Other expressions are not supported.
If no filter condition is specified in the path expression, any default filter condition specified for the CDS association is used.
Note
In CDS view entities, the filter conditions of multiple CDS associations are by default compared semantically. If the filter conditions match, the associated join expression is created only once. This generally improves performance.
Example
The following CDS view entity contains path expressions with filter conditions in its SELECT list that are implemented as join expressions upon activation.
The following image shows the joins created on the database:
IMAGE @@ABDOC_PATH_EXPR.png@@492@@213@@Vendor Master (General Section) SUBST_MERGE_LIST - merge external lists to one complete list with #if... logic for R3up
This documentation is copyright by SAP AG.
Length: 4376 Date: 20240419 Time: 012227 sap01-206 ( 51 ms )