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:
cds
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 |
cds
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.
(1) Concrete mappings to specific databases may differ.
(2) See also Best Practices.
(3) Not available on PostgreSQL and H2.
(4) Configurable through
cds.cdsc.defaultStringLength.(5) Configurable through
cds.cdsc.defaultBinaryLength.