Pricing : Condition type value need tog get from the lowest of 4 other cond

[Former Member]

Hi,

I have one requirement in one pricing procedure.

I need to calculate condition value of one condition type from the lowest value of other 4 condition tyeps. These condition types values are not defined as a subtotal.

So if I decide to write a formula on condition values, is there

any way to select these values and choose the lowest of them?

Please also advice if there is any other way such as condition exclusion

or so?

Thanks and regards,

Anand

[Former Member · Accepted solution]

Anand,

As you have mentioned you can use condition exclusion for such a requirement.

here is a detailed description of how you can achieve this: use the menu path IMG> Sales & Distribution> Basic Functions> Pricing> Condition Exclusion> Condition exclusion for group of conditions.

When you execute this IMG acitivity you get a window with three options

1.Define Condition Exclusion Groups

2.Assign condition types to the exclusion groups

3.Maintain condition exclusion for pricing procedures

We will use these three options one by one, we start with the first

1. Define an exclusion group, lets say EX01 and give a description

2 Assign the four condition types that you want to compare to this exclusion group under this option

lets say EX01 ZK01

EX01 ZK02

EX01 ZK03

EX01 Zk04

3. under this third step, select the pricing procedure that you are working on and from the left margin click on 'Exclusion'. click on 'New Entries' and make the following entries (example)

Sno. Cpr ExGr1

10 A EX01 leave ExGr2 blank, Save your entries

Check if your purpose has been met or not. Do give your feedback

Regards,

PATHIK

[Former Member]

Hi there,

Define all the 4 condition types & assign them into your procing procedure.

Define a new condition exclusion group & put your condition types into it.

In the Maintain condition exclusion for pricing procedures, define the rule how you want to select a required condition like lowest among the group or highest among the group.

Regards,

Sivanand