types.md

shorty	Built-in Types
synopsis	Find here a brief overview of the predefined types shipped with CDS.
status	released

Core / Built-in Types

The following table lists the built-in types available to all CDS models, and can be used to define entity elements or custom types as follows:

entity Books {
  key ID : UUID;
  title  : String(111);
  stock  : Integer;
  price  : Price;
}
type Price : Decimal;

These types are used to define the structure of entities and services, and are mapped to respective database types when the model is deployed.

CDS Type	Remarks	ANSI SQL (1)
UUID	CAP generates RFC 4122-compliant UUIDs (2)	NVARCHAR(36)
Boolean	Values: true, false, null, 0, 1	BOOLEAN
Integer	Same as Int32 by default	INTEGER
Int16	Signed 16-bit integer, range [ -215 ... +215 )	SMALLINT
Int32	Signed 32-bit integer, range [ -231 ... +231 )	INTEGER
Int64	Signed 64-bit integer, range [ -263 ... +263 )	BIGINT
UInt8	Unsigned 8-bit integer, range [ 0 ... 255 ]	TINYINT (3)
Decimal (prec, scale)	A decfloat type is used if arguments are omitted	DECIMAL
Double	Floating point with binary mantissa	DOUBLE
Date	e.g. 2022-12-31	DATE
Time	e.g. 24:59:59	TIME
DateTime	sec precision	TIMESTAMP
Timestamp	µs precision, with up to 7 fractional digits	TIMESTAMP
String (length)	Default length: 255; on HANA: 5000 (4)	NVARCHAR
Binary (length)	Default length: 255; on HANA: 5000 (5)	VARBINARY
LargeBinary	Unlimited data, usually streamed at runtime	BLOB
LargeString	Unlimited data, usually streamed at runtime	NCLOB
Map	Mapped to NCLOB for HANA.	JSON type
Vector (dimension )	Requires SAP HANA Cloud QRC 1/2024, or later	REAL_VECTOR

entity Books {
  key ID : UUID;
  title  : String(111);
  stock  : Integer;
  price  : Price;
}
type Price : Decimal;

These types are used to define the structure of entities and services, and are mapped to respective database types when the model is deployed.

⁽¹⁾ Concrete mappings to specific databases may differ.

⁽²⁾ See also Best Practices.

⁽³⁾ Not available on PostgreSQL and H2.

⁽⁴⁾ Configurable through cds.cdsc.defaultStringLength.

⁽⁵⁾ Configurable through cds.cdsc.defaultBinaryLength.

See also...

Additional Reuse Types and Aspects by @sap/cds/common {.learn-more}

Mapping to OData EDM types {.learn-more}

HANA-native Data Types{.learn-more}