Built-in Types

    The following built-in types are provided:

    CDS Type Arguments / Remarks SQL (4)
    UUID an opaque 36-characters string (1) NVARCHAR(36)
    Boolean   BOOLEAN
    Integer   INTEGER
    Integer64   BIGINT
    Decimal ( precision, scale ) (2) DECIMAL
    Double   DOUBLE
    Date   DATE
    Time   TIME
    DateTime sec precision TIMESTAMP
    Timestamp µs precision TIMESTAMP
    String ( length ) (3) NVARCHAR
    Binary ( length ) (3) VARBINARY
    LargeBinary   BLOB
    LargeString   NCLOB


    (1) At runtime, UUIDs are treated as opaque values and are, for example, not converted to lower case on input. UUIDs generated in the application are RFC 4122-compliant. See Don’t Interpret UUIDs! for details.

    (2) Arguments precision and scale are optional → if omitted a decfloat type is used

    (3) Argument length is optional → if omitted a default length is used

    (4) Mapping to ANSI SQL types are given for comparison. Note though, that you need to have the specification of your target database in mind when considering, for example, length restrictions.

    See also…

    Mapping to OData EDM types

    HANA-native Data Types

    Show/Hide Beta Features