SAP Knowledge Base Article - Public

3603185 - Migration of Queries to Projection Views - Custom Analytical Queries and Services - SAP S/4HANA Cloud Public Edition 2508

Symptom

 Scope

Migration of Queries from Custom analytical queries application to Projection views in Custom analytical queries and services application.

    

Why are we migrating? 

CDS analytical projection views are a new type of CDS projection view, available since SAP BTP ABAP Environment 2111. They are designed for modelling analytical queries within a CDS data model and they improve on the previous version of CDS Analytical Queries.

CDS projection views are generally preferred because they offer a streamlined and efficient way to expose data from an underlying CDS data model for specific use cases, particularly in the context of ABAP RESTful Application Programming Model (RAP). They provide a clear separation between the general data model and the service-specific presentation, leading to cleaner code and easier maintenance.

     

Note: 

Environment

SAP S/4HANA Cloud Public Edition 2508

Resolution

Migration process:

1. Open the Migration Dialog

  • Choose ‘Migrate’ to launch the Migration dialog.
  • This dialog displays a list of available queries from the Custom Analytical Queries (CAQ) application, along with their respective statuses as below:
    • Published
      • As part of this release 2508 - Migration focusses majorly on the queries created from Custom analytical queries application, hence below points are to be noted.
      • Queries marked as Published are eligible for migration.
      • Some published queries which are copies of SAP-released queries will be supported in future."The query cannot be migrated as it is a copy of an SAP-released query."
    • Changed
      • To ensure the consistency of the custom analytical queries during migration, queries that are published but have an existing draft version in the CAQ app will not be migrated in this state.
      • To proceed, publish/delete the draft in the CAQ app, then start the migration in the CAQS app.

                               "The query in Changed status cannot be migrated. Publish or delete the draft to continue migration."

    • Migration in Progress
      • Queries currently in 'Migration in progress' state cannot be selected again.