Supported data types
The table below shows the SAP OData source data types that are supported when using Qlik Replicate and the default mapping to the Qlik Replicate data types.
For information on how the data type is mapped to the target, see the chapter for the target endpoint you are using.
For additional information about Qlik Replicate data types, see Replicate data types.
| ABAP Data Type | Description | OData service data type | Comments | Replicate data type |
|---|---|---|---|---|
| ACCP | Posting period YYYYMM | EDM.STRING | WSTRING | |
| CHAR | Character string | EDM.STRING | WSTRING | |
| CUKY | Currency key, referenced by CURR fields | EDM.STRING |
For currency and unit of measure, the SAP NetWeaver Gateway framework always uses the type conversions (methods for outbound and inbound flow of CL_GDT_CONVERSION). Unit of measure and currency conversion always use the ISO code, as opposed to the desired unit or currency. For more information, see SAP notes 1893788 and 3082462. |
WSTRING |
| CURR | Currency field, stored as DEC | EDM.STRING | NUMERIC | |
| DATS | Date field (YYYYMMDD), stored as CHAR(8) |
EDM.DATETIME Information noteThere is no EDM.DATE data type. Specify zeros for the time.
|
See SAP note 3315021 | DATETIME |
| DATN | Date in format YYYMMDD (native HANA DATE) |
EDM.DATETIME Information note There is no EDM.DATE data type. Specify zeros for the time.
|
DATETIME | |
| DEC | Packed number |
EDM.DECIMAL |
NUMERIC | |
| FLTP | Floating point number, accurate to 8 bytes | EDM.DOUBLE | See SAP note 3250756 | REAL8 |
| INT1 | 1-byte integer, integer number <= 255 | EDM.INT32 | INT4 | |
| INT2 | 2-byte integer, only for length field before LCHR or LRAW | EDM.INT32 | INT4 | |
| INT4 | 4-byte integer, integer number with sign | EDM.INT32 | INT4 | |
| INT8 | 8-byte integer | EDM.INT64 | See SAP notes 3396326 and 3569859 | INT8 |
| LANG | Language key | EDM.STRING | WSTRING | |
| NUMC | Character string with digits only | EDM.STRING | WSTRING | |
| QUAN | Quantity field, points to a unit field with format UNIT | EDM.DECIMAL | NUMERIC | |
| RAW | Uninterpreted sequence of bytes | EDM.STRING | WSTRING | |
| SSTR | Short character string of variable ength | EDM.STRING | WSTRING | |
| STRG | Character string of variable ength | EDM.STRING | WSTRING | |
| TIMS | Time field (hhmmss), stored as CHAR(6) | EDM.TIME | TIME | |
| TZNTSTMPL | EDM.DATETIMEOFFSET | |||
| UNIT | Unit key for QUAN fields | EDM.STRING |
For currency and unit of measure, the SAP NetWeaver Gateway framework always uses the type conversions (methods for outbound and inbound flow of CL_GDT_CONVERSION). Unit of measure and currency conversion always use the ISO code, as opposed to the desired unit or currency. For more information, see SAP notes 1893788 and 3082462. |
WSTRING |
| VARC | Long character string. Not supported from rel. 3.0. | EDM.STRING | WSTRING |
Unsupported data types
- Decfloat34 - See SAP note 1574568
- DECFLOAT16 - See SAP note 1574568