CDS Views
No Comments

Differences Between SAP ABAP CDS Views and SAP HANA CDS Views

An apple and pear green background.

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.

SAP new programming model code to data.

SAP new programming model code to data.

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 ABAP CDS views reside in the application server in the Data Dictionary but processing the logic in the database.

SAP ABAP CDS views reside in the application server in the Data Dictionary but processing the logic in the database.

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.

These are the differences between SAP ABAP dictionary views and SAP ABAP CDS views.

Most Recent Articles

Poll

Will SAPUI5 replace the SAP CRM Web UI soon?

Loading ... Loading ...

More Similar Articles

Leave a Reply

Your email address will not be published. Required fields are marked *

Fill out this field
Fill out this field
Please enter a valid email address.

Menu