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
Last updated: February 23, 2017