The Oracle-specific section of the Native SQL documentation deals with combinations of ABAP data types and column types of an Oracle table. It describes in detail the type conversions used for each type combination. The abbreviations introduced in the general description, such as [rtrunc] are used.
The list is divided roughly into the two data transfer directions:
Each description assumes that the starting value is a permitted value for the corresponding type. Cases where invalid bit patterns are created in an ABAP field using a FIELD-SYMBOL will not be taken into account.
The following index supports direct entry using the type of the initial value.
This description is valid for Oracle 8.0.4 and SAP Release 4.5A.
Insert / ABAP-Data Type
Character C(n)
Numeric Text N(n)
Packed Number P(m,d)
Integer I
Float F
Date D
Time T
Hexadecimal X(n)
Select / Database Column Type
Varchar2
Char
Long
Number (x)
Number (x,y)
Float
Date
Raw
Long Raw
Rowid
(A) The following applies to the database column type number(x,y), including the case y < 0:
ABAP Data Type: Character C(n)
Data value width: String length without trailing spaces
Database column type |
Case (notes) |
Result |
varchar2 (z) |
ABAP data value width > 4000 |
1461 |
ABAP field width (n) > database column width (z) ABAP data value width > database column width ABAP data value width <= database column width |
1401 ok |
|
ABAP field width (n) <= database column width (z) |
ok |
|
char (z) |
ABAP data value width > 4000 |
1461 |
ABAP field width (n) > database column width (z) ABAP data value width > database column width ABAP data value width >= database column width |
1401 ok |
|
ABAP field width (n) <= database column width (z) |
ok |
|
long |
ok |
|
number (z) |
ABAP data value is non-numeric |
1722 |
Loss of figures before decimal point in conversion |
1438 |
|
ABAP data value contains decimal places |
[round] |
|
ABAP data value width <= database column width (z) [ data value width: Number of positions before comma ] |
ok / [round] |
|
number (z,y) |
ABAP data value is non-numeric |
1722 |
Loss of significant figures (see (A)). |
1438 |
|
Loss of non-significant figures (see (A)). |
[round] |
|
ABAP data value width <= database column width (z) [ data value width: Number of significant positions (see (A)) ] |
ok / [round] |
|
float |
ABAP data value is non-numeric |
1722 |
ABAP data value not in interval ] -10 126 , 10 126 |
1426 |
|
ABAP data value in interval ] -10-130 , 10-130 [ [ Database data value rounded to 0 ] |
[0] |
|
ABAP data value in interval ] -10 126 , 10 126 [ [ 38th place is rounded, filled with zeros from the right ] |
ok / [0] / [round] |
|
date(9) |
ABAP data value has an invalid database date format |
1861 |
ABAP date value has a valid database date format [ 10-Jan-97 ] |
ok |
|
raw (z) |
ABAP data value width > 4000 |
1461 |
ABAP data value has an invalid hexadecimal format [ Valid values: 0-9, A-F, a-f; uppercase/lowercase are equal in conversion ] |
1465 |
|
ABAP field width (n) > database column width (n>2z) ABAP data value width > database column width ABAP data value width <= database column width [ If the data value width has an odd-numbered length, a zero is added at the left ] |
1401 ok |
|
ABAP data value width (n) <= database column width (n<=2z) [ If the data value width has an odd-numbered length, a zero is added at the left ] |
ok |
|
long raw |
ABAP data value width > 4000 |
1461 |
ABAP data value has an invalid hexadecimal format [ Valid values: 0-9, A-F, a-f; uppercase/lowercase are equal in conversion ] |
1465 |
|
ABAP data value width <= 4000 |
ok |
ABAP Data Type: Numeric Text N(n)
Data value width: Number of digits without leading zeros
Database column type |
Case (notes) |
Result |
varchar2 (z) |
Data value width > 4000 |
1461 |
ABAP field width (n) > database column width (z) |
1401 |
|
ABAP field width (n) <= database column width (z) |
ok |
|
char (z) |
Data value width > 4000 |
1461 |
ABAP field width (n) > database column width (z) |
1401 |
|
ABAP field width (n) <= database column width (z) |
ok |
|
long |
ok |
|
number (z) |
ABAP field width (n) > database column width (z) ABAP data value width > database column width ABAP data value width <= database column width [ leading zeros truncated ] |
1438 ok / [ltrunc] |
ABAP field width (n) = database column width (z) ABAP data value width <= database column width [ leading zeros truncated ] |
ok / [ltrunc] |
|
ABAP field width (n) < database column width (z) |
ok |
|
number (x,y) (z=x-y) |
Loss of significant figures (see (A)). |
1438 |
ABAP data value width <= database column width (z) [ leading zeros truncated ] |
ok / [ltrunc] |
|
float |
ABAP data value >= 10 126 |
1426 |
ABAP data value < 10 126 [ [ 38th place is rounded, filled with zeros from the right ] |
ok / [round] |
|
date |
1861 |
|
raw (z) |
ABAP field width (n) > database column width (n>2z) |
1401 |
ABAP data value width (n) <= database column width (n<=2z) [ If the data value width has an odd-numbered length, a zero is added at the left ] |
ok |
|
long raw |
Data value width > 4000 |
1461 |
Data value width <= 4000 |
ok |
ABAP Data Type: Packed Number P(m,d)
m= bytes, d = decimal places
Data value width (n): Number of digits without leading zeros, n<=2m-1; n is increased by one for each of decimal point and minus sign.
Database column type |
Case (notes) |
Result |
varchar2 (z) |
ABAP data value width (n) < database column width (z) |
1401 |
ABAP data value width (n) <= database column width (z) |
ok |
|
char (z) |
ABAP data value width (n) < database column width (z) |
1401 |
ABAP data value width (n) <= database column width (z) |
ok |
|
long |
ok |
|
number (z) |
Loss of figures before decimal point in conversion |
1438 |
ABAP data value contains decimal places |
[round] |
|
ABAP data value width (n) <= database column width (z) [ data value width: Number of positions before comma ] |
ok / [round] |
|
number (x,y) (z=x-y) |
Loss of significant figures (see (A)). |
1438 |
Loss of non-significant figures (see (A)). |
[round] |
|
ABAP data value width <= database column width (z) [ data value width: Number of significant positions (see (A)) ] |
ok / [round] |
|
float |
ok |
|
date |
932 |
|
raw |
932 |
|
long raw |
932 |
ABAP Data Type: Integer
Data value width: Number of digits without leading zeros; n is increased by one if there is a minus sign.
Database column type |
Case (notes) |
Result |
varchar2 (z) |
ABAP data value width > database column width (z) |
1401 |
ABAP data value width <= database column width (z) |
ok |
|
char (z) |
ABAP data value width > database column width (z) |
1401 |
ABAP data value width <= database column width (z) |
ok |
|
long |
ok |
|
number (z) |
ABAP data value width > Database column width (z) [ data value width: Number of digits ] |
1438 |
ABAP data value width <= Database column width (z) [ data value width: Number of digits ] |
ok |
|
number (x,y) (z=x-y) |
Loss of significant figures (see (A)). |
1438 |
Loss of non-significant figures (see (A)). |
[round] |
|
ABAP data value width <= database column width (z) [ data value width: Number of significant positions (see (A)) ] |
ok / [round] |
|
float |
ok |
|
date |
932 |
|
raw |
932 |
|
long raw |
932 |
ABAP Data Type: Float
Inaccuracies can occur with any conversions involving floating point numbers.
Data value width: Number of digits without leading zeros; n is increased by one for each of decimal point and minus sign.
Database column type |
Case (notes) |
Result |
varchar2 (z) |
ABAP data value width > database column width (z) |
1401 |
ABAP data value width <= database column width (z) |
ok |
|
char (z) |
ABAP data value width > database column width (z) |
1401 |
ABAP data value width <= database column width (z) |
ok |
|
long |
ok |
|
number (z) |
ABAP data value width > database column width (z) [ data value width: Number of positions before comma ] |
1438 |
ABAP data value contains decimal places |
[round] |
|
ABAP data value width <= database column width (z) [ data value width: Number of positions before comma ] |
ok / [round] |
|
number (x,y) (z=x-y) |
Loss of significant figures (see (A)). |
1438 |
Loss of non-significant figures (see (A)). |
[round] |
|
ABAP data value width <= database column width (z) [ data value width: Number of significant positions (see (A)) ] |
ok / [round] |
|
float |
ABAP data value not in interval ] -10 126 , 10 126 |
1426 |
ABAP data value in interval ] -10-130 , 10-130 [ [ Database data value rounded to 0 ] |
[0] |
|
ABAP data value not in interval ] -10 126 , 10 126 [ |
ok / [0] |
|
date |
932 |
|
raw |
932 |
|
long raw |
932 |
ABAP Data Type: Date D(8)
Data value width = 8 (fixed)
Database column type |
Case (notes) |
Result |
varchar2 (z) |
ABAP data value width (8) > database column width (z) |
1401 |
ABAP data value width (8) <= database column width (z) |
ok |
|
char (z) |
ABAP data value width (8) > database column width (z) |
1401 |
ABAP data value width (8) <= database column width (z) |
ok |
|
long |
ok |
|
number (z) |
ABAP data value is non-numeric |
1722 |
ABAP data value width (8) > database column width (z) |
1438 |
|
ABAP data value width (8) <= database column width (z) |
ok |
|
number (x,y) (z=x-y) |
ABAP data value is non-numeric |
1722 |
ABAP data value width (8) > database column width (z) |
1438 |
|
ABAP data value width (8) <= database column width (z) |
ok |
|
float |
ABAP data value is non-numeric |
1722 |
ABAP data value is numeric |
ok |
|
date |
1861 |
|
raw (z) |
ABAP data value has an invalid hexadecimal format [ Valid values: 0-9, A-F, a-f; uppercase/lowercase are equal in conversion ] |
1465 |
ABAP data value width (8) > database column width (4>z) |
1401 |
|
ABAP data value width (8) <= database column width (4<=z) |
ok |
|
long raw |
ABAP data value has an invalid hexadecimal format [ Valid values: 0-9, A-F, a-f; uppercase/lowercase are equal in conversion ] |
1465 |
ABAP data value has a valid hexadecimal format |
ok |
ABAP Data Type: Date T(6)
Data value width = 6 (fixed)
Database column type |
Case (notes) |
Result |
varchar2 (z) |
ABAP data value width (6) > database column width (z) |
1401 |
ABAP data value width (6) <= database column width (z) |
ok |
|
char (z) |
ABAP data value width (6) > database column width (z) |
1401 |
ABAP data value width (6) <= database column width (z) |
ok |
|
long |
ok |
|
number (z) |
ABAP data value is non-numeric |
1722 |
ABAP data value width (6) > database column width (z) |
1438 |
|
ABAP data value width (6) <= database column width (z) |
ok |
|
number (x,y) (z=x-y) |
ABAP data value is non-numeric |
1722 |
ABAP data value width (6) > database column width (z) |
1438 |
|
ABAP data value width (6) <= database column width (z) |
ok |
|
float |
ABAP data value is non-numeric |
1722 |
ABAP data value is numeric |
ok |
|
date |
1861 |
|
raw (z) |
ABAP data value has an invalid database raw format [ Valid values: 0-9, A-F, a-f; uppercase/lowercase are equal in conversion ] |
1465 |
ABAP data value width (6) > database column width (3>z) |
1401 |
|
ABAP data value width (6) <= database column width (3<=z) |
ok |
|
long raw |
ABAP data value has an invalid database raw format [ Valid values: 0-9, A-F, a-f; uppercase/lowercase are equal in conversion ] |
1465 |
ABAP data value has a valid hexadecimal format |
ok |
ABAP Data Type: Hexadecimal X(n)
Data value width: Number of hexadecimal digits without trailing zeros
Database column type |
Case (notes) |
Result |
varchar2 (z) |
n > 4000 |
1461 |
ABAP field width (2n) > database column width (z), (2n > z) |
1401 |
|
ABAP field width 2n = 8000, database column width = 4000 |
[rtrunc ½] |
|
ABAP field width (2n) <= database column width (z), (2n <= z) |
ok |
|
char (z) |
ABAP field width (2n) > database column width (z), (2n > z) |
1401 |
ABAP field width (2n) <= database column width (z), (2n <= z) |
ok |
|
long |
n > 4000 |
1461 |
n <= 4000 |
[rtrunc ½] |
|
number (z) |
932 |
|
number (z,y) |
932 |
|
float |
932 |
|
date |
932 |
|
raw (z) |
n > 4000 |
1461 |
ABAP field width (n) > database column width (z), (n>z) |
1401 |
|
ABAP field width (n)<= database column width (z), (n<=z) |
ok |
|
long raw |
n > 4000 |
[rtrunc] |
n < 4000 |
ok |
(B) ABAP Data Types: Date, Time
Converting a database value into an ABAP date or time field is like converting it into an ABAP character field with length 8 or 6 respectively. It is technically possible to convert an invalid format, but this returns an ABAP field value with an invalid format, which you cannot usefully use. Conversions of this kind are indicated in the table with [ok].
Conversion of database data values to
ABAP date format require the form: YYYYMMDD.
ABAP time format require the form: HHMMSS.
(C) ABAP Data Type: Numeric Text
Conversions into the ABAP type numeric text N(n) behave like conversions into an ABAP character field C(n), that is, the field contents are left-justified and filled with trailing spaces.This is contrary to the numeric text definition, according to which a numeric text field may only contain digits, and is filled with leading zeros. The numeric text field may contain a string with an invalid numeric text format following the conversion. Conversions of this kind are indicated in the table with [ok].
(D) ABAP Data Type: Hexadecimal
If the data value width is less than the field width, a result string is transferred (if the data value contains an odd number of characters, a leading zero is added). The rest of the field length is not filled with trailing zeros, but with undefined values.
Database Column Type: varchar2 (z)
Data value width: String length (trailing spaces are not saved)
ABAP Data type |
Case (notes) |
Result |
Character C(n) |
Database column width (z) > ABAP field width (n) Database data value width > ABAP field width Database data value width <= ABAP field width |
[rtrunc] ok |
Database column width (z) <= ABAP field width (n) |
ok |
|
Numeric text (N(n), (see(C)) |
[ Conversion as for character fields left-justified, filled with trailing spaces ] |
[ok] |
Packed Number P(m,d) (n=2m-1) |
Database data value is non-numeric |
1722 |
Loss of figures before decimal point in conversion |
[null] |
|
Loss of decimal places in conversion |
[rtrunc] |
|
Database data value width <= ABAP field width (n-d) [ Data value width/ field width: Number of positions before comma ] |
ok / [rtrunc] |
|
Integer I |
Database data value is non-numeric |
1722 |
ABAP data value not in interval ] -2 31 , 2 31 [ |
1455 |
|
Database data value contains decimal places |
[rtrunc] |
|
Database data value in interval ] -231, 2 31 [ |
ok / [rtrunc] |
|
Float F |
Database data value is non-numeric |
1722 |
Database data value >= 10 126 [ Result is max. database float value (1E+126) or max. ABAP float value (1.979E+308) ] |
[undef] |
|
Database data value <= -10 126 [ Result is zero or min. ABAP float value (-1.797E+308) ] |
[undef] |
|
Database data value in interval ] -10-130 , 10-130 [ [ Result rounded to 0 ] |
[0] |
|
Truncation in conversion [ Accuracy in floating point limited to approx. 15 decimal places ] |
[round] |
|
Database data value in interval ] -10 126 , 10 126 [ [ Possible inaccuracies in conversion ] |
ok / [0] / [round] |
|
Date D(8) (see (B)) |
Database column width (z) > ABAP field width (8) Database data value width > ABAP field width Database data value width <= ABAP field width |
[rtrunc] [ok] |
Database column width (z) <= ABAP field width (8) |
[ok] |
|
Time T(6) (see (B)) |
Database column width (z) > ABAP field width (6) Database data value width > ABAP field width Database data value width <= ABAP field width |
[rtrunc] [ok] |
Database column width (z) <= ABAP field width (6) |
[ok] |
|
Hexadecimal X(n) (see (D)) |
Database data value has an invalid hexadecimal format [ Valid values: 0-9, A-F, a-f; uppercase/lowercase are equal in conversion ] |
1465 |
Database data value width (x) > ABAP field width, (x <= z, x > 2n) Database data value width (x) = ABAP field width, (x <= z, x = 2n) Database data value width (x) < ABAP field width, (x <= z, x < 2n) [ Filled with trailing undefined values ] |
[rtrunc] ok [undef] |
Database Column Type: char (z)
Data value width: String length (trailing spaces are not saved)
ABAP Data type |
Case (notes) |
Result |
Character C(n) |
Database column width (z) > ABAP field width (n) Database data value width > ABAP field width Database data value width <= ABAP field width |
[rtrunc] ok |
Database column width (z) <= ABAP field width (n) |
ok |
|
Numeric text (N(n), (see(C)) |
[ Conversion as for character fields left-justified, filled with trailing spaces ] |
[ok] |
Packed Number P(m,d) (n=2m-1) |
Database data value is non-numeric |
1722 |
Loss of figures before decimal point in conversion |
[null] |
|
Loss of decimal places in conversion |
[rtrunc] |
|
Database data value width <= ABAP field width (n-d) [ Data value width/ field width: Number of positions before comma ] |
ok / [rtrunc] |
|
Integer I |
Database data value is non-numeric |
1722 |
ABAP data value not in interval ] -2 31 , 2 31 [ |
1455 |
|
Database data value contains decimal places |
[rtrunc] |
|
Database data value in interval ] -231, 2 31 [ |
ok / [rtrunc] |
|
Float F |
Database data value is non-numeric |
1722 |
Database data value >= 10 126 [ Result is max. database float value (1E+126) or max. ABAP float value (1.979E+308) ] |
[undef] |
|
Database data value <= -10 126 [ Result is zero or min. ABAP float value (-1.797E+308) ] |
[undef] |
|
Database data value in interval ] -10-130 , 10-130 [ [ Result rounded to 0 ] |
[0] |
|
Truncation in conversion [ Accuracy in floating point limited to approx. 15 decimal places ] |
[round] |
|
Database data value in interval ] -10 126 , 10 126 [ [ Possible inaccuracies in conversion ] |
ok / [0] / [round] |
|
Date D(8) (see (B)) |
Database column width (z) > ABAP field width (8) Database data value width > ABAP field width Database data value width <= ABAP field width |
[rtrunc] [ok] |
Database column width (z) <= ABAP field width (8) |
[ok] |
|
Time T(6) (see (B)) |
Database column width (z) > ABAP field width (6) Database data value width > ABAP field width Database data value width <= ABAP field width |
[rtrunc] [ok] |
Database column width (z) <= ABAP field width (6) |
[ok] |
|
Hexadecimal X(n) (see (D)) |
Database data value has an invalid hexadecimal format [ Valid values: 0-9, A-F, a-f; uppercase/lowercase are equal in conversion ] |
1465 |
Database column width (z) > ABAP field width (n), (z>2n) Database data value width (x) > ABAP field width, (x <= z, x > 2n) Database data value width (x) <= ABAP field width, (x <= z, x <= 2n) |
[rtrunc] 1465 |
|
Database column width (z) = ABAP field width(n), (z=2n) Database data value width (x) = ABAP field width, (x <= z, x = 2n) Database data value width (x) < ABAP field width, (x <= z, x < 2n) |
ok 1465 |
|
Database column width (z) < ABAP field width (n), (z <= 2n) [ Filled with trailing undefined values ] |
[undef] |
Database Column Type: long
Data value width: String length (trailing spaces are not saved)
ABAP Data type |
Case (notes) |
Result |
Character C(n) |
Database data value width > ABAP field width |
[rtrunc] |
Database data value width <= ABAP field width |
ok |
|
Numeric text (N(n), (see(C)) |
[ Conversion as for character fields left-justified, filled with trailing spaces ] |
[ok] |
Packed P(m,d) (n=2m-1) |
Data value is non-numeric |
1722 |
Loss of digits before the decimal point |
[null] |
|
Loss of digits after the decimal point |
[rtrunc] |
|
Database data value width <= ABAP field width (n-d) [ Data value width/ field width: Number of positions before comma ] |
ok / [rtrunc] |
|
Integer I |
[undef] |
|
Float F |
[undef] |
|
Date D(8) (see (B)) |
Database data value width > ABAP field width (8) |
[rtrunc] |
Database data value width <= ABAP field width (8) |
[ok] |
|
Time T(6) (see (B)) |
Database data value width > ABAP field width (6) |
[rtrunc] |
Database data value width <= ABAP field width (6) |
[ok] |
|
Hexadecimal X(n) (see (D)) |
[undef] |
Database Column Type: varchar2 (z)
Data value width: Number of digits without leading zeros; n is increased by one if there is a minus sign.
ABAP Data type |
Case (notes) |
Result |
Character C(n) |
Database data value width > ABAP field width (n) |
[rtrunc] |
Database data value width <= ABAP field width (n) |
ok |
|
Numeric text (N(n), (see(C)) |
[ Conversion as for character fields left-justified, filled with trailing spaces ] |
[ok] |
Packed P(m,d) (n=2m-1) |
Loss of figures before decimal point in conversion |
[null] |
Database data value width <= ABAP field width (n-d) [ Data value width/ field width: Number of positions before comma ] |
ok |
|
Integer I |
ABAP data value not in interval ] -2 31 , 2 31 [ |
1455 |
Database data value in interval ] -231, 2 31 [ |
ok |
|
Float F |
Truncation in conversion [ Accuracy in floating point limited to approx. 15 decimal places ] |
[round] |
Database data value Î ] -10 126 , 10 126 [ [ Possible inaccuracies in conversion ] |
ok / [round] |
|
Date D(8) (see (B)) |
Database column width (z) > ABAP field width (8) Database data value width > ABAP field width Database data value width <= ABAP field width |
[rtrunc] [ok] |
Database column width (z) <= ABAP field width (8) |
[ok] |
|
Time T(6) (see (B)) |
Database column width (z) > ABAP field width (6) Database data value width > ABAP field width Database data value width <= ABAP field width |
[rtrunc] [ok] |
Database column width (z) <= ABAP field width (6) |
[ok] |
|
Hexadecimal X(n) (see (D)) |
932 |
Database Column Type: number (z,y)
Data value width: Number of digits (z) without leading zeros; data value width is increased by one for each of decimal point and minus sign.
ABAP Data type |
Case (notes) |
Result |
Character C(n) |
Database data value width > ABAP field width (n) |
[rtrunc] |
Database data value width <= ABAP field width (n) |
ok |
|
Numeric text (N(n), (see(C)) |
[ Conversion as for character fields left-justified, filled with trailing spaces ] |
[ok] |
Packed P(m,d) (n=2m-1) |
Loss of significant figures (see (A)). |
[null] |
Loss of non-significant figures (see (A)). |
[rtrunc] |
|
Database data value width <= ABAP field width (n-d) [ Data value width/ field width: Number of positions before comma ] |
ok / [rtrunc] |
|
Integer I |
ABAP data value not in interval ] -2 31 , 2 31 [ |
1455 |
Database data value contains decimal places |
[rtrunc] |
|
Database data value in interval ] -231, 2 31 [ |
ok / [rtrunc] |
|
Float F |
Truncation in conversion [ Accuracy in floating point limited to approx. 15 decimal places ] |
[round] |
Database data value in interval ] -10 126 , 10 126 [ [ Possible inaccuracies in conversion ] |
ok / [round] |
|
Date D(8) (see (B)) |
Database column width (z) > ABAP field width (8), (z>=8) Database data value width > ABAP field width Database data value width <= ABAP field width |
[rtrunc] [ok] |
Database column width (z) <= ABAP field width (8), (z<8) |
[ok] |
|
Time T(6) (see (B)) |
Database column width (z) > ABAP field width (6), (z>=6) Database data value width > ABAP field width Database data value width <= ABAP field width |
[rtrunc] [ok] |
Database column width (z) <= ABAP field width (6), (z<6) |
[ok] |
|
Hexadecimal X(n) (see (D)) |
932 |
Database Column Type: float
Data value width: Number of digits without leading zeros; n is increased by one for each of decimal point and minus sign.
ABAP Data type |
Case (notes) |
Result |
Character C(n) |
Database data value width > ABAP field width (n) |
[rtrunc] |
Database data value width <= ABAP field width (n) |
ok |
|
Numeric text (N(n), (see(C)) |
[ Conversion as for character fields left-justified, filled with trailing spaces ] |
[ok] |
Packed P(m,d) (n=2m-1) |
Loss of figures before decimal point in conversion |
[null] |
Loss of decimal places in conversion |
[rtrunc] |
|
Database data value width <= ABAP field width (n-d) [ Data value width/ field width: Number of positions before comma ] |
ok / [rtrunc] |
|
Integer I |
ABAP data value not in interval ] -2 31 , 2 31 [ |
1455 |
Database data value contains decimal places |
[rtrunc] |
|
Database data value in interval ] -231, 2 31 [ |
ok / [rtrunc] |
|
Float F |
Truncation in conversion [ Accuracy in floating point limited to approx. 15 decimal places ] |
[round] |
Database data value in interval ] -10 126 , 10 126 [ [ Possible inaccuracies in conversion ] |
ok / [round] |
|
Date D(8) (see (B)) |
Database data value width > ABAP field width (8) |
[rtrunc] |
Database data value width <= ABAP field width (8) |
[ok] |
|
Time T(6) (see (B)) |
Database data value width > ABAP field width (6) |
[rtrunc] |
Database data value width <= ABAP field width (6) |
[ok] |
|
Hexadecimal X(n) (see (D)) |
932 |
Database Column Type: date(9)
Data value width = 9 (fixed)
ABAP Data type |
Case (notes) |
Result |
Character C(n) |
Database data value width (9) > ABAP field width (n), (n<9) |
[rtrunc] |
Database data value width (9) <= ABAP field width (n), (n>=9) |
ok |
|
Numeric text (N(n), (see(C)) |
[ Conversion as for character fields left-justified, filled with trailing spaces ] |
[ok] |
Packed P |
932 |
|
Integer I |
932 |
|
Float F |
932 |
|
Date D(8) (see (B)) |
ok / [rtrunc] |
|
Time T(6) (see (B)) |
ok / [rtrunc] |
|
Hexadecimal X(n) (see (D)) |
932 |
Database Column Type: raw(x)
Column width: z = 2x
Data value width: Number of hexadecimal digits without trailing zeros
ABAP Data type |
Case (notes) |
Result |
Character C(n) |
Database column width (z) > ABAP field width (n), (z>n) Database data value width > ABAP field width Database data value width <= ABAP field width |
[rtrunc] ok |
Database column width (z) <= ABAP field width (n), (z<=n) |
ok |
|
Numeric text (N(n), (see(C)) |
[ Conversion as for character fields left-justified, filled with trailing spaces ] |
[ok] |
Packed P |
932 |
|
Integer I |
932 |
|
Float F |
932 |
|
Date D(8) (see (B)) |
Database column width (z) > ABAP field width (8), (z>8) Database data value width > ABAP field width Database data value width <= ABAP field width |
[rtrunc] [ok] |
Database column width (z) <= ABAP field width (8), (z<=8) |
[ok] |
|
Time T(6) (see (B)) |
Database column width (z) > ABAP field width (6), (z<6) Database data value width > ABAP field width Database data value width <= ABAP field width |
[rtrunc] [ok] |
Database column width (z) <= ABAP field width (6), (z<=6) |
[ok] |
|
Hexadecimal X(n) (see (D)) |
Database data value width > ABAP field width Database data value width = ABAP field width Database column width < ABAP field width [ Filled with trailing undefined values ] |
[rtrunc] ok [undef] |
Database Column Type: long raw
Data value width: Number of hexadecimal digits without trailing zeros
ABAP Data type |
Case (notes) |
Result |
Character C(n) |
Database data value width <= ABAP field width |
ok |
Database data value width > ABAP field width |
[rtrunc] |
|
Numeric text (N(n), (see(C)) |
[ Conversion as for character fields left-justified, filled with trailing spaces ] |
[ok] |
Packed P |
932 |
|
Integer I |
932 |
|
Float F |
932 |
|
Date D(8) (see (B)) |
Database data value width > ABAP field width (8) |
[rtrunc] |
Database data value width <= ABAP field width (8) |
[ok] |
|
Time T(6) (see (B)) |
Database data value width > ABAP field width (6) |
[rtrunc] |
Database data value width <= ABAP field width (6) |
[ok] |
|
Hexadecimal X(n) (see (D)) |
Database data value width > ABAP field width (2n) |
[rtrunc] |
Database data value width = ABAP field width (2n) |
ok |
|
Database column width < ABAP field width (2n) [ Filled with trailing undefined values ] |
[undef] |
Database Column Type: rowid(18)
Data value width = 18 (fixed)
ABAP Data type |
Case (notes) |
Result |
Character C(n) |
Database data value width (18) > ABAP field width (n), (18 > 9) |
[rtrunc] |
Database data value width (18) <= ABAP field width (n), (18 <= 9) |
ok |
|
Numeric text (N(n), (see(C)) |
[ Conversion as for character fields left-justified, filled with trailing spaces ] |
[ok] |
Packed P |
932 |
|
Integer I |
932 |
|
Float F |
932 |
|
Date D(8) (see (B)) |
[undef] |
|
Time T(6) (see (B)) |
[undef] |
|
Hexadecimal X(n) (see (D)) |
932 |