Settlement Management-Amount field value deducted by rebate amount from different Condition Contract

[former_member862893]

Hello SAP Experts,

I would like to open the topic that I'm dealing with. Let's imagine that I have multiple SD rebate processes (ZZ01, ZZ02, ZZ03) that are relevant for one customer. I'm using the Process variants in the Condition Contract to split the logic. But now I have the scenario in that I need to take over the net price from SD invoice item - (minus) rebate bonuses that going to be paid, here is the example:

Invoice 10000001 Item 10

Net value 1000 EUR

Rebate bonus ZZ01 - 6% from Net value (1000) = 60 EUR

Rebate bonus ZZ02 - 10% from Net value (1000) = 100 EUR

But the topic is below

Rebate bonus ZZ03 - 10% from (Net value- Assumed rebate bonuses) -> 1000 - 60 - 100 = 840 * 0,1 = 84 EUR

Since the bonuses are independently set in their own Condition Contracts how can I deduct the net price received from SD invoice. Here are my thoughts:

• Add Rebate/Accrual condition in SD Billing document pricing scheme

But here I will have a problem in case that the rates will change in the future. For example scenario ZZ01 from 6% to 8%. This will not influence the pricing and Price base for ZZ03 will be incorrect.

· Something like Subsequent document or 2-step rebate scenario

I'm not sure how it could work

So thank you for any ideas.

Best Regards, Tomas

[gvictor · Accepted solution]

Hi tomas_kolnik,

You are explaining what I call a cascading rebates calculation, rebate that influence the next calculation.

That's very complex scenario which is dependent of various criteria (same date of validity, rate changes, returns, also dependent of the date of settlement for each contract, time of execution....).

I already encountered this type of business and calculations, most likely the business was used to old ECC SD rebate and we could manage that in old ECC world by the lack of limitations and architecture.
In S/4 that completely another story.

On top of my head, I would propose the following options:

Option: Client is willing to think and drop this type of calculation

Option 2: You will have to include the ZZ01 and ZZ02 in your contract where you maintain ZZ03. ZZ01 and ZZ02 will be calculated in the settlement to influence the basis amount of calculation for ZZ03 but will not be considered for the posting.

Option 3: You will have to structure your condition contract type to consider the billing documents as expected + the settlement amounts calculated and posted with the settlements coming from Contract with ZZ01 and ZZ02 (other condition contract type required as new profile of business volume).
Option 3 is highly dependent on time execution, period of validity, settlement dates, errors and reversals.
I would not recommend it unless that's the last option.

Regards,
Gauthier V.

[former_member862893 · Accepted solution]

Hi Victor,

Thank you for the response and great hints you provided. I had an idea how to solve it by adding a new CDS view as additional business volume table which will provide amounts from Settlement documents what is basically your option 3.

To be honest each way has own pros/cons and we will need to discuss which was to go. I was curious whether there could be a SAP standard solution which will be more straight forward.

And once again thank for the answer.

Best regards, Tom