SAP EXEC SQL DB FUNCTION ABEXA

Get Example source ABAP code based on a different SAP table
  SAP Help

ABAP_EXEC_SQL - Access to Database Functions
This example demonstrates how a database function is accessed using static Native SQL.

ABAP_SOURCE_CODE
DEMO CL_DEMO_EXEC_SQL_DB_FUNCTION

ABAP_DESCRIPTION
After EXEC SQL, this example creates a scalar database function with two input parameters and uses this function in the WHERE condition of a SELECT statement.