Correction report for wrong credit values - RVKRED77

作者:郑德鼎 约 6 分钟阅读 更新日期:2024-02-22 2 年前更新 标签:SD, 销售分销
目录

Configure

Dashboard

RVKRED77 and RVKRED88

Skip to end of banner

Go to start of banner

Correction report for wrong credit values - RVKRED77

Skip to end of metadata

Created by Former Member on Jan 06, 2015

Go to start of metadata

Symptom

There are inconsistent credit values in the system, you determined this by using the right method. You would like to know how to correct these wrong entries.

Solution

RVKRED77 is a correction report of the credit management for the updated open sales values (the open credit values in SD), that is, for the information structures S066 and S067 with the open order values (S066-OEIKW), the open delivery values (S067-OLIKW) and the open billing document values (S067-OFAKW).

You need to use the report if

errors occurred in the updating of these sales values (ideally if the cause of the errors has been eliminated so that you can continue afterwards with correct values without errors);

if the update group (T014-STAFO, Transaction OB45) was changed in a credit control area (more on this you can read HERE);

in larger intervals to remove zero entries from table S066: The open order values (S066-OEIKW) are stored in time periods (monthly, weekly or daily, Transaction OMO1) in table S066. At some stage, the entries in the older periods become zero and are then also read each time you read the open order values (for example during the check of the credit limit used).  To improve the performance, delete these entries in larger intervals by using RVKRED77;

in larger intervals to remove minimum elementary amounts (for example 1 cent) which, due to rounding problems, remained despite the completion of the respective processes. For more details refer to Note 406608.

For the following reasons the report is no suited for frequent use

To ensure an error-free run of RVKRED77, it is necessary to completely block tables VBAK, LIKP and VBRK. As a result, the run of the report is not possible during the current operation.

Depending on the selection, a program run of RVKRED77 can last a few hours, in extreme cases you may even experience a runtime of a few days.

Help with runtime problems

Note 363343 provides detailed instructions for the parallel processing of RVKRED77 and Note 755395 for background execution:.

SAP Note: 363343 - Parallel processing of RVKRED77 if the runtime is too long

SAP Note: 755395 - Parallel processing RVKRED77 for background processing

If you identified more credit accounts with incorrect credit values (i.e. with report Z_CREDIT_VALUE_COMPARE, read HERE how) you can build groups of credit accounts which you can run by parallel processing. With that you can reduce the time frame needed for reconstruction.

Additional information

RVKRED88 simulates report RVKRED77. However, it does not block tables VBAK, LIKP or VBRK as does RVKRED77  as a result, differences may occur in the result if relevant documents are changed during the run or if new documents are created. It is very well suited to estimate the runtime of RVKRED77, and thus to determine suitable selections.

This is included in SAP Note: 400311 - RVKRED77: Reorganization credit data, new documentation

Further information

How is the credit value of a document calculated?

How does the credit update work?

RVKRED77 is locking the tables, no SD activity is possible

Business runs 24*7, it is not possible to block the tables, how can we correct the values

More information related to RVKRED77 and RVKRED88

Pablo Mejias

May 30, 2018 3 minute read

SAP Credit management: Functional overview

101633,306

In this blog we will make a brief summary of the most important points about SAP Credit Management

First, the difference between “FI-AR Credit Management” and SAP Credit Management is detailed

SAP Credit Management takes information in real time from the SD and FI modules. Allowing a credit analysis on the flight and gives us the certainty of an accurate analysis of the clients

Frequently asked questions we ask about Credit Management

What allows to create SAP Credit Management ?

Credit Limit Management

–        Implement a company wide credit policy

–         Manage a customer credit profile

–        Central credit management in a distributed system landscape

Credit Case

–        Credit case for structured processing of credit limit applications

–        Track status and result of credit limit applications

Credit Rules Engine

–        Categorize customers by scoring rules

–        Automatically calculate and assign a customer-specific credit limit

–        Credit check rules

–        Model and implement own customer credit score cards

Credit Information

–        Interface to external credit agencies

–        Input parameters for scoring rules

Credit Manager Analytics

–        Role-based access to credit management information and analysis

What allows Credit Rules Engine?

Create a scoring formula and credit limit formula by using the formula editor. Parameters (for example, business partner data) and functions are used as input parameters.

