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.

In SE11 when display the affected object the following message "View xxxxx is not in the database" appears even though they were display as "Active":

========================================

View <view name> is not in the database

Message No. E2302

Diagnosis

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

Information.

Procedure

It is possible to create the view on the database with the database utility (SE14). The view also can be activated again. The view is automatically created on the database in this case.

====================================

The missing objects are also 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 RUTDDLSACT report is used to activate them, activation fails with error.

SAP NetWeaver release 740 and so on.

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 selection, DBSQL_TABLE_UNKNOWN , KBA , BC-DWB-DIC-AC , ABAP Dictionary Activation and Conversion , Problem