Introduction to Core Data Services

Application Design with SAP HANA

What is Code Push Diagram?

Why CDS was required?

Issue 1: Large Semantic Gap between Task and SQL Code Today

Issue 2: SQL Complexity Leads to Imperative Code

CDS Brings Conceptual and Implementation Level Closer Together

CDS Features

Semantically Rich Data-Models
Domain specific languages (DDL, QL &  DCL) Declarative, close to conceptual thinking

CDS is completely based on SQL
‘Standard SQL’ features directly available like joins, unions, build-in functions

Fully Compatible with Any DB
Generated and managed SQL Views Modern Open SQL

Common Basis for Domain-Specific
Frameworks e.g. UI, Analytics, Odata, BW,… @AnalyticsDetails.aggregationBehaviour: SUM

Built-in Functions and Code Pushdown
The Table Functions for Scenarios Rich Set of Built-in SQL Functions

On model level thru extensions
On meta-model level thru annotations

CDS Views Compared to ABAP Dictionary Views

Define a CDS View

CDS View Entity (s4hcds_Booking)
• Carries more semantics than SQL View
• Can be consumed by Open SQL
• Defined using annotation (@AbapCatalog.sqlViewName)
• Generated on activation of CDS view
• Representation on Database

Note: After activating the CDS View automatically in backend SQL view is generated.

define view s4hcds_Booking
as select from sbook



What do you think?

-1 Points
Upvote Downvote

Written by admin

Leave a Reply

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

What is SAP Hana? Software Components of SAP HANA ? Hardware & Software Innovations in SAP HANA ?

CDS Views Basic Syntaxes : – Select *, Select columns, Select distinct, WHERE clause, Table Aliases, Key Elements ,DDL Syntax Rules, CREATE SQL statement