SAP Data Type Support

The following table lists the SAP data types and notes how they are mapped to data types in the Master File.

SAP Data Type	SAP Length	SAP Decimals	Usage	Actual
ACCP	N	0	An	An
CHAR	N	0	An	An
CLNT	3	0	A3	A3
CUKY	N	0	An	An
CURR	n	p	P(n+2).p	P(n+1)/2
DATS * see note following chart for details	8	0	YYMD or DMYY	DATE
DEC	n	p	P(n+2).p	P(n+1)/2
FLTP ** see note following chart for details.	n	p	Dmm.eeE	D8
INT1	3	0	I3 (limited to 127)	I1
INT2	5	0	I4	I2
INT3	5	0	I4	I3
INT4	10	0	I10	I4
LANG	1	0	A1	A1
LCHR	N	n	not supported
LRAW	N	N	not supported
NUMC	N	0	An	An
PREC	N	N	not supported
QUAN	N	P	P(n+2).p	P(n+1)/2
RAW	N	N/A	A2n	A2n
STRING *** see note following chart for details	Maximum length 2GB	N/A	A80	A80
TIMS	6	0	A6	A6 (00:00:00)
VARC	N	0	An (<=255)	An (<=255)
UNIT	3	0	A3	A3

Note:

* Date usage (DATS) is dynamically determined based on the value of the country supplied in the general server configuration. Therefore, date presentations will vary by country.
**FLTP The value will be expressed as a floating point number with a mantissa and an exponent.

Dmm.eeE

where:

mm (mantissa): Is ee + 6. Adding 6 is the length in characters of sign_of_mantissa + mantissa_digit + character 'D' + sign_of exponent + 2-digit exponent.
ee (exponent): Is the number of SAP decimals -1 (SAP accounts for the decimal point in the count).

For example, the field UMREF in the table VBAP is a floating point number with 16 digits expressed as:

ee = 16 -1 =15. mm = 15 + 6 = 21.

FIELDNAME=VBAP_UMREF, ALIAS=UMREF, USAGE=D21.15E, ACTUAL=D8

*** STRING defines a variable character length sequence. If you need to adjust the length of the STRING, you can do so using the Web Console or Data Management Console Synonym Editor.

	WebFOCUS