Settlement Management – Transfer Manager and Split Criteria for Settlement

[milly12345]

Table of Contents

1. Overview & Business Case
2. System Used
3. Perquisites
4. Configuration
  4.1. Pricing
  4.2. Transfer Manager
  4.3. Split Criteria for Settlement Document
5. Demo Video
6. Conclusion 

 

1. Overview & Business Case

I recently encountered a business case in settlement management, and I would like to share it with you.

Our client had a Sales Rebate Scenario, where there is a main customer and there are several sub-customers underneath him, these sub-customers can reach up to 100 customers. The main customer gets a rebate for his business volume and another rebate for each of the sub-customers’ business volume when they buy materials that belong to a certain material group. These discounts vary from one sub-customer to another, the below example can be used for more clarification.

Payer	Rebate Amount	Business Volume to be considered	Rebate Recipient
Main Customer	(500) $ Per 1 Piece (for Material Group A)	Main Customer	Main Customer
Sub-Customer1	(350) $ Per 1 Piece (for Material Group B)	Sub-Customer1	Main Customer
Sub-Customer2	(150) $ Per 1 Piece (for Material Group B)	Sub-Customer2	Main Customer

 

2. System Used

S/4 Hana on Premise Demo Server, Release 2021.

 

3. Perquisites

Understanding of how S4Hana Sales Rebate Management works and its required set up, as this blog focuses more on the workaround used to achieve the business requirement.
If you want to know more about the delivered configuration and process description, you can check the below SAP Notes which provide an excellent guide.

2815535 - FAQ: Condition Contract Management by Settlement Management in SAP S/4HANA.

2535889 - CCM - Description of delivered configuration.

2481672 - Condition Contract Management - Useful Documents.

2564353 - Condition Contract Management: Product Overview Documents.

 

4. Configuration

4.1 Pricing

• Create a new condition table

Note that the customer used is Customer Hierarchy (HEINR).

 

Transaction	SPRO
Path	SPRO > Logistics – General > Settlement Management > Basic Settings > Pricing > Sales (SD) > Define Condition Tables > Create Condition Tables

Condition Table

• Create a new access sequence

Transaction	SPRO
Path	SPRO > Logistics – General > Settlement Management > Basic Settings > Pricing > Sales (SD) > Define Access Sequences

 

Access Sequence

Access Sequence - Field Catalogue

 

• Create a new condition type
  Note that (ZRE1) is a copy of standard Condition type (RES1)

Transaction	SPRO
Path	SPRO > Logistics – General > Settlement Management > Basic Settings > Pricing > Sales (SD) > Define Condition Types

Condition Type

 

• Assign the condition type to the pricing procedure used for Rebate and Rebate Accrual, and follow the rest of the standard set up to complete the configuration. 

 

4.2 Transfer Manager

We want to copy the data from the source Field (CUSTOMER) in the source structure table (KOMLFP) to the target field (HIENR04) in the structure table (KOMK). This will make sure that the condition record maintained in the condition contract and the customers with which the sales were achieved will be transferred properly to the settlement document and the header pricing.

 

Transaction	SPRO
Path	SPRO > Logistics – General > Settlement Management > Settlement Documents > Specify Settings for Transfer Manager > Define Transfer Groups.

 

• Choose Transfer Event (21-Fill Pricing Header Customer) and create transfer group (0S01-Sales Rebate) and enter the below entries as indicated in the screenshot.

 

Transfer Event

Transfer Group

• Assign Transfer Group to settlement document type.

Transaction	SPRO
Path	SPRO > Logistics – General > Settlement Management > Settlement Documents > Specify Settings for Transfer Manager > Define Transfer Groups > Assign Transfer Groups to Settlement Document Type (via Event)

 

Transfer Group Assignment

 

For more information on transfer manager check this blog created by Serkan Ozel

https://blogs.sap.com/2022/01/20/transfer-manager-functionality-in-settlement-management/

 

4.3 Split Criteria for Settlement Document

• I wanted to create a separate settlement item for each customer (Main and Sub-Customer) to track their business volume and the specific discount applied, all of these settlement items will be included in one settlement document (Credit Memo) and for one contract recipient (Main Customer).

Transaction	SPRO
Path	SPRO > Logistics – General > Settlement Management >Condition Contract Management > Condition Contract Settlement > Define and Configure Profiles for Business Volume Determination.

 

Profile for Business Volume

 

Transaction	SPRO
Path	SPRO > Logistics – General > Settlement Management >Condition Contract Management > Condition Contract Settlement > Specify Settlement Settings for Condition Contract Types

Assign Business Volume Profile to Condition Contract

 

5. Demo Video

Watch the following short video for the Condition Contract's creation and settlement on Fiori for the above-mentioned business scenario.



 

6. Conclusion 

This is how I tried to meet the customer requirement by utilizing Transfer Manager and Split Criteria for Settlement, I would be happy to read your thoughts and comments, and if there are better ways to fulfill the requirement, please leave it in the comment section below.

Many Thanks!