Table of Contents
SAP ABAP CDS views and SAP HANA CDS views are not the same. But they are similar. They are two different shapings of one concept. Both are based on the same specifications. But the aims between the views are different.
SAP CDS Views
SAP CDS views are part of SAP’s new programming model. The core idea of the programming model is to push the logic from the application server to the client-side and the database. And CDS views are part of pushing the logic to the database and the client-side as well.
Pushing the logic to the database because they take most of the logic from an ABAP application and execute it on the database instead of on the application server.
And they are pushing the logic to the client-side because CDS Views are able to control SAP UI5 Smart Controls and SAP Fiori Elements by annotations through OData services that can be generated from a CDS view. Therefore, the logic goes to the client-side because of the logic of the SAP UI5 controls delegated by CDS views.
CDS views are from the concept similar to ABAP dictionary views. They provide pre-defined SQL queries to one or more database tables. That allows effectively and comfortably to connect and access data.
But a SAP ABAP CDS view can do a lot more than a SAP ABAP dictionary view. An ABAP dictionary view is actually just an ABAP structure. An ABAP CDS view generates an ABAP structure too but also more on top of that. Overall, an ABAP CDS view generates or can generate:
- ABAP structure
- database structure
- Open SQL structure
- OData service
However, this is what ABAP CDS views and HANA CDS views have in common. Now to the differences between ABAP CDS views and HANA CDS views.
SAP ABAP CDS Views
SAP ABAP CDS views are defined at the level of the ABAP application server. The views are created and maintained in DDL files which reside in the ABAP application server. They are part of the Data Dictionary (SE11) and therefore, part of the ABAP transport system, life cycle management, etc.
The views using Open SQL. ABAP CDS views aim to support the development of ABAP applications. Whereby, the type of the database system irrelevant is. It does not have to be HANA. Therefore, the main focus of ABAP CDS views is to create views and not models.
- reside application server
- work with any database
- Open SQL
- ABAP applications
- main focus to create views
SAP HANA CDS Views
SAP HANA CDS views are defined at the level of the HANA database. The views are created and maintained in DDL files (Data Definition Language files) which reside at the database level in the HANA XS (HANA Extended Application Services). The views using Native SQL.
HANA CDS views aim to support the development of native applications of SAP HANA. They are using features that are specific for SAP HANA. Therefore, they can only be used with a HANA database. The main focus of HANA CDS Views is to create models.
- reside HANA database (HANA XS)
- work only with HANA database
- Native SQL
- native HANA applications
- main focus to create models
Compatibility between SAP ABAP CDS Views and SAP HANA CDS Views
SAP ABAP CDS views and SAP HANA CDS views are two different CDS implementations. Their technical compatibility is not guaranteed. Because
- They run on different platforms: ABAP CDS views reside in the ABAP application server (ECC, S/4). HANA CDS views reside in the HANA database (HANA XS).
- They have different requirements: ABAP CDS views support the implementation of ABAP applications. HANA CDS views support the development of native HANA applications.
Therefore, ABAP CDS views and HANA CDS views have different functionalities and release cycles.