Ansicht
Dokumentation

ABENCDS_CONDITIONAL_EXPRESSION_V1 - CDS CONDITIONAL EXPRESSION V1

ABENCDS_CONDITIONAL_EXPRESSION_V1 - CDS CONDITIONAL EXPRESSION V1

Addresses (Business Address Services)   Fill RESBD Structure from EBP Component Structure  
This documentation is copyright by SAP AG.
SAP E-Book

- DDIC-Based View, cds_cond

... rel_expr
  | $[NOT$] cds_cond $[AND$|OR cds_cond$] ...

Effect

Logical expression cds_cond for formulating a condition in ABAP CDS. A logical expression is either a single relational expression rel_exp, or an expression composed of the Boolean operators NOT, AND, OR and one or more logical expressions, in which parentheses are possible. An atomic component of a compound logical expression is always one relational expression.

Possible relational expressions rel_expr from which a condition cds_cond can be constructed:

  • Interval comparisons using BETWEEN
  • Pattern comparisons using LIKE

The Boolean operators work as follows:

  • NOT negates the result of the following condition.
  • An AND combination is true if both combined conditions are true.
  • An OR combination is true if at least one of the combined conditions is true.

The operator NOT has a stronger binding than AND, which itself has a stronger binding than OR. This produces implicit parentheses, which can be overridden by explicit parentheses.

In SQL, the order in which two expressions are evaluated that are combined by AND is not defined. Results can be different on different database platforms.

Note

If multiple expressions are combined by AND, rules such as the following are not reliable: If one expression is false, then the following expressions are no longer evaluated. For example a condition col1 <> 0 AND col2 / col1 > 1 can raise an exception. To avoid such exceptions, CASE expressions can be used.






BAL_S_LOG - Application Log: Log header data   RFUMSV00 - Advance Return for Tax on Sales/Purchases  
This documentation is copyright by SAP AG.

Length: 4272 Date: 20240426 Time: 204815     sap01-206 ( 55 ms )