Sales Condition Contract Manual settlement document shows positive amount while automatic settlement

[RafiqSAPSD]

When I am creating manual settlement document via WB2R_DOC_ENTRY system created a settlement document with positive amount, when I check conditions I found RENT condition type at the item level.

while when I create automatic settlement document through WB2R_SC it shows negative value, please help me understand.

looking forward to understand the relationship.

thanks in advance for your help.

Rafiq

[GauthierVictor · Accepted solution]

Hi @RafiqSAPSD, 

The difference you’re observing between manual and automatic settlement documents in SAP CCM is based on how the sign determination logic is applied in each case.

1. Automatic Settlement (via WB2R_SC):
   For automatic settlements, the sign determination is governed by the logic in the underlying Business volume CDS views used by the system. The system evaluates the data from the condition contract and applies the rules defined in the CDS view logic. 
   + check the logic maintained in the Settlement document setting and define how the system should handle negative amount, by default it's usually "3 - Change Settlement Doc Type if Partner posting - if required" 
   + Setting on Country/region and Company code level, if you allow negative amount for the combination Country/Region. 

   

2. Manual Settlement (via WB2R_DOC_ENTRY):
   For manual settlements, the sign determination depends on the values maintained during the creation of the manual settlement document. Typically:

   • A positive amount is entered directly in the document.
   • If the settlement item category is set as "Return Item", the system interprets this as a negative amount, effectively reversing the sign of the condition value.

This behavior allows flexibility in manual settlements, enabling the user to override or adjust the settlement logic manually. On the other hand, automatic settlements rely on predefined system logic to ensure consistency and accuracy.

I hope this clarifies the relationship between manual and automatic settlement sign determination. 

Regards, 
Gauthier Victor 

[RafiqSAPSD · Accepted solution]

Hi Gauthier Victor,

[HariBoyapati2]

Hi Rafiq,

In Manual settlement document, RENT condition type is used for the settlement amount. The settlement amount entered in the initial screen will be copied into this condition type. The same amount will be copied to REA5 condition type with negative sign. REA5 in general is used to post the accruals to settlement index table WCOCOF from settlement document. In case of manual rebate settlement document, REA5 condition type will be used to reverse accruals for the manual settlement. Hence you will be seeing the REA5 with negative value in the manual rebate settlement document and in WCOCOF it will be posted with positive value.

In WB2R_SC, you might have seen negative value for any of the below two reasons.

a. You did the manual settlement of the condition contract and then went for the WB2R_SC for the same contract. In manual settlement you might have settled more than the eligible amount. example: Based on the business volume, customer is eligible for $5000 as rebate. You have settled $6000 through manual settlement. Now if you go with WB2R_SC, you will see -$1000.

b. As Gauthier Victor said, check if there any returns or credit memos exist in the business volume. Returns and Credits will reduce the rebate amount.

Below screenshots is from manual rebate settlement document. ZRA5 has negative sign.

Accruals will be posted to WCOCOF table with +sign(reduces the accruals by the settlement amount).

Hope this helps.

Regards

Hari

[RafiqSAPSD]

@Hari59 : Thanks for your detailed explanation, my ambiguity is clear now pertinent to manual settlements.

[GauthierVictor]

Hi @RafiqSAPSD, 

The difference you’re observing between manual and automatic settlement documents in SAP CCM is based on how the sign determination logic is applied in each case.

1. Automatic Settlement (via WB2R_SC):
   For automatic settlements, the sign determination is governed by the logic in the underlying Business volume CDS views used by the system. The system evaluates the data from the condition contract and applies the rules defined in the CDS view logic. 
   + check the logic maintained in the Settlement document setting and define how the system should handle negative amount, by default it's usually "3 - Change Settlement Doc Type if Partner posting - if required" 
   + Setting on Country/region and Company code level, if you allow negative amount for the combination Country/Region. 
   
   

   

2. Manual Settlement (via WB2R_DOC_ENTRY):
   For manual settlements, the sign determination depends on the values maintained during the creation of the manual settlement document. Typically:

   • A positive amount is entered directly in the document.
   • If the settlement item category is set as "Return Item", the system interprets this as a negative amount, effectively reversing the sign of the condition value.

This behavior allows flexibility in manual settlements, enabling the user to override or adjust the settlement logic manually. On the other hand, automatic settlements rely on predefined system logic to ensure consistency and accuracy.

I hope this clarifies the relationship between manual and automatic settlement sign determination.

Regards, 
Gauthier Victor 

[RafiqSAPSD]

Thanks for your detailed explanation, I am trying to understand the fundamental reason for manual settlement Condition type RENT determined does that offsets with any other condition type as I found REA5 has same vale as in negative sign at the item condition, but secondly when I look at the WR2R_BUSVOL manual settlement amount offsetting the automatic amount is in negative value, what does this mean, can you please help me understand this standard behaviour, thanks in advance. Rafiq

[GauthierVictor]

Hi @RafiqSAPSD, 

I would recommend you to review the configuration guide - CCM_Sales_Rebates_Standard_Configuration - provided by SAP in the KBA 2535889 - CCM - Description of delivered configuration. 
Each condition types and pricing schema used for SAP CCM is described and explained.

Here the following explanation for REA5 and RENT: 
"Condition type REA5 Rebate AccrualsSettl has the same parameter values as REA2. You use this condition type in a settlement run for the amount of the accruals index update, see pricing procedures A10005 and A10007 in chapter Define Pricing Procedures. All parameter values are identical with values for REA2. So, note the Accruals checkbox in the Control Data 2 group box. It’s a manual condition type without access sequence because the condition amount is determined by the settlement program. To control the transfer to the pricing procedures in the settlement run, you specify this condition type in a condition contract type (see chapter Specify Settlement Settings for Condition Contract Types)."

"Explanation RENT: Not shown parameters have an initial value. You use this condition type for the business volume in manually created settlement documents, see pricing procedure A10008 in chapter Define Pricing Procedures."

Regards, 
Gauthier Victor