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 Local Data Processing 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 / *
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 Local Data Processing 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 Local Data Processing Repository data type.