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

 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: 

• Custom analytical queries and services (F1572A) - CAQS
• Custom analytical queries (F1572) – CAQ

SAP S/4HANA Cloud Public Edition 2508

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.

      

 2. Search and Select

• Use the search function to locate the query you want to migrate.
• Select the desired query.

    

   

3. Query Selection

• Choose OK to proceed:

• • A projection view (query) is created with the same name as the selected query.
  • This projection view is initially in draft mode.
  • The projection view status changes to “Migration in progress.”

   

 

Following steps are performed to ensure the consistency of the custom analytical queries during migration:

• Once in this status, Edit and Delete actions in the CAQ app are disabled.
•  To continue editing or deleting the query in CAQ app, cancel the migration in the CAQS app first. To cancel the migration see point 8.

"The query cannot be edited as it is migrating to Custom Analytical Queries and Services app. To edit the query, delete it from Custom Analytical Queries and Services app."

 "The query cannot be deleted as it is migrating to Custom Analytical Queries and Services app. To delete the query, first delete it from Custom Analytical Queries and Service."

   

CAQ: To ensure consistency edit and delete are blocked.

 

   

 

     

4. Resolve - Rework Tasks/Errors

• After the query is created, a list of rework tasks or errors (if any) will be displayed.
• Make the required adjustments and resolve all errors.
  • Refer to the relevant Knowledge Base Article (KBA) 3603149 for help in resolving rework tasks.

      

    

5. Check

• Click ‘Check’ to generate the draft version of the migrated query.
• If there are any errors still on check , resolve them and retry.

 

 

 

 

 

6. Preview

• Use the Preview function to verify whether the draft meets your expectations.
• Ensure the projection view accurately reflects the original query’s purpose and data requirements.

 

     

7. Confirm the Migration

• Choose ‘Confirm’ to finalize the migration:

“On confirmation, the query will be deleted from the Custom Analytical Queries app and migrated to the Custom Analytical Queries and Services app. Do you want to continue?”  

• • This process is irreversible , continuing with this will migrate the query completely.
  • On successful completion, query is fully transitioned to the Custom analytical queries and services app.
  • The query status changes to ‘Published’ from ‘Migration in progress’.
  • Query is migrated and not available in Custom analytical queries application anymore.

 

 

 

      

 

CAQS: Query published in Custom analytical queries and services application after successful migration

 

CAQ: Query not available in Custom analytical queries application after successful migration

    

8. Cancel the Migration (Optional)

• • You can cancel the migration before clicking on Confirm. When the query is in "Migration in progress" choose Delete Draft in the Query list page of CAQS app.

• • This removes the query from the CAQS app.
  • The original query remains intact in the CAQ app as analytical query.
  • Migration is terminated but can be reinitiated.

Custom Analytical Queries | SAP Help Portal

Custom Analytical Queries and Services | SAP Help Portal

3603149 - Rework tasks after Migration - Custom Analytical Queries and Services - SAP S/4HANA Cloud Public Edition 2508 - SAP for Me

KBA , BC-SRV-APS-EXT-AQD , Fiori based Query Designer , Problem

SAP S/4HANA Cloud Public Edition all versions