ABAP_DDIC - SQL Functions for Numeric Values The following table shows the numeric SQL functions that can be used by ABAP CDS and AB_SQL . The columns ABAP CDS DDIC-Based Views, ABAP CDS 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 FunctionResultCDS DDIC-Based Views CDS View Entities AB_SQL Table Buffer ABSAbsolute value of argument. x x x x CEILRounds an argument to the first integer that is greater than or equal to the value of the argument. x x xx DIVDivision of two arguments. The result is rounded to an integer. x x x x DIVISIONDivision of two arguments. The result is rounded to specified decimal places. x x x - FLOORLargest integer number not greater than the value of the argument.x x xx MODPositive or negative integer remainder of the division of two arguments. x x x x ROUNDRounded value of an argument. x x x - The possible operands and data types are described in the corresponding documentation for ABAP CDS, DDIC-Based Views, ABAP CDS, View Entities and AB_SQL .
