SAP LOGEXP NUMERIC documentation, setup help and example usage

ARTICLE

rel_exp - Comparing Numeric Data Types
The following tables show the comparison types
for comparisons between numeric data types and other data types. If the type of an operand is not the same as the comparison type, then it is converted to this type.

Note
If a decimal floating point number is involved in a comparison, the comparison is always made with the type decfloat34 .

Comparisons with Numeric Data Types
- decfloat34 decfloat16 f p
int8 i s b
decfloat34 decfloat34 decfloat34 decfloat34
decfloat34
decfloat34 decfloat34 decfloat34 decfloat34
decfloat16 decfloat34 decfloat34 decfloat34
decfloat34
decfloat34 decfloat34 decfloat34 decfloat34
f decfloat34 decfloat34 f f
f f f f
p decfloat34 decfloat34 f p
p p p p
int8 decfloat34 decfloat34 f p
int8 int8 int8 int8
i decfloat34 decfloat34 f p
int8 i i i
s decfloat34 decfloat34 f p
int8 i s s
b decfloat34 decfloat34 f p
int8 i s b
Value Ranges and Length Adjustments

When two operands with data type p are compared, numbers with more than 31 decimal places are edited internally to ensure that there is no overflow.

When two operands with data type p but with different lengths are compared, the shorter operand is converted

to the length of the longer operand.

When two operands with data type p but with different numbers of decimal places are compared, the operand with fewer decimal places is converted to a number with the same number of decimal places as the other operand.

When an operand with type p is compared with an operand with type

int8 , i , s , or b , the comparison type p has 31 decimal places and the number of decimal places of the operand of type p .
Wenn der Wert eines Operands vom Typ int8 nicht in den
Wertebereich eines Vergleichstyps p passt, wird die Ausnahme
intern abgefangen und der Vergleich liefert das richtige Ergebnis.
INCLUDE ABENCOMPARE_LENGTH_OF_P OBJECT DOKU ID SD

Comparisons with Character-Like Data Types
- decfloat34 decfloat16 f p
int8 i s b
d , t decfloat34 decfloat34 f p
int8 i i i
string , c , n decfloat34 decfloat34 f p
int8. i i i

Comparisons with Byte-Like Data Types
- decfloat34 decfloat16 f p
int8 i , s , b
xstring , x decfloat34 decfloat34 f
p
int8 i

Note
When converting byte-like data types to numeric types, note that all bytes are ignored except for the final four.