SAP Knowledge Base Article - Preview

2421686 - CDS view(DDL SQL View) cannot be activated with RUTDDLSACT


Dump DBSQL_TABLE_UNKNOWN occurs, which points to an unknown CDS view (DDL SQL View) on database level.

If you tried to display them in transaction SE11, you got message "View xxxxx is not in the database" even though they were display as "Active":


View <view name> is not in the database

Message No. E2302


This is a database view which is defined in the ABAP/4 Dictionary but does not exist on the database. No data can be read for this reason.

System Response



You can create the view on the database with the database utility (SE14). You can also activate the view again. The view is automatically created on the database in this case.


You can also find that they are listed in transaction DB02->"objects missing in database".

The general solution is to activate it, so that it can be created on database level.

CDS views cannot be activated in transaction SE11/SE14 as described in the message E2302. As mentioned in SAP Note 2023690 - CDS views are inactive , CDS views can be activated using report RUTDDLSACT. But when you used report RUTDDLSACT to activate them, activation fails with error.



Netweaver based systems with release 740 and so on


SAP NetWeaver 7.4 ; SAP NetWeaver 7.5 ; SAP NetWeaver Application Server for ABAP 7.51 innovation package ; SAP NetWeaver Application Server for ABAP 7.52


objects missing in database, db02, E2302, CDS view, DDL SQL View, DDL source, SE11, Table/Join Conditions, RUTDDLSACT, RUTDDLSSHOW, conversion function, unknown function name, multiple seleciton, DBSQL_TABLE_UNKNOWN , KBA , BC-DWB-DIC-AC , Activation Prog., Conversion Prog., DB-Utility, MC, SPDD , 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.