SAP Note 2602789 – How to delete a CDS View

The table DDLDEPENDENCY contains the assignment information between the DDL source name and the CDS view name. Also see SAP Note 2421686 – CDS view(DDL SQL View) cannot be activated with RUTDDLSACT and tcode SDDLAR