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:
Is ee + 6. Adding 6 is the length in characters of sign_of_mantissa + mantissa_digit + character 'D' + sign_of exponent + 2-digit 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 |