SAP Table Connector > Data type reference > SAP and transformation data types
  

SAP and transformation data types

The following table lists the SAP data types that SAP Table Connector supports along with the corresponding transformation data types:
SAP Data Type
Transformation Data Type
Range for Transformation Data Type
ACCP
Date/time
Jan 1, 0001 A.D. to Dec 31, 9999 A.D.
CHAR
String
1 to 104,857,600 characters
Fixed-length or varying-length string.
CLNT
String
1 to 104,857,600 characters
Fixed-length or varying-length string.
CUKY
String
1 to 104,857,600 characters
Fixed-length or varying-length string.
CURR
Decimal
Precision 1 to 28 digits, scale 0 to 28
DATN
Date/time
Jan 1, 0001 A.D. to Dec 31, 9999 A.D. Precision to the nanosecond.
You can use the DATN data type when you read data from SAP tables.
DATS
Date/time
Jan 1, 0001 A.D. to Dec 31, 9999 A.D. Precision to the nanosecond.
DEC
Decimal
Precision 1 to 28 digits, scale 0 to 28
DECFLOAT16
Double
Precision 15, scale 0
You can use the DECFLOAT16 data type when you read data from SAP tables.
DECFLOAT34
Decimal
Precision 34, scale 0
You can use the DECFLOAT34 data type when you read data from SAP tables.
DF16_DEC
Decimal
Range of 1-15 and scaling of maximum 14. Decimal floating point number stored in BCD format.
You can use the DF16_DEC data type when you read data from SAP tables.
DF34_DEC
Decimal
Range of 1-31 and scaling of maximum 30. Decimal floating point number stored in BCD format.
You can use the DF34_DEC data type when you read data from SAP tables.
DF16_RAW
Double
Maximum of 16 positions with floating decimal. Decimal floating point number stored in binary format.
You can use the DF16_RAW data type when you read data from SAP tables.
DF34_RAW
Double
Maximum of 34 positions with floating decimal. Decimal floating point number stored in binary format.
You can use the DF34_RAW data type when you read data from SAP tables.
FLTP
Double
Precision 15, scale 0
INT1
Small Integer
Precision 5, scale 0
INT2
Small Integer
Precision 5, scale 0
INT4
Integer
Precision 10, scale 0
INT8
Int8
8-byte integer between -9,223,372,036,854,775,808 and +9,223,372,036,854,775,807. The length is set at 19 positions.
Use the INT8 data type when you read data from and write data to SAP tables.
LANG
String
1 to 104,857,600 characters
Fixed-length or varying-length string.
LCHR
String
1 to 104,857,600 characters
Fixed-length or varying-length string.
LRAW
Binary
Uninterrupted sequence of bytes with a maximum length of 255 positions.
NUMC
String
1 to 104,857,600 characters
Fixed-length or varying-length string.
PREC
Binary
Uninterrupted sequence of bytes with a maximum length of 255 positions.
QUAN
Decimal
Precision 1 to 28 digits, scale 0 to 28
RAW
Binary
Uninterrupted sequence of bytes with a maximum length of 255 positions.
RAWSTRING
Binary
Uninterrupted byte string.
You can use the RAWSTRING data type when you read data from SAP tables.
SSTRING
String
Small Character string.
You can use the SSTRING data type when you read data from SAP tables.
STRING
String
Character string.
You can use the STRING data type when you read data from SAP tables.
TIMN
Date/time
Jan 1, 0001 A.D. to Dec 31, 9999 A.D. Precision to the nanosecond.
You can use the TIMN data type when you read data from SAP tables.
TIMS
Date/time
Jan 1, 0001 A.D. to Dec 31, 9999 A.D. Precision to the nanosecond.
UNIT
String
1 to 104,857,600 characters
Fixed-length or varying-length string.
UTCL
Timestamp
Jan 1, 0001 A.D. to Dec 31, 9999 A.D. Precision to the nanosecond.
You can use the UTCL data type when you read data from SAP tables.
VARC
String
1 to 104,857,600 characters
Fixed-length or varying-length string.