Enterprise Resource Planning Blogs by SAP
Get insights and updates about cloud ERP and RISE with SAP, SAP S/4HANA and SAP S/4HANA Cloud, and more enterprise management capabilities with SAP blog posts.
cancel
Showing results for 
Search instead for 
Did you mean: 
Abhi105
Advisor
Advisor
Objective

As we move from the world of ERP Business suit to the world of S/4 HANA, there are many things which are changing in various modules like FI, SD, PP, Output management etc. and the question always arises how is my business going to be impacted, what is the way forward and am I getting into a totally unknown territory? The first thing which anybody would do is to search for topics on SCN blogs, Google, JAM pages which actually a good starting point. However sometimes ( or most of the times ) one finds it a bit difficult to run a hands-on end to end scenario for the new features which is going to be part of S/4 HANA. I faced similar problems while trying to understand “Condition Contract Management” within Settlements Management which is the replacement for traditional “Rebates Management” and hence I thought it would be nice to share my experiences.

 

Description

The blog will cover the following topics :-

  1. Pre-requisites

  2. Introduction

  3. Traditional Rebate Processing

  4. Comparison : Old Vs New

  5. General Process

  6. Step to create condition contract

  7. Sales Flow

  8. Actual Settlement

  9. Credit Memo Display

  10. Business Volume Display

  11. Important Transactions

  12. Useful Tips & Links


 

Pre-requisites

Knowledge of SD Rebate Processing ( to be able to understand the advantages of the new solution )

 

Introduction

Moving into S/4 1610, New Rebate Agreements are no longer available for creation. Yes, you heard it right! You can’t create a new Rebate Agreement neither can you extend existing ones. Subsequent logical question which any sane person would ask now is “How do I provide rebates to my customers then?”

The answer is via Settlements Management.

Next logical question which would be asked is “Alright, but why Rebates Management has been done away with in S/4?”

The answer lies in the difference between the architectures of S/4HANA and traditional ERP business suite. So, before we move into Settlements Management, let’s touch upon how the traditional Rebate processing works to be able to appreciate the advantage Settlements Management offers.

 

Traditional Rebate Processing

As a reference from help.sap.com

 

A rebate is a special discount which is paid retroactively to a customer. This discount is based on the customer's sales volume over a specified time period. You define the details of the rebate in a rebate agreement. In the agreement you specify, for example

  • who receives the rebate payment

  • on what criteria the rebate is based (customer, customer and material, and so on).how long the rebate agreement is valid



  • Within the rebate agreement you create separate condition records for each product the customer buys. These records specify the rebate amount or percentage for each product. You can also specify a pricing scale so that the customer can earn a better rebate by ordering more. Because rebates are always paid retroactively, the system keeps track of all billing documents (invoices, credit and debit memos) that are relevant for rebate processing. The system can, if you wish, automatically post accruals so that the accumulated value of a rebate is recorded for accounting purposes.

  • A rebate agreement is finally settled when you issue a credit memo to the customer for the accumulated rebate total.


 

Comparison : Old Vs New

Let’s focus on the line in bold in the above section.

Question. How does the system keep track of the invoices which relevant for rebate processing?

Answer. Table VBOX stores all rebate relevant invoices. The customer runs transaction VBOF to apply the rebate conditions in the invoices.

Problems:

  1. Size: This Rebate index table could contain hundreds of thousands to millions to billions of entries in the system In fact for one of the customers we noticed 1 TB of data being occupied in total DB size of 5 TB. It won’t not take long for our BASIS, DB & ABAP colleagues to understand the repercussions of such a situation.

  2. Locks: If changes in one customers’ conditions occur the table needs to rebuild; while this rebuild is going on, all rebate data is locked throughout the organization


The solution to these issues lie in the Settlements Management

  1. The table VBOX itself has been done away with in S/4 HANA because the rebate conditions are applied instantly due to power of HANA. Hence Rebate Index need not be rebuild when new customers become eligible for rebates and previous business can be retroactively considered.

  2. This significantly reduces data footprint and memory.

  3. Sales document no longer reduce operations impairment in sales processes


