New SQL functions with ABAP 7.51



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



Leave a Reply