Condition base value formulas can be used to influence the condition basis to which the pricing condition rate will be applied.
In standard pricing, the system will apply the condition rate to the quantity in the sales document. For example, the price determined
by the system is $45 per case for Product A. 100 cases of Product A have been ordered. The system would then multiply $45 times the number of cases of Product A ordered. Using a condition base value formula, it is possible to alter the condition base, in our
example 100, prior to the calculation taking place.
A condition base value formula is commonly used to determine the base for distributing header
discounts / surcharges to the sales document line items.
A condition base value
formula is assigned to a condition type in the pricing procedure.
When looking at the code for the standard delivered condition base value formulas or when writing your own, XKWERT is the
field name that the condition base value should be assigned to.
Following is a description of the condition base value formulas delivered in the standard system. CONDITION BASE VALUE FORMULA 1: VOLUME
Formula '1' uses the volume of the sales document line item as the condition base value.
Example:
A company regularly applies fixed amount header discounts to a sales order.
For example, the user may apply a
fixed discount
of 500 USD to the header of the sales order. Fixed header conditions are always distributed
across the line items in the document. In this case, the company would like to distribute the fixed amount
based on the volume of the line items. To accomplish this, the user would assign condition base value formula
'1' to the header discount condition type in the pricing procedure.
CONDITION BASE VALUE FORMULA 2: NET VALUE
Formula '2' uses the net value of the sales document line item as the condition base value.
Example:
Reference example for formula 1
CONDITION BASE VALUE FORMULA 3: NET PRICE
Formula '3' was delivered to support net price processing.
For
additional information on the use of
this formula along with examples, please refer
to Note 80183.
CONDITION BASE VALUE FORMULA 4: NET VALUE PLUS TAX
Formula '4' uses the net value plus tax of
the sales document line item as the condition base value. Example:
Reference example for formula 1
CONDITION BASE VALUE FORMULA 5: KZWI1
Formula '5' uses the value determined for subtotal '1' in the pricing procedure as the condition base value. Example:
A company regularly applies fixed amount header discounts to a sales order.
For example, the user may apply
a fixed discount of 500 USD to the header of
the
sales order.
Fixed header conditions are always distributed across the line items
in the document. In this case, the company would like to distribute the fixed amount based on a subtotal derived based on certain values in the pricing procedure. The user has assigned subtotal '1'
to the relevant pricing procedure value(s).
In
addition,
the user would assign condition base value formula '5' to the header discount condition type in the pricing procedure.
CONDITION BASE VALUE FORMULA 6: KZWI2
Formula '5' uses the value determined for subtotal '2' in the pricing procedure as the condition base value. Example:
Reference example for formula 5
CONDITION BASE VALUE FORMULA 7: KZWI3
Formula '5' uses the value determined for subtotal '3' in the pricing procedure as the condition base value.
Example:
Reference example for formula 5
CONDITION BASE VALUE FORMULA 11: CASH DISCOUNT
BASE
Formula '11' can be used with the cash discount condition type.
This formula reads the indicator for the company code to determine if
the
cash discount is based on the net value of the item. If it is not, then the system bases it off of
the net value
plus the tax.
CONDITION BASE VALUE FORMULA 12: GROSS WEIGHT
Formula '12' uses the gross weight of the sales document line item as the condition base value. Example:
Reference example for formula 1
4\15
CONDITION BASE VALUE FORMULA 13: NET
WEIGHT
Formula '13' uses the net weight of the sales document line item as the condition base value. Example:
Reference example for formula 1
CONDITION BASE VALUE FORMULA 14: SET EXCLUSION INDICATOR
Formula '14' is an example of
how
a programmer can dynamically set the condition exclusion indicator based on certain values. This condition exclusion indicator
can then be checked in subsequent condition base value formulas (reference formula '15') to exclude certain condition types.
CONDITION BASE VALUE FORMULA 15: CHECK EXCLUSION INDICATOR
Formula '15' is an example of how a programmer can check the value of the condition exclusion indicator and then influence certain values. In this example, if the exclusion field is set to '$', the condition base value is set to zero and the condition is marked inactive. This example is provided in combination with formula '14' which shows
how
to dynamically set the condition
exclusion indicator.
CONDITION BASE VALUE FORMULA 16: NET
VALUE MINUS CASH DISCOUNT
Formula '16' uses the net value minus the cash discount value as the base value. This can, for example, be applied to a tax condition type that should use this value as a basis.
CONDITION BASE VALUE FORMULA 17: NET
PRICE
Formula '17' was delivered to support net price processing.
CONDITION BASE VALUE FORMULA 18: NO QUANTITY CONVERSION
Formula '18' is used to avoid rounding errors that can occur for quantity dependent condition types where the sales unit and the pricing unit are one unit of measure and the base unit of measure is another. Using formula
'18', no conversion is done to base unit of measure when the sales unit of
measure and pricing unit of measure are
identical.
NOTE: The user
can achieve the same result by setting the
"quantity
conversion" indicator in condition type configuration.
Example:
A company uses KG as their
base
unit of measure, but chooses to quote prices and sell products in pieces (PC). A quantity conversion has been maintained to indicate that 3 PC correspond to 1 KG. A pricing record has
been
created to price 1 PC of product at 1 USD. If
a customer orders, for example, 1 PC of product, it is possible that the system returns back an item value
of 0.999 USD. To avoid this, the user assigns condition base value formula '18' to the price condition type as well as other quantity dependent condition types in the pricing procedure.
CONDITION BASE VALUE FORMULA 19: KZWI4
Formula '19' uses the value determined for subtotal '4' in the pricing procedure as the condition base value. Example:
Reference example for formula 5
CONDITION BASE VALUE FORMULA 20: KZWI5
Formula '20' uses the value determined for subtotal '5' in the pricing procedure as the condition base value.
5\15
Example:
Reference example for formula 5
CONDITION BASE VALUE FORMULA 21: KZWI6
Formula '21' uses the value determined for subtotal '6' in the pricing procedure as the condition base value. Example:
Reference example for formula 5
CONDITION BASE VALUE FORMULA 22: WHOLE NUMBER
Formula '22' is used to convert the basis to a whole number. For example, a basis of 300.153 would be converted to 300. Formula '22' is delivered in R/3 along with the condition type KP00 which can be used to compute pallet discounts.
Example:
A company sells their products in cases. Each of
their materials has a conversion factor to pallets. When an order is placed by a customer, the user would like the system to calculate the number
of
full pallets for each
line and to offer a 5 USD discount per
full pallet ordered. The user sets up condition type KP00 in the pricing
procedure and assigns condition base value formula '22'. Within the condition records for condition type KP00, the user maintains the 5 USD per pallet discount rate. If an order line item is placed that contains 5.5 pallets, the system will adjust
the base value to 5 and compute a discount of
25 USD for the sales line item.
CONDITION BASE VALUE FORMULA 24: 1 IF PARTIAL QUANTITY
Formula '24' is used to convert the basis to a quantity of
1 if a partial quantity is involved,
otherwise the basis is set to zero. For example, a basis of
300.153 would be converted to 1. As a second example, a basis of 300 would be converted to zero.
Formula
'24' is delivered in R/3 along with the condition type KP01 which can be used to calculate an incomplete
pallet surcharge.
Example:
A company sells their products in cases. Each of
their materials has a conversion factor to pallets. When an order is placed by a customer, the user would like the system to calculate the number of full pallets
for each line
and
to charge a 5 USD
surcharge to the item if a full pallet quantity is not ordered.
The
user sets up condition type KP01 in the pricing procedure and assigns condition base value formula '24'. Within the condition records for condition type KP01, the user maintains the 5 USD surcharge.
If
an order line item is placed that contains 5.5 pallets, the system will adjust the base value to 1 and compute a surcharge of 5 USD for the sales line item.
CONDITION BASE VALUE FORMULA 26: BOLLO IN FATTURA
Formula '26' was provided to support the Italian Bollo in Fattura. Using this formula will set the condition to inactive if the VAT value is not zero. This formula can be assigned to the R/3 delivered condition types BOLL and MWBO in the pricing procedure.
CONDITION BASE VALUE FORMULA 27: XWORKK – DEACTIVATE CONDITION
This formula was delivered to support tax exemption licenses in Italy.
The condition base value formula '27' is assigned to the tax condition type in the pricing procedure. The formula is used to deactivate the tax when a valid license exists..
CONDITION BASE VALUE FORMULA 28: 100% DISCOUNT
Formula '28' sets the rate of
the condition to a 100% discount.
6\15
Example:
A company has a free goods agreement with their customers. For every 10 cases of Product A that the customer buys, the customer receives 2 cases of Product B for free. From a pricing perspective,
the
user wants to track both revenue and sales
deductions for
the
free items since Product B is also sold by itself sometimes
in the sales process. To do this, the user flags the free goods item category with the pricing indicator 'B'. In addition, the user adds the R/3 delivered condition type R100 to the pricing procedure at the point at which the
100% discount should be applied. Condition base value formula '28' is assigned to condition type R100 in the pricing procedure to apply the 100% discount rate.
CONDITION BASE VALUE FORMULA 29: FREE GOODS / INCLUSIVE
Formula '29' was delivered along with condition type NRAB to support Release 4.5 Inclusive Free Goods agreements where the user would prefer to
have a discount applied to the ordered item rather than having a sub-item generated for the free quantity.
Example:
A company has a free goods agreement with their customers. If
the customer orders 100 cases of Product A, they receive 10 of these cases free of charge.
Instead of having a free sub-item generated by the system to
represent the free 10 cases, the user would like a discount applied to the 100 case line item equal to the value
of 10 cases. To accomplish this, the user assigns the NRAB condition type to the pricing procedure and assigns
the
condition base value formula '29'.
CONDITION BASE VALUE FORMULA 44: VAT FRANCE
This formula was delivered to support tax exemption licenses in France. The condition base value formula '44'
is assigned to the tax condition type in the pricing procedure. The formula is used to deactivate the tax when a
valid license exists. For additional information on tax exemption licenses, please refer to Note 72040.
CONDITION BASE VALUE FORMULA 50: QUANTITY ACTIVE INGREDIANT
Condition base value formula '50' was delivered to support pricing based on active ingredient quantities. This formula is assigned to the condition types in the pricing procedure for which you work with proportion quantities. Using this formula, the
system can carry out billing at the main item level where the system
cumulates the quantities from the batch split items.
CONDITION BASE VALUE FORMULA 51: SHIPMENT COSTING -TAXES
Formula '51' was delivered along with shipment costing in the shipment cost document. This formula assigns
the tax indicator from the tax condition record to the shipment cost document item. This condition base value formula should be assigned to tax condition types in the shipment cost document pricing procedure.
CONDITION BASE VALUE FORMULA 61: PREFERENCE
Condition base value formula '61' was delivered to solve a field overflow problem that can occur when working with
preference determination. This can occur
due to the quantity dependency. Formula '61' is
assigned to the preference condition type in the pricing procedure (R/3 delivered condition type PREF).
CONDITION BASE VALUE FORMULA 202: PRICE BOOK FACTOR
Formula '202' can be used to offer a price that is a percentage of a predefined price. For additional information on this Release
4.5 feature, please refer to the R/3 Library documentation on Price Book, which can be found in the Special Pricing Functions
(Data Determination in the Access) section of
the Sales & Distribution
Pricing Guide.
7\15
Example:
A company would like to define a pricing agreement with their customer whereby the customer
should pay
90% of the material price from the previous year. This agreement can be stored using R/3 Price Book functionality and the
pre-delivered condition type PBUD. 90% is entered as the condition value in the PBUD
condition record and the pricing date is defined using the data determination in access functionality.
In
the
Price Book pricing procedure, condition type PBBS is then used to determine the base price from last year. Next in the pricing
procedure is condition type PBUP which is used to determine the gross price which should be 90% of last
year's price.
To perform this calculation, condition basis formula '202' is assigned to condition type PBUP in the pricing procedure.