Have a look at a side by side architecture of Rebate Management in Traditional ERP Vs Settlements Management in S/4.



 

General Process



The general process in the CCM differs from the standard Rebate processing in the sense that there are no rebate Agreements at the first step. There are Condition contracts which need to be created and released. The steps for the same are explained in Step 8.

 

Steps to create Condition Contract

  1. Execute transaction WCOCO ( W ko-ko ) and click on ‘Create’.




2. Select the type of contract you would want to create

          

  1. Enter the customer and period for which you want to create the condition contract.    



  1. Enter the Sales data on the 2nd tab                        

  2. Enter the business volume selection criteria. This steps defines which invoices are relevant for application of this condition contract.

  3. Enter the settlement Material

  4. Enter the Settlement Calendar. This step defines when you would like to carry out partial/final settlements.



  1. Create Rebate Accrual condition

  2. Change condition Table

  3. Create Rebate condition

  4. Save the Condition Contract

  5. One thing is of utmost import is to release the contract. Hence release the contract in WCOCO

  6. Once done the light will become ‘Green’. Save it.


 

Sales Flow

I won’t be explaining how to create a Sales document, Delivery, PGI, Invoice etc but what needs to be mentioned is that either these documents can be created before the condition contract creation or after the condition contract creation. In case Sales document is created after the contract creation, REBA accrual condition would be available in the conditions tab.

Don’t worry about the 7 % as opposed to 10 % I created earlier as this is from a different example.

In case the Sales document is already created before the contract creation, the rebate would be provided as part of the settlement process and rebate condition would be visible in Credit memo which will book the correct accrual amount to the respective accounts. So there is no need to adopt the Sales order anymore.

 

Actual Settlement

Run transaction WB2R_SC and enter relevant values. Please note that Run Type ‘Check Run’ does not post any data. For actual settlement use ‘Live Run’.

 

Once executed, you will get a message like shown below

 

Credit Memo

In WCOCO, you can see a credit memo created with relavent values



In the Header conditions, you will find the Rebate condition we had created as part of the condition contract.

 

Business Volume

Run transaction WB2R_BUSVOL,



As you can see below, business volume 1.5 is updated against the condition contract

 

Important Transactions

There is a whole list of important transactions for the new Settlement management solution.

 

Useful tips and Links

  1. Condition contract settlement is also available in the SAP Business Suite. Therefore you use condition contract settlement if you are planning to create new rebate agreements before you upgrade to SAP S/4 HANA.

  2. SAP Business Suite customers can move from various releases to SAP S/4 HANA, on-premise edition and still process the existing rebate agreements. It is not possible to create or extend the existing type rebate agreements.

  3. Help SAP - Condition Contract LINK

  4. Help SAP - Condition Contract Based Settlement LINK

  5. S/4HANA OP1610 simplification list LINK

  6. Settlements management is also available on FIORI apart from SAP GUI.

  7. Configuration steps


 
81 Comments
Abhi105
Advisor
Advisor
0 Kudos
Hi Max,

Its available in every S/4 release...

 

Best,

Abhinav
0 Kudos
Hi Gurus,

I am facing a problem regarding a similar issue, when i run the transaction WB2R_SC  the results is Ok (green) but the I got a mensage  ” Document $$00000001 has status C and is complete“,and when I try to find or open that number the document is not created.

