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

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

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

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