Start of Content Area

Function documentation Basic Functions of Material Quantity Calculation  Locate the document in its SAP Library structure

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

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:

For materials for which you use batch determination, you are given the following in material quantity calculation:

For material properties, you are given:

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

This graphic is explained in the accompanying text

You can enter formulas for the following fields:

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:

The system expects the decimal point or the sign defined for decimal expressions in your user defaults.

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

Example

In the graphic above:

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

Example

Calculating Header and Component Quantities