cancel
Showing results for 
Search instead for 
Did you mean: 

CONDITION EXCLUSION

Former Member
0 Kudos

Hi Gurus,

Tell me the process of Condition Exclusion step by step...

MAIL ID: ravikumar.talluri@gmail.com

Rewards will be given

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

hi

Condition Exclusion Groups

It is quite possible that you may have more than one condition type in your pricing procedureoffering 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 lower than heshould. By using condition exclusion groups, you can ensure the customer does not receive all discounts, but instead only receives, for example (the best of the four discount condition types).

Menu Path

The path here is IMG, Sales and distribution, Basic functions, Pricing, Pricing control, Condition

exclusion, Condition exclusion for groups of conditions, Define condition exclusion groups.

Transaction Code

The code here is [OV31]. A condition exclusion group is merely a grouping of condition types thatare compared to each other during pricing and result in the exclusion of particular condition types within a group or entire groups.

There are four possible methods of using the condition exclusion groups:

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

Selection of the most (or least) favorable condition record of a condition type, if more valid condition records exist (such as selection from different condition records of the condition type PR00)

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

An exclusion procedure in which if a condition type in the first group exists in the document, all condition types in the second group are set to inactive

We will use the example of the most (or least) favorable condition type within a condition exclusion group as an example, using the two discount condition types K005 and our created Z007.

Thus, we will place both these condition types in an exclusion group.

Proceed by defining an exclusion group by using a four-character alphanumeric key. In our example, we will call our group Z100 Menu Path

One now proceeds to assign the condition types to the exclusion group.

Go to IMG, Sales and

distribution, Basic functions, Pricing, Pricing control, Condition exclusion, Condition exclusion for

groups of conditions, Assign condition types to the exclusion groups.

Transaction Code

The code here is [OV32]. , assign the relevant condition types to the condition

exclusion group.

Menu Path

After completing the assignment of the condition types to the exclusion group, proceed with

assigning the condition exclusion group to the pricing procedure as follows: IMG, Sales and

distribution, Basic functions, Pricing, Pricing control, Condition exclusion, Condition exclusion for

groups of conditions, Maintain condition exclusion for pricing procedures.

Transaction Code

The code here is [VOK8]. After selecting the pricing procedure for which you want the condition

exclusion to be active, select the button “—> Exclusion.” This will take you to

NOTE: Do not forget the condition types that you want the system to

compare must exist in the pricing procedure and have valid condition

records created for them.If you now create a sales order using the same pricing procedure that the exclusion group is

assigned to, you will find that the condition offering the most favorable discount to the customer is

represented in the pricing procedure that the condition type Z007 has offered a discount of 10 percent off

the sale price or a real value of 30 DEM, while condition type K005 has offered a real value discount

of 10 DEM. The system then takes the best discount for the customer between the two, which is

Z007, and makes the other discount, K005, inactive. This can be seen by double-clicking on K005.

Note the entry “Inactive A condition

exclusion item.”

It is possible to see the advantages of the exclusion groups in the previous example. Imagine

the product has a lower sales price of, say, 90 DEM per item. The result would be that condition type

Z007 offers a 10 percent discount, which is a real value of DEM, while K005 still offers a discount

of 10 DEM. In this case, Z007 would be inactive and the system would use K005.

Condition type K005 is inactive.

The Exclusive indicator on Z007 is unchecked.

NOTE: When using the best condition record within a condition type, only

use one condition type in the exclusion group. Also note that you must

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.

For example, we will modify the already-created condition exclusion

group Z100 in order so that the only valid condition type assigned to it will

be our discount condition type of Z007. After removing the exclusive

indicators from Z007, the access sequence is as follows in Figure 4-38.

If the standard determination uses the condition technique, should the exclusion indicators be

set, the system will find a record for the first access and not proceed further. However, should one

set the condition type in the exclusion group as Z007 only, and set the search of the exclusion, as in

, we can see the system has found both records, but the initial record of 10

