Data Integration-Free and PayGo
- Data Integration-Free and PayGo
- All Products
ASK INFAPreview
Please log in to access Ask INFA.
ASK INFAPreview
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 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.
|
