Data Types for SAP

The following table lists the data type support for an SAP system.

For an SAP system, no data types are supported for column definition. Native ABAP SAP data types are mapped to similar data types for data retrieval only.

For data source specific information about the ABAP SAP data types, see the SAP system database documentation.

Data Types for SAP
ABAP SAP Data Type	Description	Data Type Returned
ACCP	Posting period.	CHAR(n) for non-Unicode SAP system; NCHAR(n) for Unicode SAP system
CHAR	Fixed-length character string.	CHAR(n) for non-Unicode SAP system; NCHAR(n) for Unicode SAP system
CLNT	Client field.	CHAR(n) for non-Unicode SAP system; NCHAR(n) for Unicode SAP system
CUKY	Currency key. Fields of this type are referenced by fields of type CURR.	CHAR(n) for non-Unicode SAP system; NCHAR(n) for Unicode SAP system
CURR	Currency field. Corresponds to the DEC field. Field refers to a field of type CUKY.	CHAR(n)
DATS	Date values.	DATE
DEC	Signed, fixed-point decimal number.	CHAR(n)
FLTP	Floating-point number.	DOUBLE
INT1	Very small signed, exact whole number.	TINYINT
INT2	Small signed, exact whole number.	SMALLINT
INT4	Regular signed, exact whole number.	INTEGER
LANG	Language key, which has its own field format for special functions. The conversion exit ISOLA converts the value to be displayed to that of the database and the opposite is true.	CHAR(n) for non-Unicode SAP system; NCHAR(n) for Unicode SAP system
LCHR	Fixed-length character string.	VARCHAR(n) for non-Unicode SAP system; NVARCHAR(n) for Unicode SAP system
LRAW	Uninterpreted varying-length byte string.	VARBINARY(n)
NUMC	Text string.	CHAR(n) for non-Unicode SAP system; NCHAR(n) for Unicode SAP system
PREC	The precision of a QUAN field.	CHAR(n)
QUAN	A quantity that corresponds to the DEC field.	CHAR(n)
RAW	An uninterpreted byte string.	BINARY
TIMS	Time value.	TIME(p)
UNIT	Units key and referenced by a QUAN data type.	CHAR(n) for non-Unicode SAP system; NCHAR(n) for Unicode SAP system
VARC	Varying-length character string data. As of SAP release 3.0, creating fields of this data type is no longer supported. Existing fields with this data type can be used, except in a WHERE condition in the SELECT statement.	VARCHAR(n) for non-Unicode SAS system; NVARCHAR(n) for Unicode SAP system