SAP Material Management
Pricing
CONDITION EXCLUSION PROCEDURE
Condition Exclusion Procedure
“F”
Least Favorable Conditions between
2 Condition Exclusion Groups
(you may skip slides 2-14 if
you have seen the Condition Setups in
the other Procedures PPTs presentation)
Vendor T-K521D20 will be using Pricing Schema ZM0020
Create Info Record 1
Vendor T_K521D20
Material T-REK20
Plant 1000
Pur.Org 1000
Create Info Record 1
Planned DelTime 7
Pur.Group Z51
Std Qty 100
Set this Conditions
Z20A 10 EUR/pc
RA01 2.5%
Create Info Record 2
Vendor T_K521D20
Material T-REL20
Plant 1000
Pur.Org 1000
Create Info Record 2
Planned DelTime 7
Pur.Group Z51
Std Qty 100
Set this Conditions
Z20A 100 EUR/pc
RB00 2 EUR
Set the following Scale for RB00
RB00 is set
with SCALEs
Create Info Record 3
Vendor T_K521D20
Material T-REM20
Plant 1000
Pur.Org 1000
Create Info Record 3
Planned DelTime 7
Pur.Group Z51
Std Qty 100
Set this Conditions
Z20A 20 EUR/pc
Set
ME_USE_GRID = ‘X’ for
user
Define Vendor Discount for
T-K521D20
This is ALV Grid display via ME_USE_GRID.
Select to highlight this line and click “Create” icon
Vendor Discount
is 1%
We now have created the following for Vendor T-K521D20
PIR#1 material T-REK20
GrossPrice PB00 10 EUR/pc
Discount RA01 2.5%
PIR#2 material T-REL20
GrossPrice PB00 100 EUR/pc
Discount (value) RB00 from 1 pc - 99 pc is 2 EUR
Discount (value) RB00 from 100 pc is 5 EUR
PIR#2 material T-REM20
GrossPrice PB00 20 EUR/pc
Vendor General Discount for all Material
Discount RL01 1%
In the next Slides, we shall be setting up Condition Exclusion
IMG - MM
- Purchasing
- Conditions
- Define Price Determination Process
- Define Condition Exclusion
Define Condition Exclusion Groups
Create 2 Exclusion Group
A## and B##
one for Material discount and another for Vendor discount
We now have created the following for Vendor T-K521D20
PIR#1 material T-REK20
GrossPrice PB00 10 EUR/pc
Discount RA01 2.5%
PIR#2 material T-REL20
GrossPrice PB00 100 EUR/pc
Discount (value) RB00 from 1 pc - 99 pc is 2 EUR
Discount (value) RB00 from 100 pc is 5 EUR
PIR#2 material T-REM20
GrossPrice PB00 20 EUR/pc
Vendor General Discount for all Material
Discount RL01 1%
In the next Slides, we shall be setting up Condition Exclusion
Assign Condition Exclusion Group
A20
to
RA00
RA01
RB00
RC00
Assign Condition Exclusion Group
B20
to
RL01
Assign Condition Types to the Condition Exclusion Groups
Assign Condition Exclusion Group
A20
to
RA00
RA01
RB00
RC00
Assign Condition Exclusion Group
B20
to
RL01
Activate the Condition Exclusion Groups for relevant Calculation Schemas
For Calc.Schema
ZM0020
Double-click
Eclusion folder
The system takes the LEAST Favorable Condition compare to the Conditions in the two Groups
We now have created the following for Vendor T-K521D20
PIR#1 material T-REK20
GrossPrice PB00 10 EUR/pc
Discount RA01 2.5%
PIR#2 material T-REL20
GrossPrice PB00 100 EUR/pc
Discount (value) RB00 from 1 pc - 99 pc is 2 EUR
Discount (value) RB00 from 100 pc is 5 EUR
PIR#2 material T-REM20
GrossPrice PB00 20 EUR/pc
Vendor General Discount for all Material
Discount RL01 1%
In the next Slides, we shall be setting up Condition Exclusion
RA01 is in Condition Exclusion Group 1
at 2.5% it is a better discount than 1% below
RL01 is in Condition Exclusion Group 2
at 1% it is LEAST Favorable
RA01 is de-activated is it is a better discount.
(remember our RULE now is to select Discounts which is Least Favorable)
Vendor Discount is Least Favorable and it is selected
We now have created the following for Vendor T-K521D20
PIR#1 material T-REK20
GrossPrice PB00 10 EUR/pc
Discount RA01 2.5%
PIR#2 material T-REL20
GrossPrice PB00 100 EUR/pc
Discount (value) RB00 from 1 pc - 99 pc is 2 EUR
Discount (value) RB00 from 100 pc is 5 EUR
PIR#2 material T-REM20
GrossPrice PB00 20 EUR/pc
Vendor General Discount for all Material
Discount RL01 1%
In the next Slides, we shall be setting up Condition Exclusion
RA01 is in Condition Exclusion Group 1
RL01 is in Condition Exclusion Group 2
RB00 2 EUR discount from the PIR is the LEAST Favorable and it is selected
Vendor Discount RL01 at 10 EUR is a better discount and therefore it is De-activated due to the Strategy in this DEMO
Bear in mind, in this demo we are using Condition Exclusion Procedure “F”
Least Favorable Conditions between 2 Condition Exclusion Groups
We now have created the following for Vendor T-K521D20
PIR#1 material T-REK20
GrossPrice PB00 10 EUR/pc
Discount RA01 2.5%
PIR#2 material T-REL20
GrossPrice PB00 100 EUR/pc
Discount (value) RB00 from 1 pc - 99 pc is 2 EUR
Discount (value) RB00 from 100 pc is 5 EUR
PIR#2 material T-REM20
GrossPrice PB00 20 EUR/pc
Vendor General Discount for all Material
Discount RL01 1%
In the next Slides, we shall be setting up Condition Exclusion
No discount found in the PIR
and
no discount and this is suppose to be LEAST Favorable
RL01 is in Condition Exclusion Group 2
It seems that the system still choose the Vendor Discount !
We now have created the following for Vendor T-K521D20
PIR#1 material T-REK20
GrossPrice PB00 10 EUR/pc
Discount RA01 2.5%
PIR#2 material T-REL20
GrossPrice PB00 100 EUR/pc
Discount (value) RB00 from 1 pc - 99 pc is 2 EUR
Discount (value) RB00 from 100 pc is 5 EUR
PIR#2 material T-REM20
GrossPrice PB00 20 EUR/pc
Vendor General Discount for all Material
Discount RL01 1%
In the next Slides, we shall be setting up Condition Exclusion
No Discounts found in PIR
no discount and this is LEAST Favorable
RL01 is in Condition Exclusion Group 2
It seems that when there is no Discount from PIR to compare to the vendor discount, the system will use RL01 from the vendor discount in this case !!!!