percent deduction for Z007 has been set as inactive. Instead, the system uses the record of 15 percent

deduction. The condition type K005 is still active, as it is no longer part of a condition exclusion

group, but merely part of the standard pricing procedure.

NOTE: If the exclusive indicators are not set, but condition record exists

for the condition tables in the access sequence, and no condition exclusion

group exists for the condition type, the system will bring all valid condition

records into the sales document,

Exclusion indicator now searches for the best record within a condition type.

The second condition record for Z007 is used now offering a discount of 45 DEM.

All valid condition records are found.

Answers (6)

Answers (6)

Former Member
0 Kudos

first we have to define the condition exclusion group

and assign the condition types to that exclusion group from which u want to give the best discount to the

then assign this condition exclusion to the pricing procedure, then there are option among whcich the best condition should be given to the customer

Former Member
0 Kudos
Former Member
0 Kudos

hi ravi kumar,

Basically condition exclusion is used when suppose you have for Eg. 3 different types of discount and you want to pass on the best of discounts or least of the discounts. In this case we go for condition exclusion as the name itself says condition exclusion i.e., exclude particular condition type.

Follow the steps as under:

1.go to OV31 - Maintan Condition Exclusion Groups.

2. go to OV32 - Assign the discount condition types to the previously maintained condition exclusion group.

3. go to VOK8 - select yur pricing procedure, now select the condition exclusion procedure i.e. best condition between condition types or least favourable within condition type. like that. Save the entries.

4. Now go to VK11 and maintain the condition records of the various condition types. Save the records.

5. Go to VA01 - create the sales order and in the conditions tab you will see the effect of the condition exclusion. Suppose you had selected the best of the condition types, then the system will automatically make the other condition types related to discount inactive. You can double click on a particular condition type and check the status whether it is active or inactive.

I hope I have answered your query. Reward valuable points if solution found useful.

Regards,

Allabaqsh G. Patil

Former Member
0 Kudos

HI,

if your query is answered, reward the points and close the query

REgards,

Murali

Former Member
0 Kudos

Hi Ravi kumar.,

CONDITION EXCLUSION GROUP:

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.

SPRO- IMG- SD- Basic Functions- Pricing- Pricing Control- Condition Exclusion- Cond Exclusion for Group of Conditions:

Define cond exclusion group: OV31

Assign cond types to the exclusion groups: OV32

Assign exclusion to pricing procedure: VOK8

A condition exclusion group is merely a grouping of cond types that are compared to each other during pricing & result in the exclusion of particular cond types with in a group or entire groups. 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.

Actions

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

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

• Enter the condition exclusion group in the pricing procedure that you use in pricing (Go to -> Exclusion groups).

• The condition exclusion indicator is not valid for cond supplements. This means if a cond record contains cond supplements they will be taken in to account during pricing.

• After selecting the pricing proc for which you want the cond exclusion to be Exclusion”.active, select the button “

• Deactivate Exclusion in access sequence when ever you active exclusion group.

• Best / Least cond records, with in cond types

• Best / Least cond record, between cond types

• Best / Least cond record, with in exclusion group

• Best / Least cond record, between exclusion group.

Reward if helpfull

Regards

Narayana

Former Member
0 Kudos

hi,

Path: IMGSALES AND DISTRIBUTIONBUSINESS FUNCTIONS PRICINGCONDITION EXCLUSION--CONDITION EXCLUSION FOR GROUP OF CONDITIONS

1.Define condition exclusion groups: go to new entries and define exclusion group with description and save it for example Z001

2.Assign Condition types to Exclusion Groups:Go to new entries and assign condition types for Example K004,K005,K007 save it

3.Maintain Condition Exclusion for pricing procedure: choose your pricing procedure ,click on exclusion, go to new entries and specify the sequence number and assign condition exclusion procedure

go to Va01 and raise the sales order and go to conditions and check the values

Please reward points if the answer is helpful

REgards,

Murali