Condtion exculsion

[Former Member]

Hi Friends,

I want detailed configuration set up of condtion exculsion .(detialed config set up)

PLease help me.

Thanks&Regards

Jayeshbabu.P

[Former Member]

Hi

When we want that certain conditions( especially discount condition type) should not be used then we go for Condition exclusion.

Condition exclusion can be activated in three places,

-- in the Condition Type

-- in the Condition record

-- in the condition Type PR00

You will find the "Condition exclusion" check box in these above three.

If you, activate the condition exclusion in the condition Type, then all the condition record based on this Condition Type will be excluded.

For example if you have activated the exclusion for K004, then all the condition records created for K004 will be excluded (not used).

If you are activating the "Condition exclusion" in the Condition record, then that particualr (only one) Condition record will be excluded.

One ,more way you can use condition exclusion is that you can set the Exclusion indicator in Condition Type PR00 and set the requirement "2" in the Pricing Procedure.

If you are activating the Exclusion indicator in PR00, all discount conditions dependent on PR00 value will be excluded ( remember , the condition supplements are not affected by this).

So, it is used (activated in the respective place) as per your bussiness requirement.

Beside, this suppose we have many different discounts in offer, whereas one customer may be eligible for all discounts, then system will take all discounts for that customer which is seriously harmful to the business.

Therefore, in this case we go for "Comparing Conditions".

That means we want to ensure that, Customer should get the best Price.

Best Price means, lowest price and highest discount. That means customer will get only one discount which is highest for him/her and not all discounts.

So, even if you ahve number of discount condition types , only the highest discount will be active and all others are de-activated.

To achieve this, we put those condition type in condition comparison, so that they will be compared within themselves and the best discount is choosen and all others are de-activated.

We create exclusion groups and in the exclusion group we assign all the condition types which we want that they should be compared.

Menu path

IMG > SD > Basic functions > Pricing > Pricing control > Condition Excusion > Conditio Exclusions for Group of conditions > Define exclusion group

Then assign the condition types to exclusion group.

Next,Maintain condition exclusion for Pricing procedure.

Select your Pricing procedure, double click on "Exclusion" on the dialog structure, assign the serial number, exclusion procedure and the exclusion group which you have created.

You can have lot of variations here as per business requirements.

Edited by: pradyumna on Feb 5, 2009 6:34 AM

[Former Member]

Hi,

please find this notes.

Condition Exclusion

The system can exclude conditions so that they are not taken into account during pricing in sales documents.

Material 4711 costs 150 USD. Some customers receive a discount of 10 USD per 100 pieces.

However, a specific customer can buy the material for 100 USD. Since this is a particularly good price, the customer should not also have a discount of 10 USD per 100 pieces. Therefore, this discount is to be excluded from pricing.

To do this, you must follow two steps:

You must set a condition exclusion indicator for the price. You can do this in two ways: If you want to set the condition exclusion indicator a follows then you specify it:

- for all condition records of a condition type (e.g. with condition type PR00) when defining a condition type in SD Customizing

- for an individual condition record (e.g. only for material 4711) in the detail screen of a condition record (in the Condition exclusion field)

You must set a condition for the discount in the pricing procedure in Customizing for sales. If this condition is set, the discount is not valid if the condition exclusion indicator is set. Condition 2 is available in the standard R/3 System.

The condition exclusion indicator is not valid for condition supplements.

This means that if a condition record contains condition supplements they will be taken into account during pricing.

Condition Exclusion Group u2013

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 u2018condition exclusion groupsu2019 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 u2013 IMG - Sales & Distribution - Basic functions u2013 pricing u2013 condition exclusion u2013 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 u2018Inactive A condition exclusion itemu2019.

There are four possible methods of using condition exclusion groups u2013

A u2013 best condition between the condition types

B u2013 best condition within the condition types

C u2013 best condition between the two exclusion groups

D u2013 exclusive

E u2013 least favorable within the condition type

F u2013 least favorable within the two exclusion groups

Configuring u2018Condition Exclusion Groupsu2019

First step is to define a u2018condition exclusion groupu2019 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 u2018Exclusionu2019 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 u2013 only use one condition type per exclusion group. The most important thing to remember here is to u201Cdeactivateu201D 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.

Best regards,

venkataswamy.y

[Former Member]

Hi

These are the keyfields

1.Create Condition Table .

2. Create Access Sequence

3.Create Condition Type

4.Create Material Determination Procedure

5.Assign Material Listing and Exclusion to Sales Document Type u2013 OVo4.

6.Create Listing and Exclusion u2013 VB01

[Former Member]

Step 1 :-

T-Code - / NV/06 u2013 Condition type

Click on position

Select & copy K007 for Discount.

Make your own discount conditions D1,D2 etc.

Similarly select & copy KF00 for freight

Make your own freight conditions F1,F2 etc.

Step 2 :-

T-Code - / NVK11 u2013 Condition Records

Make condition records for the customers with above

Conditions of Discount & Freight

Step 3 :-

SPRO u2013 IMG u2013 Basic function u2013 Pricing u2013 Condition exclusions u2013 Condition exclusions

For group of conditions

A. Define condition exclusion Group

Click on New entries

Enter condition groups e.g discount & freight groups

B. Assign condition type to condition exclusion group

Click on new entries

Assign condition types of step 1 to the conditions group of step 3 A

C. Maintain condition exclusion for procedure

Select standard pricing procedure of the company & click on exclusion

Click on new entries

Sr. no. Cpr Exclusion group

1. A Discount / Freight group

2. A Discount / Freight group

Step 4 :-

T u2013 Code - / NV/O8 u2013 Define pricing procedure

Select standard pricing procedure of the company click on to conditions enter above

Condition for discount & freight after earlier discount & freight conditions respect.

Step 5 :-

Make a standard sales order & check the conditions view for correct customization

thanks,

Rahul