Condition type with fixed value and percentage / How to use a Condition Type for Multi Calculation Types

Requirement: Percentage and Amount both Calculation Type options should allow for a condition type during the purchasing.

 

Solution:

SAP standard solution for maintenance the different calculation types for a condition type:

A condition type is a representation in the system of some aspect of our daily pricing activities. For example, we can define a different condition type for each kind of price, discount or surcharge that occurs in our business transactions.

Example of a Condition Type:

We define the condition type for a special material discount. We specify that the system calculates the discount as an amount (for example, a discount of SGD 1 per Purchasing unit). Alternatively, We can specify that the system calculates the discount as a percentage (for example: a 2% discount for orders over 1,000 units). If we want to use both possibilities, we must define two separate condition types. The following figure illustrates how condition types can be used during pricing in a Purchasing document.

 

In the example in the preceding figure, two discounts apply to the item in the Purchase order. The first discount is a percentage discount based on the quantity ordered. The second discount is a fixed discount based on the total weight of the item.

Define Condition Type:

T.Code: M/06

Path: SPROàIMGàMaterial ManagementàPurchasingàConditionsàDefine Price Determination ProcessàDefine Condition Types

Calculation Types:

A        Percentage

B        Fixed amount

C        Quantity

D        Gross weight

E        Net weight

F        Volume

G        Formula

H        Percentage included

I         Percentage (travel expenses)

K        Per mille

J         Per mille

L         Points

M        Quantity - monthy price

N        Quantity - yearly price

O        Quantity - daily price

P        Quantity - weekly price

Q        Commodity Price

R        Distance-dependent

S         Number of shipping units

T        Multi-dimensional

U        Percentage FIN (CRM Only)

 

When setting up condition records via MEK1 transaction, we can enter a different calculation type than the one in Customizing calculation type.

At present all available calculation types are allowed.

The field ‘Calculation type’ can however not be accessed if this field is left empty. After the data release has been printed, if the field has not been completed manually, the proposal is automatically taken from Customizing. After this it is no longer possible to make manual changes.

If we use different calculation types for what are otherwise the same conditions (for example, percentage, as a fixed amount or quantity-dependent), we do not have to define different condition types in Customizing. We can set a different calculation type when maintaining the individual condition records.

Example:

Scenario 1:

When I created the condition record the calculation type A-percentage automatically taken from customizing :

 

Scenario 2:

 

I deleted the above the condition record and created new condition record for the same material with fixed amount instead of percentage. Here I entered calculation type B manually & Unit.

 

 

Conclusion: While create condition record for a condition type by default it will propose calculation type as we mentioned in the customizing. But we can change the calculation type as per our requirement either fixed amount or  percentage or other calculation type. The calculation type for a condition record for a material   should be unique for purchase organization/plant level.

 

So we can use all condition types any calculation type while creating the condition record via MEK1 transaction.

 

Note: We determine the calculation type for a condition type in Customizing. This determines how the system calculates prices, discounts and surcharges for a condition. When setting up condition records, we can enter a different calculation type than the one in Customizing. At present all available calculation types are permitted. The field ‘Calculation type’ can however not be accessed if this field is left empty. After the data release has been printed, if the field has not been completed manually, the proposal is automatically taken from Customizing. After this it is no longer possible to make manual changes.

If we use different calculation types for what are otherwise the same conditions (for example, percentage, as a fixed amount or quantity-dependent), we do not have to define different condition types in Customizing. we can set a different calculation type when maintaining the individual condition records.