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:

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