Skip to Content
Product Information
Author's profile photo Marwa Mekky

Settlement Management – Transfer Manager and Split Criteria for Settlement


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%20Table

Condition Table

  • Create a new access sequence
Transaction SPRO
Path SPRO > Logistics – General > Settlement Management > Basic Settings > Pricing > Sales (SD) > Define Access Sequences

 

Access%20Sequence

Access Sequence

Access%20Sequence%20-%20Field%20Catalogue

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%20Type

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%20Manger

Transfer Event

Transfer%20Group

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%20Group%20Assignment

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%20for%20Business%20Volume

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%20Business%20Volume%20Profile%20to%20Condition%20Contract

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!

Assigned Tags

      7 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Anjikumar Pasumarthy
      Anjikumar Pasumarthy

      Well done..!!

      Author's profile photo Marwa Mekky
      Marwa Mekky
      Blog Post Author

      Thank you!

      Author's profile photo Eslam Ali
      Eslam Ali

      thanks for sharing this valuable information

      Author's profile photo Marwa Mekky
      Marwa Mekky
      Blog Post Author

      Thank you, Eslam!
      I’m glad you find it useful.

      Author's profile photo Mohamed Kamal
      Mohamed Kamal

      This blog is amazing! thanks a lot for sharing

      Good job ya Marwa 🙂

      Keep going

      Author's profile photo Marwa Mekky
      Marwa Mekky
      Blog Post Author

      Many thanks, Kamal. I appreciate it!

      Author's profile photo Bhaskar Reddy Thopudurthy
      Bhaskar Reddy Thopudurthy

      Thank you Marwa for the details. One question what is the SAP Package we need to select while creating the condition table in pricing.