Kontakt

Ansicht
Dokumentation

ABENSQL_ARITH - SQL ARITH

ABENSQL_ARITH - SQL ARITH

SUBST_MERGE_LIST - merge external lists to one complete list with #if... logic for R3up   ROGBILLS - Synchronize billing plans  
This documentation is copyright by SAP AG.
SAP E-Book

- sql_arith

... $[-$] sql_exp1 +$|-$|*$|/ $[-$] sql_exp2 $[+$|-$|*$|/ $[-$] sql_exp3 ... $] ...

Effect

Arithmetic expression in . The operators perform arithmetic calculations between two adjacent operands sql_exp1, sql_exp2, .... The possible operators are:

  • + for adding the operands
  • - for subtracting the right operand from the left operand
  • * for multiplying the operands
  • / for dividing the left operand by the right operand

The operators * and / have a higher priority than the operators + and -. Within a parenthesis level, operations with a higher priority are performed before those with a lower priority. Operations with identical priorities are performed from left to right. A minus sign - can be placed in front of an operand that does not directly follow an operator +, -, *, or /.

The arithmetic expressions in are distinguished depending on the data type of the operands as follows:

  • Integer expressions
Integer expressions use only integer operands, regardless of the parenthesis level. These have the dictionary type INT1, INT2, INT4, and INT8 or the ABAP type b, s, i, and int8 plus packed numbers of the types DEC, CURR, and QUAN or p without decimal places. The operator / is not allowed in integer expressions. An overflow occurs and an exception of the class CX_SY_OPEN_SQL_DB is raised when
  • the value range of the type INT4 or i is exceeded in operations between two integer numbers where neither of the numbers has the type INT8,

  • the value range of the type INT8 or int8 is exceeded in operations between two integer numbers where one of the numbers has the type INT8,

  • the value range of a packed number with length 31 without decimal places is exceeded in operations using packed numbers.

Depending on the types of the operands and whether packed numbers are involved, the result has the type INT4, INT8 or is a packed number with length 31 and no decimal places. Using the associated assignment rule, it can be assigned to all numeric ABAP types whose value range is large enough, except for decimal floating point numbers.
  • Decimal expressions
Alongside any integer operands (see above), decimal expression have at least one operand with the type DEC, CURR, or QUAN or p with decimal places. The operator / is not allowed in decimal expressions. The result has the type DEC with the length 31 and a maximum of 14 decimal places. Using the associated assignment rule, it can be assigned to all numeric ABAP types whose value range is large enough, except for decimal floating point numbers.
If a decimal expression is specified statically, the syntax check checks that the result of each operation is in the value range of the type DEC with length 31 and a maximum of 14 decimal places. If any operands are specified that could produce other values, a syntax error occurs. If the expression is specified dynamically, an exception of the class CX_SY_DYNAMIC_OSQL_SEMANTICS is raised in this case.
  • Decimal floating point expressions
Alongside any integer operands and operands of the type DEC, CURR, and QUAN or p, decimal floating point expressions have at least one operand of the type DECFLOAT16 or DECFLOAT34 or of the ABAP type decfloat16 or decfloat34. Decimal floating point expressions allow division between two decimal floating point numbers of types DECFLOAT16 or DECFLOAT34 using the operator /. Depending on the types of the operands, the result has the type DECFLOAT16 or DECFLOAT34. Using the associated assignment rule, it can be assigned to the ABAP types decfloat16 or decfloat34. If the value range of the result type is exceeded or division by 0 takes place, an overflow occurs and an exception of the class CX_SY_OPEN_SQL_DB is raised.
  • Binary floating point expressions
Binary floating point expressions only have operands with the dictionary type FLTP or with the ABAP type f. Only binary floating point expressions allow division with the operator /. If the value range of the type FLTP is exceeded or division by 0 takes place, an overflow occurs and an exception of the class CX_SY_OPEN_SQL_DB is raised. The result has the type FLTP and can only be assigned to a field with the ABAP type f in accordance with the associated assignment rule.

No other combinations of operand are allowed. The operands can all be SQL expressions of the specified data types.

If the operand of an arithmetic expression has the null value, the result of the entire arithmetic expression is the null value.

Notes

  • Specifying an arithmetic expression always means specifying an SQL expression. Arithmetic expressions can only be specified for operand positions for which SQL expressions are possible.
  • The arithmetic expressions are divided into the three categories integer expressions, decimal expressions, and floating point expressions to achieve the same behavior in all supported database systems.
  • To use operators that do not have the type FLTP in a binary floating point expression, they can be transformed to an operator with the type FLTP using a CAST expression.
  • A plus sign + cannot be specified in front of an operand of an arithmetic expression. If a minus sign - is to be specified after an operator +, -, *, or /, the sign and the operand must be placed in parentheses.
  • If an operand is prefixed with a minus sign (-), the syntax check is performed in a strict mode, which handles the statement more strictly than the regular syntax check.

Example

Arithmetic expression as an argument of the built-in function DIVISION in a SELECT list. To use the operator / instead of DIVISION, its operands would have to be cast to DECFLOAT16, DECFLOAT34, or FLTP and the result would also have the corresponding type.

SQL Expressions, Arithmetic Calculations






General Material Data   General Data in Customer Master  
This documentation is copyright by SAP AG.

Length: 8661 Date: 20240427 Time: 000531     sap01-206 ( 161 ms )