Skip to Content
Technical Articles
Author's profile photo Vijay Sharma

S/4HANA 2023- Wizard to Migrate CDS DDIC-Based Views to CDS View Entities

CDS View entities were release as of ABAP release 7.55  and SAP is currently migrating its CDS DDIC-based views (DEFINE VIEW, deprecated syntax) to CDS view entities (DEFINE VIEW ENTITY, new syntax).

To support this migration, SAP had already provided tools and utilities shown below and are explained in this wonderful blog by Andrea Schlotthauer.

Tool name Technical name Available since
Program that lists all usages of CDS-managed DDIC views RUT_WHERE_USE_SQLVIEW SAP Note 3201681
Program for migration analysis RUTDDLS_MIGRATION_CANDIDATES ABAP 7.56 | ABAP Platform 2021
Manual migration ABAP 7.56 | ABAP Platform 2021
Program for tool-based migration RUTDDLSV2MIGRATION ABAP 7.56 | ABAP Platform 2021
ADT migration wizard

ABAP quarterly release 7.91

S/4HANA Version 2023

ADT based Wizard, to assist with this migration, was released for Public cloud with version 2302.
Good news is , this Wizard is now available for on-premise users with version 2023.


In this blog , i will quickly show you how to use this wizard. Let’s begin…

As a prerequisite , you can start with the identification of all the DDIC based CDS views and you could create a repository tree for that as is suggest in the above mention blog from Andrea.

Once identified follow the below steps:

  • Select the DDIC based CDS view you want to migrate to CDS view entity and right click
  • You will see the additional option “Migrate to CDS View Entity”

  • Following screen will show all the selected DDIC CDS views for migration.

  • Click Next and we will see two options on the next screen
    • Simulate – This is to simulate the migrate to check for any possible errors upfront.
    • Migrate – This will migrate the DDIC view to CDS view entity and can’t be reverted once done.
  • Select  simulation and click finish

  • The simulation run will shown any error or warnings. In this case we can see there are warnings in the pre-check phase.

  • Expand the Precheck node to display the details. We can see , there are warnings regarding usage of SQL view and impacts on value help with data elements as those would be impacted. We should address these impacts before we proceed with actual migration. The usage of SQL views can be checked using the Program mentioned at the beginning.

  • Once all the issues are addressed, select the migration option and finish.

  • On completion message log will be displayed to see if any errors or warning or successful migration.

  • We can see the DDIC based view is migrated to the CDS View Entity and the SQL view is deleted.




Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Vasu Gorli
      Vasu Gorli

      Hi Vijay,


      Thank you for sharing the info... appreciate your efforts for detailed explanation.

      I've a question here, after migrating the DDIC based CDS VIEW to CDS VIEW ENTITY, the SQL VIEW is getting deleted. it means, HANA VIEW is getting deleted?

      If we create new CDS VIEW ENTITY, will still create a new HANA VIEW upon activation?


      Thank you!!




      Author's profile photo Jelena Perfiljeva
      Jelena Perfiljeva

      This was answered in the comments to this blog post, take a look: