ABAP HANA 7.51: New SQL functions with ABAP 7.51
SAP provides many new SQL functions which help to perform in-SQL calculations and hence facilitates Code push down. In some of the cases, it can enhance code performance in a great way. Some of the new functions are as below:
- DATS_ADD_DAYS(date1, dayCount,if_error) – Returns a date, dayCount days after date1
- DATS_DAYS_BETWEEN(date1,date2) – Returns interval between 2 dates
- COALESCE(argument1,….) – Returns first non-null argument
- CONCAT_WITH_SPACE(argument1,argument2,) – concatenates arguments with number of spaces provided in 3rd argument
- CONCAT(argument1,….) – concatenates arguments, trailing blanks are not taken into account
- LENGTH(argument) – Gives length of argument but ignores trailing blanks
- LOWER(argument) – Converts the string argument to lower case
- MOD(argument1,argument2) – Gives remainder after argument1/argument2
- DIVISION(argument1,argument2,DEC) – Result is division of argument1 by argument2 and rounded to DEC number of places
- DIV(argument1,argument2) – Gives Integer part of Division operation
- FLOOR(argument) – Provides just immediate smaller neighbor Integer
- CEIL(argument) – Provides just immediate bigger neighbor Integer
- ABS(argument) – Gives absolute value of argument