SAP Knowledge Base Article - Preview

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."



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.


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



[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'. 


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


SAP NetWeaver 7.4 ; SAP NetWeaver 7.5


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

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.