Is there any modified version of correction report RCCLZUOB for KSSK table inconsistency?

[former_member194158]

Dear Experts,

Our client is facing a problem of short dump at the time of creating a new version of document (DIR). This problem happens specially when there is an inconsistent entry in KSSK table for that DIR with respect to DRAW table. I mean, as per DRAW table, it says that there is 2 versions ( 00 & 01) of a DIR. But for that same DIR, in KSSK table it says that - there are 3 versions (00, 01 & 02). Thus KSSK table contains one inconsistent entry.

SAP has also provided a solution for this. As per SAP Note 1251623, there is a correction program RCCLZUOB. If we run this program with object table as DRAW, then all the inconsistencies in KSSK table with respect to DRAW table will be deleted.

But the problem is that the report RCCLZUOB does not provide a option to run it per DIR. If we execute this report, it will run for ALL such entries between KSSK + DRAW table and will delete all of them. This is the problem.

As you know that KSSK generally contains millions of data. As this report checks ALL the date to find & delete inconsistencies, hence it will take huge time to get completed (in background job mode).

For example, I executed this report in our Quality system and it took approx 5 hours to get completed.

So we are a bit afraid to use this report in our Production system. Production system will definitely having much higher number of entries in KSSK table as compare to Quality system. And thus if we execute the same in PROD system, then it may take more than 5 to 6 hours, evenif we run it in weekend. It may cause performance issue in system and also due to locking (probably) of KSSK table for such a long time, may cause trouble to other transactions as well.

So my question is - is there any alternative / modified report / program available which is related to RCCLZUOB and where we can input DIR (object) number at the time of execution?

Thanks in advance for your advices / answers.

Regards,

Supriyo

[former_member194158]

Hi Ritesh,

Good to see your comment. Hope, you are doing well.

Yes, a custom program based upon the correction report RCCLZUOB would have been a good and quicker solution. But actually, our client does not want any more new custom program in system.

Definitely, I already planned to contact SAP to check whether modification of report RCCLZUOB can be possible or not !

You advised to add the root cause of this problem. Actually, as you can understand that this kind of inconsistency is more like a system generation. However, in SAP Note 1251623, the root cause has been explained as = When the document creation fails for the first time,DIR creation is rolled back.The characteristic values are not cleared from the classification tables if there is a copy of classification for this DIR.

Hope, this helps.

Regards,

Supriyo

[Ritz]

SUPRIYO SENGUPTA,

Thanks for writing in so much details of the problem. I am sure it will help other user's and forum in future too.

Can you please also add the root cause or the reason to have this difference in version? What went wrong which generated this inconsistence.

I suggest contact SAP team again an request them to modify the report to have more input for selecting single record. I guess that can solve your existing issue and give you option to correct the remaining record in future.

Also , you can establish a process to run and correct this kinda inconsistence in future every week or month.

If not then you need to develop a custom report based upon RCCLZUOB.

Thanks

Ritesh