Check Formula Syntax for Input Validations (SAP Library

Check Formula Syntax for Input Validations

Check formulas in input validation must have the following syntax:

<rel.expression> = <arith.expression><rel.operator><arith.expression>

Note the following:

You can use the operators listed below.
You can enter any number of logical relationships in a check formula.
In relational expressions, you can use variable X for the input value.
You must always use the decimal point for decimal numbers.
You can use variables to transfer numeric values of preceding process instructions to the check formula.
For more detailed information see:

Using Variables in Browser-Based PI Sheets

Using Variables in ABAP List-Based PI Sheets

In long formulas, you may use no more than 240 characters that can be separated in any number of lines.

Note that a blank character is automatically set at the end of each line. For this reason, make sure to write long number, variable names, or operators together in one line.

PPPI_VALIDATION_FORMULA x>50 AND x<100 OR
PPPI_VALIDATION_FORMULA x<200 AND x>150

Logical Operators

Meaning

AND

Both of the linked expressions have to be true.

OR

One of the linked expressions has to be true.

NOT

The expressions following the operator must not be true.

Relational Operators

Meaning

=

Equal to

<=

Less than or equal to

>=

Greater than or equal to

<>

Not equal to

><

Not equal to

<

Less than

>

Greater than

Arithmet. Operators

Meaning

+

Plus

-

Minus

*

Multiplied by

/

Divided by

DIV

Modulo division; division where the result is quoted as an integer

MOD

Remainder after modulo division

ABS

Absolute value

SIN

Sine

COS

Cosine

TAN

Tangent

LOG

Logarithm to base e

**

To the power of

EXP

Power to base e

SQRT

Square root

ROUND

Round to nearest integer

TRUNC

Cut off decimals

Logical Operators	Meaning
AND	Both of the linked expressions have to be true.
OR	One of the linked expressions has to be true.
NOT	The expressions following the operator must not be true.

Relational Operators	Meaning
=	Equal to
<=	Less than or equal to
>=	Greater than or equal to
<>	Not equal to
><	Not equal to
<	Less than
>	Greater than

Arithmet. Operators	Meaning
+	Plus
-	Minus
*	Multiplied by
/	Divided by
DIV	Modulo division; division where the result is quoted as an integer
MOD	Remainder after modulo division
ABS	Absolute value
SIN	Sine
COS	Cosine
TAN	Tangent
LOG	Logarithm to base e
**	To the power of
EXP	Power to base e
SQRT	Square root
ROUND	Round to nearest integer
TRUNC	Cut off decimals