Show TOC

 Basic Functions of Material Quantity Calculation

Use

You 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 .

Prerequisites

  • 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.

Features

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 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.

End of the caution.

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 the statement after IF is true, the value of the expression after THEN

  • If the statement after IF is false, the value of the expression after ELSE

IF (2<3) THEN (5*6) ELSE (5-7) = 30

IF NOT … THEN…ELSE

Returns the following value:

  • If the statement after IF NOT is false, the value of the expression after THEN

  • If the statement after IF NOT is true, the value of the expression after ELSE

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