SAP HANA Datatype | Range | Transformation Datatype | Range |
|---|---|---|---|
Alphanum | Precision 1 to 127 | Nstring | 1 to 104,857,600 characters |
Bigint | -9,223,372,036,854,775,808 to 9,223,372,036,854,775,807 | Bigint | -9,223,372,036,854,775,808 to 9,223,372,036,854,775,807 Precision 19, scale 0 |
Bintext | - | String | Precision 32000 |
Boolean | True/False | Integer | Boolean (True/False) values, precision 10 |
Date | Jan 1, 0001 A.D. to Dec 31, 9999 A.D. Precision 10, scale 0 | Date/Time | Jan 1, 0001 A.D. to Dec 31, 9999 A.D. (precision to the nanosecond) |
Decimal (precision, scale) or Dec (p, s) | Precision 1 to 34 | Decimal | Precision 1 to 28, scale 0 to 28 For transformations that support precision up to 38 digits, the precision is 1 to 38 digits, and the scale is 0 to 38. For transformations that support precision up to 28 digits, the precision is 1 to 28 digits, and the scale is 0 to 28. If you specify the precision greater than the maximum number of digits, the Secure Agent converts decimal values to double in high precision mode. |
Double | Specifies a single-precision 64-bit floating-point number | Double | Precision 15 |
Float | Precision 1 to 53 | Double | Precision 15 |
Integer | -2,147,483,648 to 2,147,483,647 | Integer | -2,147,483,648 to 2,147,483,647 Precision 10, scale 0 |
Nvarchar | Precision 1 to 5000 | String | 1 to 104,857,600 characters |
Real | Specifies a single-precision 32-bit floating-point number | Double | Precision 7, scale 0 |
Seconddate | 0001-01-01 00:00:01 to 9999-12-31 24:00:00 | Date/Time | Jan 1, 0001 A.D. to Dec 31, 9999 A.D. (precision to the nanosecond) |
Shorttext | Specifies a variable-length character string, which supports text search and string search features | String | 1 to 104,857,600 characters |
Smalldecimal | Precision 1 to 16 | Decimal | Precision 1 to 28, scale 0 to 28 |
Smallint | -32,768 to 32,767 | Integer | Precision 5, scale 0 |
Text | Specifies a variable-length character string, which supports text search features | String | 1 to 104,857,600 characters |
Time | 24-hour time period | Date/Time | Jan 1, 0001 A.D. to Dec 31, 9999 A.D. (precision to the nanosecond) |
Timestamp | 0001-01-01 00:00:00.0000000 to 9999-12-31 23:59:59.9999999 | Date/Time | Jan 1, 0001 A.D. to Dec 31, 9999 A.D. (precision to the nanosecond) |
Tinyint | 0 to 255 | Integer | Precision 5, scale 0 |
Varchar | Precision 1 to 5000 | String | 1 to 104,857,600 characters |