Basic Functions of Material Quantity CalculationYou can use the following functions in material quantity calculation whenever you do not need to access batch data for the calculation. If you must take the values of batches into account in a calculation, you can also use the functions described in Material Quantity Calculation with Batch Data .
To be able to use material quantity calculation in a master recipe, you must have defined a production version for the master recipe.
To transfer the data from material quantity calculation from a master recipe to the process order, you must create the process order with the corresponding production version.
For you to be able to take material properties into account in material quantity calculation, the following requirements must be met:
It must be possible to enter the property as a numeric value.
You must classify the material master record or the BOM item with a class of class type
Batch.
You must assign the property as a characteristic to this class and assign a value to it in the material master record or the material list as well as in the material list of the process order.
The data of all materials, operations, and phases that are used in the master recipe or process order are available in material quantity calculation. When you call up material quantity calculation, you are given the following:
The planned quantity for each operation as well as a field for any interim results
The planned quantity for each phase, a field for the scrap to be expected, and a field for any interim results
The planned quantity for each material, all numerical material properties as well as a field for any interim results
For materials for which you use batch determination, you are given the following in material quantity calculation:
A line containing the original quantity of the material item for the totals record (line 4 of the example below)
A line containing the transferred batch quantity for each batch (lines 5 to 7 of the example below)
For material properties, you are given:
In the master recipe, the value from the BOM or, if this value is missing, the value from the material master record
In the process order, the value from the material list of the order or, after the batch determination, the value of the batches used
If multiple values or value ranges have been defined, the system uses the lowest value.
Caution
After you have carried out batch determination, the planned value from the material list is normally still displayed in the totals record. If, however, no unit has been assigned to the characteristic, the system displays the sum of all batch values instead.
Example: Data of Material Quantity Calculation
You can enter formulas for the following fields:
The quantity fields of the materials as long as batch determination has not been carried out
The quantity fields of the operations
The quantity and scrap fields of the phases
The
Interim results
field of materials, operations, and phases
This field does not directly influence the quantity structure of an order. Its value can, however, be used to calculate the remaining quantities.
You can use the following operands to define your formulas:
Number constants, such as: –5; 3.1416; 1.3E12
The system expects the decimal point or the sign defined for decimal expressions in your user defaults.
References to quantity, scrap, and characteristic fields and interim results
Note that the system does not take the unit of measure of referred values into account. Percentages, for example, are treated like absolute values during the calculation.
References are displayed as follows in the formula:
[<Line of the field referred to>,<Column of the field>]
In the graphic above:
[001,001] refers to the quantity field of product XYZ
[004,002] refers to the characteristic field of component ABC
In addition, you can use the operators or functions listed below:
Operator |
Meaning |
Example |
+ |
Addition |
|
- |
Subtraction |
|
* |
Multiplication |
|
/ |
Division |
|
DIV |
Division using integers; not intended for negative numbers |
10 DIV 3 = 3 |
MOD |
Remainder after division (modulo function); not intended for negative numbers |
10 MOD 3 = 1 |
Function |
Meaning |
Example |
** |
Exponentiation |
3**3 = 27 |
IF…THEN… ELSE |
Returns the following value:
|
IF (2<3) THEN (5*6) ELSE (5-7) = 30 |
IF NOT … THEN…ELSE |
Returns the following value:
|
IF (2<3) THEN (5*6) ELSE (5-7) = -2 |
ABS |
Absolute value |
ABS(-2) = 2 |
ROUND |
Round to nearest integer |
ROUND(1,8) = 2 |
TRUNC |
Integral amount of a number; not intended for negative numbers |
TRUNC(1,8) = 1 |
SQRT |
Square root |
SQRT(144) = 12 |
EXP |
Power to base e |
EXP(1) = 2.7182746352 |
LOG |
Logarithm to base e |
LOG(2.7182746352) = 1 |
SIN |
Sine |
SIN(0) = 0 |
COS |
Cosine |
COS(0) = 1 |
TAN |
Tangent |
TAN(1) 1.55741 |