One scoring formula and several credit limit formulas (for each credit segment) are assigned to the rule for scoring and credit limit calculation, which is assigned to each customer in the credit profile. The risk class is determined directly from the score.

In customizing, specific score ranges which do not overlap are assigned to each risk class. For the check rule, the system determines the steps which are taken to check the creditworthiness of a customer when a sales order is created. This may include the static check of the credit limit or acheck of the highest dunning level.

Customer-specific process chains in SAP Credit Management can be defined through events which trigger follow-up actions

Calculate internal credit scoring

In the scoring you can combine customer master data and transactional data (e.g. payment behavior) to score a customer.The scoring is based on formula that can be freely defined by the user.

In the scoring method you can include ratings from external sources. Multiple external ratings can be mapped to an internal rating to make them compareable

Use a black-rated customer list to prevent business with high risk customers

Example credit management process

–  A sales order that is entered in the sales system can be checked automatically in the credit management system.

–  If the check fails, the order is blocked and the credit manager can review the customer credit profile.

–  He can request credit report from an external source. (e.g. D&B)

–  Based on new external information the scoring and a new proposal for credit-limit can be automatically calculated by the system

Based on the new credit limit the credit manager can release the sales order now

Credit Management with Central Payments

You can also use SAP Credit Management with Central Payments in Central Finance

For this scenario it is necessary to implement SLT and through IDoc / ALE, etc. You can send the SD module information from the source system to the target system.

FollowLikeRSS Feed

Alert Moderator

Jyoti Singh

August 7, 2018 at 9:36 pm

Hello Pablo,

Nice overview. Could you please share more detail on "it is necessary to implement SLT and through IDoc / ALE, etc." Do you mean the document replication or credit check service message flow from source to target.

Also, the scenario should work if the document status in both source and target system reflecting the right status.

Thank you

Like 0

Share

Pablo Mejias

Blog Post Author

August 13, 2018 at 7:06 pm

Hi Jyoti,

Thank you!. It is not necessary to implement SLT for the Credit Management module, the communication is by IDOC.

The credit check begins when the sales order is generated in the source system.

Yes, it is correct the system works correctly when the data have the same status in both systems.

Like 0

Share

Vinod Bhat

November 11, 2018 at 10:48 am

Hello Pablo,

Thanks for very informative blog. We are trying to setup SAP Credit Management with existing Central finance & central payment landscape. But We did not get any information of landscape and SLT tables for replication in SAP help document for this senario. would it be possible to provide the link to standard documentation.

Best Regards,

Vinod

Like 0

Share

Mehul Lad

November 14, 2018 at 6:29 pm

Hello Pablo,

Thank you for a good overview of the functionality, is there any detailed documentation we can refer for settings we need to change on existing ECC systems for deactivating existing credit check functionality and in case we have multiple ECC systems, We are linking them all to CFIN but only want to do use centralized credit check only on some of them and have the credit check activated selectively on few ECC instances. any insight on this scenario will be very helpful.

Regards,

Mehul.

Like 0

Share

Vijayakumar Aluru

August 18, 2020 at 3:42 am

Hi Mehul,

Did you find any document on deactivating credit check in ECC? We are in a similar situation.

Can you please provide what steps you have undertaken? aluruvk@hotmail

thank you

Vijay

Like 0

Share

Moises Ibarra

July 13, 2021 at 7:47 pm

Dear Pablo or Mehul,

Did you find this documentation that can clarify how to activate the credit check only for some of the source system or even just some of the legal entities? We are encountering this scenario where we do not want to do a centralized credit check for all legal entities.

Appreciate any support!

Regards,

Moises Ibarra

Like 0

Share

Nabeel Nasir

March 3, 2020 at 3:51 pm

Hello Pablo,

Great article and very informative.

Want to ask if you have implemented Credit Management in distributed landscape? Have a client who is implementing cFin and has few source systems.

What are some of the configuational tasks? How do you make source systems talk to credit mgmt enabled system? Some key considerations and etc.

Thanks

Like 0

Share

Rochelle Zabalerio

October 6, 2020 at 2:22 pm

...

郑德鼎

关于作者:郑德鼎

企业信息化与 SAP 技术顾问,长期专注 SAP ABAP、FI/CO、MM、SD 等模块的技术分享与实战经验总结。查看更多介绍

来源说明:本文内容由「Correction report for wrong credit values - RVKRED77.docx」整理生成,仅用于内部技术分享与学习交流。