Volume discount based on value or cumulative tonnage with time frame

1382 Views

Hi there,

I have the situation as explained in the scenario below:

Sales Contract

Validity: 1.1.2008 - 31.12.2008

Material 241 - 5000 MT (metric tonne)

-

We then defined a discount breakdown as follows:

Discount Breakdown (defined in the Sales Contract)

Qty :: Discount

0 - 1000 :: 5%

1001- 2000 :: 7%

2001 - 3000 :: 10%

3001 - 4000 :: 13%

4001 - 5000 :: 15%

-

We then create the following Sales Order with reference to the Sales Contract:

Sales Order (released based on Sales Contract)

Order :: Date :: Qty :: UOM :: Discount Applicable

SO-001 :: 15.1.2008 :: 900 :: MT :: 900 x 5%

SO-002 :: 10.2.2008 :: 500 :: MT:: 100 x 5% and 300 x 7%

Accumulated 1400

SO-003 :: 1.3.2008 :: 800 :: MT :: 700 x 7% and 100 x 10%

Accumulated 2200

-

As you can see above, the discount is calculated and given based on accumulated quantity. In the first sales order for 900 MT, it is still within the 0-1000 range thus a 5% discount is applied. Where-as in the second Sales Order for 500 MT, 100 MT is given 5%. Once this has happened, it has exceeded the discount bucket for 5% and thus the remainder 400 MT is given 7%.

Is there anyway to setup the above scenario without customization in standard SAP?

Thank you.