Reconcile S/4HANA Credit Management with SD Credit Management on a System Conversion
When doing a system conversion to S/4HANA you may notice that Credit Management (FI-AR-CR) is not available anymore. This functionality is replaced by SAP Credit Management (FIN-FSCM-CR). Note 2270544 will give you all the information about the business impact for this simplification item.
So now you will have to set up SAP Credit Management in S/4HANA to fulfill the business needs that where contented by the previous Credit Management functionality. This usually means that customers require similar functionality and process as they where using on ECC before the conversion. This is where we get to the crux of the matter. Trying to reconcile open value for SD Documents between these two functionalities is not an easy task.
After the conversion all the structures that belonged to the old SD Credit Management functionality will be empty, the master data transaction would be not accessible, and all the credit information on credit exposure will be again calculated by FSCM.
In FSCM you can run the reports as UKM_COMMITMENTS to display all the information by Credit Exposure Category. For FI Documents, these reports can be relatively easily compared to reports such as FBL5N and FBL5H after conversion to check if the credit exposure was successfully updated.
|Credit Exposure Categoy||Name||Report FSCM||Report to compare|
|200||Open Items from FI||UKM_COMMITMENTS||FBL5N, FBL5H|
|300||Special Credit Exposure||UKM_COMMITMENTS||FBL5N, FBL5H|
But for sales documents, there is no report that can easily compare Credit Exposure. As mentioned before, structures where this credit exposure is updated, are empty after the conversion. And even before the conversion, these structures (S066 and S067) will have an accumulation, and no detail by document.
Note 377165 describes how the open values are updated in the old Credit Management functionality, and the structures where it is stored. If you want to do a comparison, these values must be listed and keep before the conversion.
|Credit Exposure Categoy||Name||Report FSCM||Value before conversion|
|500||Billing Document Value||UKM_COMMITMENTS||S067-OFAKW|
If there are update errors, it would be a good idea to run report RVKRED77 to reorganize credit data before getting the values from the structures mentioned before.
Still, the structures will have an accumulated value by period, and no information on the specific documents that are affecting the open value. Unfortunately, there is no standard report to get this information.
If it is imperative to get this detailed information, again note 377165 will give more information on how to get this information.
Sales Order Open Value
Open Sales Order Value is calculated from the open schedule line quantity (VBEPD-OLFMNG) multiplied with the item credit price (VBAP-CMPRE). Consider that the material availability date will define the period in which the open sales order value is updated. Only items with confirmed quantity (VBEP-BMENG) will update an Open Sales Order Value, so this logic must be considered to correctly calculate the Credit Exposure for a Document. Some exceptions to these rules are explained in the note mentioned before.
Let’s see an example: Sales order 5523 has a net value of 1.000,00 BRL. If the item data is checked, the credit price is 126,73 BRL, this is the net value plus tax value. This document has one schedule line with confirmed quantity, so the open schedule line quantity (confirmed minus delivered) will be the base for the open value calculation, and updated for September 2018, adding a total of 1.267,28 BRL.
Fortunately, this is the only sales order for this customer on this period, so the value on structure S066 match the calculation performed.
Open Delivery Value
For Open Delivery Value, the value updated in structure S067 is not separated in time periods. This means you will get one value per credit control area and credit customer. The value is again calculated from the credit price and the open delivered quantity. Delivered quantity may be fetched from the document flow table VBFA. Consider that this open quantity is affected even from credit blocked deliveries, so you will have to check delivered quantities not yet billed.
Open Billing Documents
Same as Open Delivery Value, the Open Billing documents only consider credit control area and credit customer, not time periods. Same as before, you will have to fetch the billed quantity not yet posted to accounting and multiply to the credit price. Billed Quantity may be fetched again from the document flow table.
As you may get the feeling by now, the Open Value Calculation at sales document level is not an easy task, and different logic that must be considered to perform a correct calculation. You may consider create a custom report to be executed before and after the system conversion to properly compare credit exposure between SD credit Management and FSCM in S/4HANA.