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 on different databases are also not the same.

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 when you try to activate 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 , KBA , BC-DWB-DIC-AC , Activation Prog., Conversion Prog., DB-Utility, MC, SPDD , BC-DB-DB6 , DB2 Universal Database for Unix / NT , BC-DB-SDB , MaxDB , BC-DB-DB4 , DB2 for AS/400 , BC-DB-DB2 , DB2 for z/OS , BC-DB-MSS , SQL Server in SAP NetWeaver Products , 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 ONE Support launchpad (Login required).

Search for additional results

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