on 07-01-2007 7:17 AM
Hi Gurus,
Tell me the process of Condition Exclusion step by step...
MAIL ID: ravikumar.talluri@gmail.com
Rewards will be given
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
HI,
if your query is answered, reward the points and close the query
REgards,
Murali
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
89 | |
8 | |
7 | |
4 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.