Hierarchy
SAP_APPL (Software Component) Logistics and Accounting⤷
PP-BD-CAP (Application Component) Computer Aided Process Planning⤷
CEV (Package) R/3 Applic. development: PPS CAPP standard times calculation
Basic Data
| Data Element | FOTXT |
| Short Description | Formula string |
Data Type
| Category of Dictionary Type | D | Domain |
| Type of Object Referenced | No Information | |
| Domain / Name of Reference Type | CHAR79 | |
| Data Type | CHAR | Character String |
| Length | 79 | |
| Decimal Places | 0 | |
| Output Length | 79 | |
| Value Table |
Further Characteristics
| Search Help: Name | ||
| Search Help: Parameters | ||
| Parameter ID | ||
| Default Component name | ||
| Change document | ||
| No Input History | ||
| Basic direction is set to LTR | ||
| No BIDI Filtering |
Field Label
| Length | Field Label | |
| Short | 10 | Formula |
| Medium | 15 | Formula string |
| Long | 20 | Formula string |
| Heading | 55 | Formula string |
Documentation
Definition
Formula which can be used to calculate standard values.
Procedure
You can use the following operands in formulas:
Operand Examples Meaning
Floating point 3.12; 2.5E5; 31
constant
Variable/ A; ABC; ABC_DEF; E5
characteristic
Pi 3,1415...
You cannot use characteristic names that contain a hyphen because hyphens are always interpreted as a minus sign in formulas.
The names of characteristics that are used in formulas must start with a letter.
The following operators and functions can be used in formulas:
Operator Meaning Example
+ plus A + B
- minus A - B
* multiplied by A * B
/ divided by A / B
** to the power of A ** B
Function Meaning Example
ABS absolute value ABS(3-5) ==> 2
SIN sine SIN(A)
COS cosine COS(A)
TAN tangent TAN(A)
LOG natural LOG(A)
logarithm
EXP powers of e EXP(A)
SQRT square root SQRT(A)
ROUND round up ROUND(3,5) ==> 4
INT round down INT(3,5) ==> 3
INT(-3,5) ==> -4
TRUNC cut off TRUNC(3,5) ==> 3
decimals TRUNC(-3,5) ==> -3
MOD Modulo, remainder A MOD B
after division 7 MOD 3 ==> 1
DIV division where A DIV B
result is quoted as
integer
Please also note:
- The trigonometric functions are carried out in degrees.
- Roots other than square roots (for example, nth root of m) are shown in the following way: m**(1/n)
- Logarithms are carried out to base e. Logarithms to other bases can be entered in the following way: Logarithm of A to base 10: LOG(A)/LOG(10) Logarithm of A to base 2: LOG(A)/LOG(2)
- You can use a formula string with the following structure: IF <logical expression> THEN <arithmetic expression> ELSE <arithmetic expression>.
The following operands and operators can be used in the IF part:
Operand Meaning
TRUE logically true
FALSE logically false
Operator Meaning
= equal
><, <> unequal
< smaller than
<=, =< smaller than or equal to
> greater than
>=, => greater than or equal to
AND logical AND
OR logical OR
NOT negation
History
| Last changed by/on | SAP | 19931130 |
| SAP Release Created in |
