Supported data types
The supported data types differ according to whether you are accessing SAP HANA directly or via SAP Application Server.
Supported data types when accessing SAP HANA directly
The following table shows the supported SAP HANA source data types and their default mapping to Replicate data types.
For information on how to view the data type that is mapped in the target, see the section for the target endpoint you are using.
For additional information about Replicate data types, see Replicate data types.
| SAP HANA data types | Replicate data types |
|---|---|
|
DATE |
DATE |
|
TIME |
TIME |
|
SECONDDATE |
DATETIME |
|
TIMESTAMP |
DATETIME |
|
TINYINT |
UINT1 |
|
SMALLINT |
INT2 |
|
INTEGER |
INT4 |
|
BIGINT |
INT8 |
|
DECIMAL (p,s) |
NUMERIC |
|
DECIMAL |
STRING |
|
SMALLDECIMAL |
STRING |
|
REAL |
REAL4 |
|
DOUBLE |
REAL8 |
| VARCHAR | STRING |
| NVARCHAR | WSTRING |
|
ALPHANUM |
STRING |
|
SHORTTEXT |
WSTRING |
|
VARBINARY |
BYTES |
|
BLOB |
BLOB |
|
CLOB |
CLOB |
|
NCLOB |
NCLOB |
|
TEXT |
NCLOB |
|
BOOLEAN |
UINT1 |
Unsupported data types
The following data types are not supported:
- ARRAY
- ST_GEOMETRY
- ST_POINT
Supported data types when accessing SAP HANA via SAP Application Server
The following table shows the supported data types and their default mapping to Replicate data types.
For information on how to view the data type that is mapped in the target, see the section for the target endpoint you are using.
For additional information about Replicate data types, see Replicate data types.
| ABAP TYPE | ABAP Type Description | SAP Type | Replicate Data Type |
|---|---|---|---|
|
h |
Table type |
- |
BYTES |
|
V |
Character string (old Dictionary type VARC) |
- |
STRING |
|
C |
Character string |
- |
STRING |
|
N |
Character string with only digits |
- |
STRING |
|
D |
Date (string: YYYYMMDD) |
- |
DATE |
|
T |
Time (string: HHMMSS) |
- |
TIME |
|
X |
Byte sequence |
INT4 (4-byte integer) |
I4 |
|
|
INT2 (2-byte integer) |
I2 | |
|
INT1 (1-byte integer) |
I1 | ||
|
ELSE |
If backend type is NUMERIC: NUMERIC If length = 0: BLOB If length > 0: BYTES |
||
|
I |
Integer number (4-byte integer with sign) |
- |
INT4 |
|
b |
2-byte integer |
- |
INT2 |
|
s |
1-byte integer |
- |
INT1 |
|
P |
Packed number |
- |
NUMERIC |
|
F |
Floating point number to accuracy of 8 bytes |
- |
R8 |
|
g |
Character string with variable length |
- |
STRING |
|
y |
Byte sequence with variable length |
- |
BLOB BYTES |
|
u |
Structured type, flat |
- |
BYTES |
|
v |
Structured type, deep |
- |
BYTES |
|
r |
Reference to class/interface |
- |
BYTES |
|
i |
Reference to data object |
- |
BYTES |
|
n |
Numeric text |
NUMC |
STRING |