Example: Valuation Using Conditions 

Here is an example of valuation using conditions. The valuation strategy has been activated for the point of valuation 01 (valuation of actual data) as well as for the record type F (billing document) uses valuation with the costing sheet ACT001 on the basis of the quantity field "Billed quantity". In the sales system SD, the characteristic values "Product" 4711, "Customer group" 3 and "Sales organization" 001 are posted to a line item. The billed quantity is 2 and the revenue is 2000. Since billing occurs at the point of valuation 01 (actual data) and comes under record type F (billing document), valuation occurs using conditions.

The condition types for the values to be calculated are summarized in costing sheet ACT001 (condition types REVN and PROV in the example). You also specify in the costing sheet what will be the calculation basis for a condition (condition PROV is calculated on the basis of REVN, and this is defined by the level specification).

For each condition type, you maintain the parameters that are to be employed to calculate the anticipated values. The example uses a base condition (REV) and an addition/reduction condition with a percentage charge or reduction (PROV). Moreover, the access sequence Z200 has been assigned to the addition condition PROV.

An access sequence defines the order in which the system accesses different condition tables.

A condition table contains condition records for each combination of valid characteristic values (in the case of the condition type PROV in condition table 506, for example, the valid characteristic values are those for the characteristics "Sales organization" and "Customer group").

In the example, access sequence Z200 accesses condition table 506. This condition table contains a condition record for sales organization 0001 and customer group 03 that specifies a value of 5%. If you select the field Exclusive, the system will not search for any more condition records in the tables that follow in that access sequence (in this case table 507).

The value field assignment determines the value field in CO-PA to which the value for a condition type is to be transferred. (For example, the condition type "PROV" is assigned to the value field "Commission".)

From the definition of the condition types, we can see that the condition record (5%) found for the sales commission (condition type PROV) uses the value for condition type REVN as a basis. In the value field assignment we see that the condition type "REVN" is assigned to the value field "Revenue". Thus the line item in CO-PA shows a revenue of USD 2000. This yields CMSN = 5% * 2000 = 100.

This value is then transferred to the value field "Commission" as defined in the value field assignment (condition type "PROV" to value field "Commission"). The line item is thus valuated according to the specified strategy.