Hana CDS Reference

PUBLIC

SAP HANA Platform 2.0 SPS 00

Document Version: 1.0 – 2016-11-30

SAP HANA Core Data Services (CDS) Reference

Content

1 Introduction to SAP HANA Core Data Services .....................................5

2 Getting Started with Core Data Services..........................................6

2.1 Developing Native SAP HANA Applications...........................................7

2.2 Roles and Permissions for XS Development..........................................9

3.1 CDS Editors................................................................30

CDS Text Editor...........................................................31

3.2 Create a CDS Document.......................................................33

CDS Documents..........................................................38

External Artifacts in CDS....................................................40

CDS Naming Conventions................................................... 42

CDS Namespaces.........................................................43

CDS Contexts............................................................44

CDS Annotations..........................................................47

CDS Comment Types...................................................... 56

SAP HANA to CDS Data-Type Mapping..........................................80

3.5 Create a User-Defined Structured Type in CDS.......................................81

CDS User-Defined Data Types................................................ 84

CDS Structured Type Definition............................................... 87

CDS Structured Types......................................................90

CDS Primitive Data Types................................................... 92

3.6 Create an Association in CDS................................................... 95

CDS Associations.........................................................98

CDS Association Syntax Options..............................................104

2

Spatial Types and Functions.................................................134

3.8 Modifications to CDS Artifacts..................................................135

3.9 Tutorial: Get Started with CDS..................................................139

3.10 Import Data with CDS Table-Import..............................................143

Data Provisioning Using Table Import.......................................... 146

Table-Import Configuration..................................................147

Table-Import Configuration-File Syntax.........................................149

Table-Import Configuration Error Messages......................................154

4 Creating the Data Persistence Artifacts in XS Advanced............................ 156

4.1 Create the Data Persistence Artifacts in XS Advanced.................................156

CDS Naming Conventions...................................................177

Accessing CDS Metadata in HDI.............................................. 178

CDS Catalog Reader API for HDI.............................................. 179

CDS Contexts in XS Advanced................................................186

CDS Comment Types......................................................191

CDS Extensions Artifacts................................................... 193

4.3 Create a CDS Access-Policy Document (XS Advanced)................................ 195

CDS Access Policies in XS Advanced...........................................197

4.4 Create a CDS Aspect (XS Advanced)............................................. 199

4.5 Create a CDS Role (XS Advanced)............................................... 201

CDS User-Defined Data Types in XS Advanced....................................228

CDS Structured Type Definition in XS Advanced...................................231

CDS Structured Types in XS Advanced.........................................234

CDS Primitive Data Types...................................................236

4.8 Create a CDS Association in XS Advanced......................................... 239

CDS Associations........................................................ 242

SAP HANA Core Data Services (CDS) Reference

4.9 Create a CDS View in XS Advanced.............................................. 255

CDS Views............................................................. 258

CDS View Syntax Options...................................................266

Spatial Types and Functions.................................................279

Services

This guide explains how to use Core Data Services (CDS) to build design-time data-persistence models in SAP

HANA Extended Application Services (SAP HANA XS) - for both XS classic and XS advanced models. The

data-persistence model is used to define the data to expose in response to client requests via HTTP, for

example, from an SAPUI5-based application.

The information in this guide is intended primarily for application and database developers and focuses on the

tasks the application and database developers most commonly need to perform when designing and creating

the data model, for example, creating tables, views. However, the SAP HANA Core Data Services (CDS)

Reference also includes additional information, too, for example, reference and conceptual.

Due to incompatible differences between the CDS syntax supported by SAP HANA XS Classic and SAP HANA

XS Advanced, the guide is split into the following sections:

SAP HANA Core Data Services (CDS) Reference