Data Type Mapping for SAP NetWeaver
This section lists the mapping of data types for SAP NetWeaver (or SAP dictionary).
SAP NetWeaver as Source
When SAP NetWeaver is used as a source location, following is the mapping of data types in SAP NetWeaver (or SAP dictionary) to the corresponding Fivetran HVR repository data type.
SAP | Capture Support | Repository Data Type |
---|---|---|
d16r | Native | varbinary |
d16s | Native | varbinary |
d34r | Native | varbinary |
d34s | Native | varbinary |
raw | Native | varbinary |
accp | Native | nvarchar |
char | Native | nvarchar |
clnt | Native | nvarchar |
cuky | Native | nvarchar |
dats | Native | nvarchar / date* |
lang | Native | nvarchar |
numc | Native | nvarchar |
sstr | Native | nvarchar |
tims | Native | nvarchar |
unit | Native | nvarchar |
lchr | Native | nclob |
lraw | Native | blob |
rstr | Native | blob |
strg | Native | clob |
curr | Native | decimal(p,s) |
dec | Native | decimal(p,s) |
d16d | Native | decfloat |
d34d | Native | decfloat |
fltp | Native | float |
int1 | Native | integer1 |
int2 | Native | integer2 |
int4 | Native | integer4 |
prec | Native | integer2 |
quan | Native | decimal(p,s) |
varc | Not supported |
For SAP system on Db2 for i, Db2 for LUW, Oracle, SAP HANA, SAP NetWeaver (on Oracle or HANA), SQL Server, and Sybase ASE database if the option SAP Data Types Conversion is defined, dats
will be localized with the source DB's data type for date and then it will be mapped to the corresponding HVR repository data type. For example, if you have SAP on SQL Server, the dats
data type will be localized as SQL Server's date
type, which is then mapped to ansidate
in HVR repository data type.