!--a11y-->
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 |
