Symptom
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.
Read more...
Environment
Netweaver based systems with release 740 and so on
Product
Keywords
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.