SAP Knowledge Base Article - Preview

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

Symptom

CDS views (DDL SQL View) are not activated in your system.

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".

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

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

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 , 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.