Condition exclusion groups

[Former Member]

Hi,

Please can you help me understand what condition exclusion group mean.

thanks

[Former Member · Accepted solution]

Hi,

Condition Exclusion Group –

In any normal situation there could be more than one condition type in a pricing procedure offering a discount to a customer. Should the discounts be automatically determined, there is the risk that the customer will receive all the relevant discounts and thus purchase the product for a lower price than he should.

By using ‘condition exclusion groups’ you can ensure that the customer does not receive all the discounts, but instead only receives the best of the available discount condition types.

Menu path – IMG - Sales & Distribution - Basic functions – pricing – condition exclusion – condition exclusion for groups of conditions (OV31).

A condition exclusion group is merely a grouping of condition types that are compared to each other during pricing and result in the exclusion of particular condition types within a group or entire groups. It is important to note that the condition types you want the system to compare must exist in the pricing procedure and must have valid condition records created for them.

If for example, a sales order is created using the pricing procedure that the exclusion group is assigned to, you can see that the condition offering the most favorable discount to the customer is represented in the pricing procedure.

For instance, condition type K007 has offered a discount of 10% off the sale price or a real value of $30, while another condition type K005 has offered a real value discount of $10. The system then takes the best discount for the customer between the two, which is K007 and makes the other discount K005 inactive. This can be seen by double clicking on the condition type K005, where you can find a entry saying ‘Inactive A condition exclusion item’.

There are four possible methods of using condition exclusion groups –

A – best condition between the condition types

B – best condition within the condition types

C – best condition between the two exclusion groups

D – exclusive

E – least favorable within the condition type

F – least favorable within the two exclusion groups

Configuring ‘Condition Exclusion Groups’

First step is to define a ‘condition exclusion group’ by using a four character alpha numeric key.

Next step is to assign the relevant condition types to the exclusion groups such as discount condition types, freight condition types.

After completing the assignment of the condition types to the exclusion group, proceed with assigning the condition exclusion group to the relevant pricing procedure.

After selecting the pricing procedure for which you want the condition exclusion to be active, select the folder ‘Exclusion’ where you can assign the relevant condition exclusion procedure to the relevant condition exclusion group.

When using the condition exclusion group to find the best condition record in a condition type – only use one condition type per exclusion group. The most important thing to remember here is to “deactivate” the Exclusive Indicator on the access sequence assigned to that condition type. Otherwise, the system will merely find the first condition record and stop searching for other records.

Reward points if useful

Regards,

Amrish Purohit

[Former Member]

helloo vikrant,

Condition Exclusion

In this step, you can set up exclusion procedures for groups of conditions and for individual condition types or records.

There are two divisions

Condition Exclusion For Groups Of Conditions

And

Condition Exclusion For Condition Types And Records

The explanation for Condition Exclusion For Groups Of Conditions

Is given below:

If several condition records are valid for pricing in a document item, you can define rules that specify which condition records are and are not included. You use condition exclusion for this purpose.

You control condition record exclusion using exclusion groups. An exclusion group is a list of condition types which are compared with each other during pricing and result in the exclusion of an entire group or individual condition types within a group.

Thus, the result of pricing can be influenced with regard to a required criterion (for example, best price) by excluding certain condition types while others are taken into account during pricing.

Example

You can define a condition exclusion which determines the best price for the customer and excludes other less favorable results of pricing. The best price then reverses the priority of condition types which would have been predefined by the access sequence.

The procedure according to which the selection is carried out within or between the condition exclusion groups is defined in the pricing procedure. The following options are possible:

• Selection of the most (least) favorable condition type within a condition exclusion group

• Selection of the most (least) favorable condition record of a condition type, if more valid condition records exist (for example, selection from different condition records of the condition type PR00)

• Selection of the most (least) favorable of two condition exclusion groups (in this case, all condition types of the two groups are cumulated and the totals are compared)

• Exclusion procedure: If a condition type in the first group exists in the document, all condition types in the second group are set to inactive.

The tables for condition exclusion are empty when delivered. You therefore have to carry out the following steps if you want to use condition exclusion:

• Define condition exclusion groups

• Allocate condition types to the condition exclusion groups

• Enter condition exclusion groups in the pricing procedure and specify a procedure for determining the condition types to be excluded

Actions

1. Create a condition exclusion group by entering an alphanumeric key with a maximum of four characters and a description.

2. Allocate the condition types to a condition exclusion group. A condition exclusion group can contain any number of condition types.

3. Enter the condition exclusion group in the pricing procedure that you use in pricing (Goto -> Exclusion groups).

Note the sequence (sequential number) in which the exclusion groups should be processed.

You can use two exclusion groups for condition exclusion. In this case, you must choose the procedure "C" which determines the best price between two exclusion groups.

<b>**reward if this helps**</b>

Regards

AK

[Former Member]

Hi

In pricing for sales and billing documents, more than one condition record may apply to a particular item at any one time. You can use the condition exclusion process to compare possible conditions in order to determine such things as the best price for a customer.

An exclusion group is a list of condition types that is identified by a three-digit number. Exclusion groups are defined in Customizing for Sales. You also assign exclusion groups to a pricing procedure and to determine how the condition exclusion is to be carried out.

You then assign the exclusion groups to a pricing procedure, thus defining the condition exclusion.

Depending on how you configure exclusion groups in the pricing procedure, the system can use condition exclusion to select the best price or discount in six different ways:

Selecting the best condition record of a particular condition type from within one exclusion group

Selecting the most unsuitable condition from within one exclusion group

Selecting the best condition record for a condition type

Selecting the most unsuitable condition record for a condition type

Selecting the best conditions from different exclusion groups

Excluding all condition types in the second exclusion group if a particular condition type in the first exclusion group exists in the document

Please reward,if this helps

Regards

Simu

[Former Member]

Hi,

When there are more than one alternatives for a condition and you want to give the best out of that, we use condition exclusion gp.

As an example you want to give the customer the best possible disc. then we can pick that. This also to ensure we dont give all of the discounts.

<a href="http://help.sap.com/saphelp_47x200/helpdata/en/de/7a8534c960a134e10000009b38f83b/frameset.htm">Condition Exclusion</a>

Pl reward if helpful.

Regards

Sadhu Kishore

[macilia]

i have created two logistic surcharges and created two exclusion groups so that : if one of the two is applied then the other one is cancelled.