How are data types mapped between SAP and dab Nexus?
With dab Nexus, some changes have been made to more closely match the extraction result in SQL Server to the SAP data types. This may break existing scripts specifically designed for the Exporter. The following table shows how the mapping is done:
SAP ABAP Data Type | dab:Exporter SQL data type | dab Nexus SQL data type |
C | NVARCHAR(2 * LENGTH) | NVARCHAR(LENGTH) |
P | NUMERIC(LENGTH, PRECISION) | NUMERIC(LENGTH, PRECISION) |
D | DATETIME | DATE |
F | NVARCHAR(22) | FLOAT |
T | NVARCHAR(6) | TIME |
