SAP Connector > SAP 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 and SAP IDocs and RFCs/BAPI Connector support 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
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
DF16_DEC
Decfloat16
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 in the following scenarios:
  • - When you read data from and write data to SAP tables
  • - When you configure SAP BAPI Connector as a business service within a mapping or a mapping task to integrate with SAP
  • - When you use SAP BAPI/RFC mapplets to integrate with SAP
DF34_DEC
Decfloat34
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 in the following scenarios:
  • - When you read data from and write data to SAP tables
  • - When you configure SAP BAPI Connector as a business service within a mapping or a mapping task to integrate with SAP
DF16_RAW
Double
Maximum of 16 positions with floating decimal. Decimal floating point number stored in binary format.
You can use the DF34_DEC data type in the following scenarios:
  • - When you read data from and write data to SAP tables
  • - When you configure SAP BAPI Connector as a business service within a mapping or a mapping task to integrate with SAP
  • - When you use SAP BAPI/RFC mapplets to integrate with SAP
DF34_RAW
Double
Maximum of 34 positions with floating decimal. Decimal floating point number stored in binary format.
You can use the DF34_DEC data type in the following scenarios:
  • - When you read data from and write data to SAP tables
  • - When you configure SAP BAPI Connector as a business service within a mapping or a mapping task to integrate with SAP
  • - When you use SAP BAPI/RFC mapplets to integrate with SAP
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 in the following scenarios:
  • - When you read data from and write data to SAP tables
  • - When you use IDocs to integrate with SAP
  • - When you use SAP BAPI/RFC mapplets to integrate with SAP
SSTRING
String
Small Character string.
You can use the SSTRING data type in the following scenarios:
  • - When you read data from and write data to SAP tables
  • - When you use SAP BAPI/RFC mapplets to integrate with SAP
STRING
String
Character string.
You can use the STRING data type in the following scenarios:
  • - When you read data from and write data to SAP tables
  • - When you use SAP BAPI/RFC mapplets to integrate with SAP
  • - When you use IDocs to integrate with SAP
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.
VARC
String
1 to 104,857,600 characters
Fixed-length or varying-length string.

Rules and guidelines for SSTRING, STRING, and RAWSTRING data types

When you import metadata that contains a SSTRING, STRING or RAWSTRING data type with precision that is not defined in SAP, you must set the SapTableReaderPrecision custom property for the Secure Agent and specify the required precision.
Perform the following steps to configure the custom property for the Secure Agent:
  1. 1. Log on to Informatica Intelligent Cloud Services.
  2. 2. Click Administrator.
  3. 3. In the navigation bar, select the Runtime Environments tab.
  4. 4. In the Runtime Environments page, select the Secure Agent used for running the SAP task.
  5. 5. Select Edit on the top right-hand corner.
  6. 6. In the System Configuration Details section, add a custom property.
  7. 7. Select Service as Data Integration Service, and then select Type as Tomcat.
  8. 8. In the Name field, specify SapTableReaderPrecision, and in the Value field, set the required precision.
  9. 9. Click Save.