recursive discount 10%/5%/1%

[Former Member]

Hello,

I have the following requirement : If the customer buy 100 PC at 10€ = 1 000€ with a discount of 10% and after 5% and after 1% (it is different of a discount of 16%). It is recursive discount!

I must calculate like that :

1/ For the first discount, it is standard :

1 000 € *10% = 100€

2/ I must calculate the second discount on the basis value of the first discount :

(1 000 – 100)€ *5%  = 45€

3/ I must calculate the third discount on the basis value of the second discount :

(1000 – 100 – 45)€ * 1% = 8,55€

Total  = 153, 55€

It is just an example, we can have multiple scales in different order:  4 steps 2%/6%/8%/10% or 2 steps 5% after 2%... it depends !!

In standard

-          V/06 my idea is to create a specific condition type  ZK09 calculation type A in

-          VK11 ZK09 10% with  condition supplement ZK09 5% and third condition supplement  ZK09 1%

The standard result is:

ZK09 -1 - 10,000 %                                          100,00

ZK09 -2 - 5,000 %                                           50,00

ZK09 -3 - 1,000 %                                           10,00

Total = 160€ (like 16%)

But how can I specify the second condition is base on the result of the first condition? .. etc…

I can create a pricing procedure in my condition type ZK09 to specify that but in the same pricing procedure I can’t only use once the condition type (message VT 505) and I don’t want to create multiple conditions, I must replicate the same condition..

Do you have a better idea?

I can try with a scale formula in my condition type?

Thanks a lot

[jignesh_mehta3 · Accepted solution]

Hello,

You will have to use multiple Sub-Totals in  your Pricing Procedure to achieve this.

Say:

Step 100 Basic Price = 1000

Step 110 Discount 10% of Step 100 = 100

Step 120 Subtotal = 900 (Step 100 - Step 110)

Step 130 Discount 5% of Step 120 = 45

Step 140 Subtotal = 855 (Step 120 - Step 130)

Step 150 Discount 2% of Step 140.... & so on.

You will have to maintain seperate Condition Type for each Discount i.e. 10%, 5%, 2%. etc & respective Condition Records.

Thanks,

Jignesh Mehta

[Former Member · Accepted solution]

Yes it works, but I shall wish not to create a new condition for every step and for every sequence access... It will multiply my combination!

[jignesh_mehta3 · Accepted solution]

Hello,

This is just a one time activity. Once the Condition Records are maintained properly they will flow automatically in Sales Order Pricing.

Also as the number of Discounts are nnot fixed (as you mentioned sometimes it can be 2 discount & sometimes it can be 4 discounts) going for Z-Development will not be feseable. Also as the SAP Standard is available, there is no need for new Zscale formula.

Thanks,

Jignesh Mehta

[eduardo_hinojosa · Accepted solution]

Hi

You can control if the subsequent discounts apply or not with requirements (VOFM) in your pricing procedure. See SAP Note 156230 - Requirements: What is permitted, what is not?

I hope this helps you

Regards

Eduardo