Skip to Content

Can sqlViewName of CDS view be renamed?

Hi all,

In CDS view, the first line is defined as

@AbapCatalog.sqlViewName: 'ZVIEW1'

My questions is, can 'ZVIEW1' be renamed?

I tried to rename it but got an error of "it cannot be rename cause it has been shipped".

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Dec 24, 2017 at 01:43 PM

    No, as documented.

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 06 at 05:28 PM

    Hi Eric,

    I encountered the same problem. When you first activated your CDS View, SAP generates an active version in the version database table. Because of that, the CDS Entity and the SQL View have been coupled. When you want to change the SQL View name, SAP does not allow because it is looking at the last active version.

    So the steps are:

    1. Make a local copy of the source code.
    2. Delete CDS Data Definition on Eclipse.
    3. Delete all the stored versions from table VRSD. (You can check on SE16N where OBJNAME="ZVIEW")
    4. Create new Data Definition with the copy you made.

    Add comment
    10|10000 characters needed characters exceeded