3603185 - Migration of Queries to Projection Views - Custom Analytical Queries and Services

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:

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

Caution

Before confirming the migration and transporting the query, be aware of the following limitation related to SAP Adaptation Transport Organizer (ATO).

When a query is migrated, a new Projection View is created in Custom Analytical Queries and Services app under the same name. However, ATO registers the original query (Custom Analytical Queries app) and the new projection view (Custom Analytical Queries and Services app) as two separate object types. Once the original query is deleted and transported, ATO retains the name registration for the legacy object type.

If you delete the migrated projection view from Custom Analytical Queries and Services app, you will not be able to create a new query with the same name in Custom Analytical Queries and Services app. ATO will block the name from being reused for a projection view in Custom Analytical Queries and Services app.

Environment

SAP S/4HANA Cloud Public Edition 2508

SAP S/4HANA Private Cloud 2025

SAP S/4HANA 2025

Product

SAP S/4HANA Cloud Private Edition all versions ; SAP S/4HANA Cloud Public Edition all versions ; SAP S/4HANA all versions

Keywords

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

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.