I review the custo about the calculation,condition contract type, the number ranges for the  Settlements  document  and in the table WBRK can`t see the documents.

Any idea?

best regards

Rogerio

 
former_member411137
Discoverer
0 Kudos
Hi Gurus, Wonder why the amount of the condition type REBA could be different of the amount of the condition type REBT.
0 Kudos
Hi,

As far as I know, SAP was not able to accrue / pay the rebate based on different VAT rates. If I create a rebate agreement for a customer (for example a rebate of 1% for all products belonging to material group “X”), the dummy material for settlement, linked to the material group, would provide important data as account assignment or tax determination. From a tax point of view, the different products in material group X could have different tax code, and SAP would pick the tax classification up only from the settlement material. Hence, we could not have splits by tax codes. Is this as I have explained? Is there any solution for S4 HANA?

Regards,

Daniel
Abhi105
Advisor
Advisor
0 Kudos
You can split based on tax code and material. Infact you can customize the field based on which you want to split.
Abhi105
Advisor
Advisor
0 Kudos
Try the live mode
0 Kudos
Hello Abhinav,

 

Thanks for your blog.

May I ask a question about con.con.type C001, C002, C003.

C001 /C002 are descripted as "condition contract for eligible customer list",  and C003 is for standard conditions.

do you have any further detail share about them?

Regards

Ruby
Former Member
0 Kudos
Hi, I have a question related to transfer manager. Once a settlement document is created the division from the condition contract flows into to FI and copa. We have a business requirement where we want to pass the material master division to fi and copa during the settlement process. Somehow not able to find the transfer group related to material division. Can anyone direct me to he right direction.

 
camillaeikeland
Discoverer
0 Kudos
Hi Abhinav,

Thanks for your shared information. I am trying to configure the process in SAP ERP 6.0 EHP8. I am wondering if it is possible to use the fiori apps in this version, or whether that will only work from S/4 hana?

 

Br Camilla

 

 

 
0 Kudos

Hi,

I have a question.

How can we mass upload existing agreements to S/4 from ECC?

Is it done through LSMW? Any other solution?

Thanks in advance.

former_member576999
Discoverer
0 Kudos
Hello Experts ,

I am mapping Rebate process into settlement managment -

1.Exchange Rate - I

f billing date (FKDAT)  and settlement date (Partial / Final) is different then exchange rate for currency will different how we can fix this issue.

2.Business volume determination -

If we remove "rebate" relevance flag for billing document (TVFK) system doesn't consider it while calculation of business volume (Table - VWB2_VBRKVBRP_1) but in the same way it doesn't work for customer master "Rebate " flag.

 

Thanks in advance.

 

Regards,

Nilesh
former_member610273
Discoverer
0 Kudos
Good Morning, I have configured the settlement documents but I have error in the accounting entries.

When the settlement is generated I reverse de provision but also the custumers seats, so it cancels the sale and provision.

someone could help me?

I have pictures of errors if someone have the solution.







thanks!!

 

 

 
former_member3255
Discoverer
0 Kudos
Hi Abhinav,

 

While running settlement Program, i am receiving an error message.

Pricing Procedure could not be determined "WS220"

i checked pricing procedure, as per SAP standard 0S,0T,0U,0V are assigned to PP. anything else to be checked.
0 Kudos
Hi Ravi,

 

Have you got any solution for this?

 

Thanks

Sach
sabine_s
Member
0 Kudos

Hello Experts ,

We are working on the migration of rebate agreements  in ECC to contracts of conditions in S/4.

Most of rebates agreements in ECC are available from 1st day of the Year to the end of the Year.

The migration is planned in the middle of a year.

 

And I’m facing to 2 problems :

How did you migrate Business Volume for ECC to S/4 ? dis you use a Z table in  “profiles for Business Volume Determination”?

How did you integrate the amount of partial settlement to reduce the final settlement ?

 

Thanks in advance

 

Regards,

Sabine

Anjhi
Contributor
0 Kudos
Well presented..!!
Pankaj_M
Participant
0 Kudos
Thanks a lot Abhinav…Its nicely explains the concept.

One doubt regarding the settlement process, I want to do the partial settlement every month. How i can configure so that every month the partial settlement will create for the business volume for that month.

Appreciate your help.

Thanks and Regards,

Pankaj

 
former_member193516
Active Contributor
0 Kudos
Nice wiki!

 

Did some one got a solution to the dupliate key error? We have this as well and are stuck on this ...

 

 

Thanks

Hein
Ashish3
Explorer
0 Kudos
Hi guys,

I am looking to add custom fields to the table VWB2_VBRKVBRP_1 for Business volume. We have to build some custom logic based on the custom fields. Is this possible?

Basically we have to look at last year sales history and give rebates based on sales growth from last year.

Any suggestions are greatly appreciated.

Thanks

AS
former_member664346
Discoverer
0 Kudos
Hello

 

I am facing the error "

The pricing for line item 000001 of document $$00000001 could not determine an Output Tax code. This means that the line item is not created properly." while trying to do the settlement. Can anyone please help. anybody encountered same issue?

 

Thanks

Subhasis Dutta
former_member657939
Discoverer
0 Kudos

Hi Dutta,

 

I’m also getting same issue while settlement, if this issue resolve for you can you please share solution with us.

 

Thanks,

0 Kudos
Nice blog.
0 Kudos
Hi Guys,

i have configured the condition contract management as described here. I have done a partial settlement for a periode 1 for example and a credit memo has been created. In periode 2 i am creating a second partial settlement with a credit memo but the already settled invoices in periode 1 are also taken in account in periode 2.

Can somebody help to understand why ?

Best regards

Philippe
luchita81
Participant
0 Kudos

Hello Folks,

I'm trying to settle a contract without taxes for US scenario (due to the company activity sales taxes are not needed) and I get errors when I execute t-code WB2R_SC when trying to do the partial settlement.

I have changed the US standard pricing schema removing all taxes condition types because they are not needed (see screens attached) also I removed the tax flag "Calculate tax amount" under "Define Settlement Process Types" for ZS10 Sales Rebate Credit option and I'm still getting errors, the system is asking me for the taxes.

Anyone has any idea on how to avoid taxes determination in partial/final settlement for US?

 

Thanks in advanced.

L.

 

jmoralescalvo
Explorer
0 Kudos
Great blog! I have a question, have you ever encountered a rebate based on the sales performance of a product you buy from a specific vendor? For example, vendor gives you an incentive that for every unit sold in a specific period, they will give you a $1.00 rebate on each item sold. The sale is not based on a specific purchase, but on the sale itself. Thanks.
0 Kudos
Fantastic Blog!

I am looking for solution to process rebate for PAID/CLEARED customer invoices. Has anyone done? Thanks.
matthias_sauer
Explorer
0 Kudos
If the Settlement Contract is maintained for the Validity Period which would include those Billing Documents you can run the retroactive postings and include them in the rebate calculation. The only important fact to it would be that you wont see the updated Rebate or Accrual postings in the Invoice Pricing but the Rebate Amount will be updated accordingly. Check for Retroactive postings in the SAP documentation. Hope thi will help.
ashish_shah
Contributor
0 Kudos
Hello Abhinav,

Thanks for sharing your knowledge in this blog, rally helpful.

During purchasing rebate settlement document creation process , do you know how to store SAP  MIRO supplier invoice number ( RBKP-BELNR) in table WBRK/WBRP , in standard settlement management process i did not find this information anywhere in these tables.

Regards,

Ashish Shah
imran_mukaddam2
Explorer
0 Kudos
Hello,

Extending the WCOCO condition tables to introduce additional fields other than condition contract and material does not work as we do normally with condition types as sales order level and then transfer the field catalogue in user exit to determine condition records. Instead we had to extend the business volume table to achieve the filtering and then apply rebate on it via standard rebate condition . Drawback here is that customer will have to create as many condition contracts as the business volume differs. Please could you advise or refer sap documentation on this area for the recommended approach.
Aschiau
Discoverer
0 Kudos

Thank you very much for the great explanation.

We started to work with the settlement this year and now we have to make the final settlement with transaction WB2R_SC.

We decided to not post the credit notes automatically.

Does anybody know a transaction that can post more than one settlement document at the same time?

Thank you in advance for your help.

Aschiau
Discoverer
0 Kudos
The transaction I was looking for is WAB_RELEASE.

I leave it here if somebody doesn't know it.