Condition Exclusion Group

[Former Member]

Hi,

What is the purpose of the condition exclusion group?

If we put two different condition types (PR00 -price and K007-discount) in one condition exclusion group, what will be the effect? Is it ok to have two different condition types in one condition exclusion group?

B Regards,

Bhaskar.K

[former_member204513 · Accepted solution]

Dear Bhaskar,

Go through this SAP help it will help you about Condition Exclusion process

http://help.sap.com/saphelp_47x200/helpdata/en/93/743483546011d1a7020000e829fd11/frameset.htm

I hope this will help you,

Regards,

Murali.

[Former Member]

Hello,

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.

The logic can be like.for example,, you have defined a dicount for the material and for the customer, in the sales order the system picks up both the discounts, it should not be allowed. So an exclusion group will be created with conditions of similar kind ( dicount conditions) and set the rule accordingly.

There is no point in creating an exclusion group for Basic price PR00 and a discount K007.

Prase

[Former Member]

Hi there,

PR00 & K007 can never be in the same condition exclusion grp.

For eg you have defined 3 discounts K004. K005 & K007. In the pricing procedure V/08, you have maintained all the 3 discounts. Also you have maintained condition records for the above 3 as K004 5%, K005 10%, K007 15%. Consider that PR00 for an item is Rs 100. If all the 3 discounts get applied one after the other as per the V/08, then the total net value will be Rs 72.67 which is much lower than the cost of the material. This means if all the discounts apply in the pricing, you will end up giving the customer more discount that he deserves / you intend to give.

To avoid that situation you put all the 3 discounts K004, K005 & K007 into an exclusion grp. Then you will define a rule that the system should apply the best condition or the least discount as per your requirement.

If you select the best condition, then system will pick up K007. If least condition option is selected, tehn it will pickup K004.

From the above do you think you want to proceed placing PR00 & K004 in the same exclusion grp?

Regards,

Sivanand

[Manoj_Mahajan78]

Dear Bhasker,

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.

Regds

MM

[Lakshmipathi]

Dear Bhaskar

Check this thread

[Condition exclusion group |]

thanks

G. Lakshmipathi