2418979 - CDS views (DDL SQL views) cannot be activated with unknown function name

CDS views (DDL SQL Views) failed to be activated/created because of unknown function name. The error expression can differ depending on the database.

Here are some examples:

Oracle database

ORA-00904: "SAP_SUBSTRING": invalid identifier

ORA-00904: "CURRENCY_CONVERSION": invalid identifier

SQL Server database

SQL-error "4121-Cannot find either column "<sid>" or the user-defined function or aggregate "<sid>.SAP_LPAD", or the name is ambiguous."

SQL-error "4121-Cannot find either column "<sid>" or the user-defined function or aggregate "<sid>.SAP_CONCAT", or the name is ambiguous."

DB6

SQL0204N "SAP<SID>.CURRENCY_CONVERSION" is an undefined name.

SQL0440N  No authorized routine named "TSTMP_CURRENT_UTCTIMESTAMP" of type "FUNCTION" having compatible arguments was found.

DB4

ST11-> developer trace file (dev_w<No.>):

Unknown DB object while executing: DROP VIEW ....
 ThEppGetConnectionCounter: read connectionCounter 0 from * 0
 *** ERROR => ds_dbsl_funs.execute returned 103.

Unknown DB object while executing: CREATE VIEW ...
ThEppGetConnectionCounter: read connectionCounter 0 from * 0
*** ERROR => ds_dbsl_funs.execute returned 103

SAP ASE

[ASE Error SQL14217][SAP][ASE ODBC Driver][Adaptive Server Enterprise] SQL function not found.

[ASE Error SQL102:42000][SAP][ASE ODBC Driver][Adaptive Server Enterprise]Incorrect syntax near 'sp_procxmode'. 

HANA DB

SQL-error "459-invalidated function

Such errors may occur during the activation of CDS views in ADT(ABAP Development Tool), using report RUTDDLSACT or during system maintenance using SPAM/SAINT/SUM.

NetWeaver based systems

DDL SQL views, CDS views, SQL4121, SQL 4121, ORA-00904, SQL0204N, SQL0204, SQL0440N  No authorized routine named, SQL0440N, ds_dbsl_funs.execute returned 103, ASE Error SQL14217, invalid identifier, user-defined function or aggregate, undefined name, SQL function not found, SAP_SUBSTRING, CURRENCY_CONVERSION, SAP_CONCAT, SAP_LPAD, RUTDDLSACT, RUTCNVFUNCCRE1, Incorrect syntax near 'sp_procxmode', Incorrect syntax near, SQL102, Cannot find either column, ACM_UNEXPECTED_VALUE, ACMRT_RES_LOGEXP, DBRS_RC_SQL_ERROR , KBA , BC-DWB-DIC-AC , ABAP Dictionary Activation and Conversion , BC-DB-DB6 , DB2 Universal Database for Unix / NT , BC-DB-SDB , MaxDB , BC-DB-DB4 , DB2 for AS/400 , BC-DB-MSS , SQL Server in SAP NetWeaver Products , BC-DB-DB2 , DB2 for z/OS , BC-DB-ORA-SYS , Database Interface / DBMS , Problem