Concept card

CDS Views

As of 2026-07-24T14:00:00Z

Edited by Cédric-Olivier Mâry, sole editor and publication director — 27 years in the SAP ecosystem. How these pages are produced, and where automation is used.

What is CDS Views?

CDS views are the bridge layer between S/4HANA business logic and every analytics consumer — three view types (basic, composite, consumption) draw the line between 'S/4 application' and 'analytics platform'.

What it is

Core Data Services, shortened to CDS, is SAP's declarative modelling layer for defining semantically rich views directly on the HANA database inside S/4HANA. Instead of writing procedural ABAP loops or hand-tuned SQL, a developer writes a compact DDL statement that describes what a view should expose — fields, associations, currency and quantity semantics, authorisation rules — and HANA compiles that declaration into an optimised database view. For anyone doing SAP analytics work, CDS is not an optional skill to pick up later; it is the connective tissue between S/4HANA's transactional world and every downstream consumer, from Datasphere and SAC to Joule and third-party BI tools. Most extraction logic a consultant touches on a modern S/4 engagement is written, or should be written, as a CDS view.

Why it matters

Consumption CDS views carry the @Analytics and @VDM annotations that Datasphere reads to auto-build compatible Analytic Models — get the annotations wrong and the model build breaks.
Composite views are where business semantics (currency conversion, time filters) actually live — misplacing that logic at the wrong layer creates rework later.
CDS view authoring is daily-bread skill: it's where most extraction logic and most consumption-layer definitions live in a real S/4 estate.

Key points

Three view types: basic (over tables) · composite (with business logic) · consumption (analytics-exposed).
Annotation system is the differentiator: @Semantics, @Analytics, @VDM, @AccessControl, @ObjectModel.
ODP-CDS protocol bridges S/4 → Datasphere with metadata + extraction (50-100k rows/sec).
Five canonical patterns: extract · currency convert · hierarchy · auth push-down · embedded analytics.
CDS for 'what an S/4 record means'; Datasphere SQL for 'how sources combine for analytics'.
Authorisation push-down via @AccessControl; or Datasphere DAC at catalog — pick one, don't stack.
Three-layer pattern (basic → composite → consumption); avoid 3+ deep nesting.
S/4 release-management dependency: CDS changes follow S/4 transports (2-4 week cycle).
CDS Views is mastered only when it changes a named buyer decision.
Start with the semantic contract and control model before demonstrating the tool.

Terms used on this page

CDS (Core Data Services): SAP's declarative DDL framework — typed views with associations, annotations, authorisations, exposure. Sits on HANA SQL.
Annotation: Inline metadata declaration decorating fields/views with semantics (@Semantics, @Analytics, @VDM, @AccessControl, @ObjectModel).
ODP-CDS: Extraction protocol bridging S/4 (CDS views) to Datasphere. Reads CDS annotations + creates compatible Analytic Models.
VDM (Virtual Data Model): SAP's hierarchical CDS view organisation — basic → composite → consumption. Each layer has annotation-defined role.
@Analytics dataCategory: Annotation marking a CDS view's analytics role (#FACT, #DIMENSION, #AGGREGATIONLEVEL). Drives Datasphere AM auto-creation.
CURRENCY_CONVERSION: Standard CDS function using TCURR/TCURX delivered tables for S/4-native currency conversion. Used inline in CDS view.
@AccessControl: Annotation enabling S/4-side authorisation push-down. Calling user must have S/4 role; reaches Datasphere consumers via identity propagation.
Embedded analytics: Pattern of exposing CDS views directly to SAC via OData, bypassing Datasphere. For simple operational reporting only.

Sources

Full card available to members. What the full card adds: the full decision framework · the SAP vs Snowflake / Databricks / Fabric comparison · the common pitfalls and their fix · the cheat sheet · the architecture schemas · the code blocks · the facts worth quoting.

Open in the app →