Examples: Derivation Types 

Derivation rule

You can define derivation rules to populate your user-defined characteristics in Profitability Analysis. In the following example, the characteristic "Strategic business unit" is a user-defined characteristic in your operating concern. The strategic business unit (target field) is determined on the basis of the product group (source field). The step attribute Define values with period of validity is activated.

You enter the following values:

Product group

To product group

Valid from

Strategic business unit

100

 

01.01.1998

Electronics

200

299

01.01.1998

Multimedia

200

399

01.06.1998

Multimedia

Table lookups

Normally, the characteristic "Country" is derived using an automatically created derivation step (table lookup in the customer master table KNA1) that takes the characteristic "Customer" (KNDNR) as the source field. In the following example, the country (WWCST) is derived using a table lookup (in customer master table KNA1) with the ship-to party (KUNWE) as the source field. The characteristic "Ship-to party" has been copied to Profitability Analysis from the SD structure PAPARTNER.

Table lookups using source fields

Origin

Field name

=

Origin

Field name

Description

KNA1

KUNNR

=

CO-PA

KUNWE

Ship-to party

Moving table fields to target fields

Origin

Field name

=

Origin

Field name

Description

KNA1

LAND1

=

CO-PA

WWCST

Ship-to country

Moves

The following move copies the customer (KNDNR) to the ship-to party (KUNWE) if no ship-to party is contained in the ship-to field.

Source field:

KNDNR

Customer

Target field:

KUNWE

Ship-to party

Under Condition, enter the following for this step:

Origin

Name

Description

Operator

Value

CO-PA

KUNWE

Ship-to party

=

 

Clear

Since the characteristic Representative (VRTNR) is not relevant for analysis in certain divisions, you use the following clear so that this characteristic is not populated for the condition specified below.

You therefore want to clear the following field:

CO-PA

VRTNR

Under Condition, enter the following:

Name

Description

Operator

Value

SPART

Division

=

(05) Machine sales