Ansicht
Dokumentation
ABENSQL_FUNCTIONS_NUMERIC - SQL FUNCTIONS NUMERIC
ROGBILLS - Synchronize billing plans ROGBILLS - Synchronize billing plansThis documentation is copyright by SAP AG.
- SQL Functions for Numeric Values
The following table shows the numeric SQL functions that can be used by ABAP CDS and . The columns ABAP CDS, DDIC-Based Views / View Entities and ABAP SQL indicate where a function can be used. The Table Buffer column indicates whether the function can be executed in the table buffer.
SQL Function | Result | CDS DDIC-Based Views | CDS View Entities | Table Buffer | |
ABS | Absolute value of argument | x | x | x | x |
CEIL | Rounded to the first integer that is greater than or equal to the value of an argument | x | x | x | x |
DIV | Division of two arguments. The result is rounded to an integer. | x | x | x | x |
DIVISION | Division of two arguments. The result is rounded to specified decimal places. | x | x | x | - |
FLOOR | Largest integer number not greater than the value of the argument. | x | x | x | x |
MOD | Positive or negative integer remainder of the division of two arguments. | x | x | x | x |
ROUND | Rounded value of an argument. | x | x | x | - |
Descriptions of the possible operands and data types can be found in the corresponding documentation for ABAP CDS, DDIC-Based Views, ABAP CDS, View Entities and .
Note
Example
The following table shows the results of integer divisions and their integer remainders in SQL. See also the example for the ABAP operators DIV and MOD.
expr1 | expr2 | DIV | MOD |
7 | 3 | 2 | 1 |
-7 | 3 | -2 | -1 |
7 | -3 | -2 | 1 |
-7 | -3 | 2 | -1 |
Addresses (Business Address Services) RFUMSV00 - Advance Return for Tax on Sales/Purchases
This documentation is copyright by SAP AG.
Length: 6851 Date: 20240420 Time: 125359 sap01-206 ( 44 ms )