COEP Table Analysis Using the Programs RARCCOA1 and RARCCOA2

最新推荐文章于 2024-11-04 09:52:52 发布

lvzhqi

最新推荐文章于 2024-11-04 09:52:52 发布

阅读量1k

点赞数

分类专栏： DATA ARCHIVE 文章标签： table object system dataset list archive

本文链接：https://blog.csdn.net/lvzhqi/article/details/3131754

版权

DATA ARCHIVE 专栏收录该内容

11 篇文章 0 订阅

订阅专栏

Use

The programs RARCCOA1 and RARCCOA2 help you choose the archiving object to be used to remove certain CO data. These programs count the number of entries in the CO tables (COEP, COSP, ...) and assign them uniquely to an archiving object. A list is then displayed detailing the quantity of data that exists for each object type, controlling area and fiscal year.

Procedure

- Check (for example using transaction SA38) whether the programs RARCOOA1 and RARCCOA2 exist in your system. If they are not in your system, you can import them as described in SAP note 138688.
- Execute program RARCCOA1. On the CO Table Analysis - Generate Data Extract selection screen, select at least the table COEP.

As the program looks at all the table entries, this can take some time. It could be advisable to schedule the program as a batch job. The program generates a data extract, it does not display a list. It is difficult to estimate how long the program can run. Experience has shown that it can run 5 hours for 80 million COEP entries.

If you have a test system that is an exact copy of your productive system, you should execute the program in the test system. It is of no matter if the data is not exactly up-to-date, as long as it is not more than two months old. More accurate statements can only be made on the basis of the productive system.

Note

For ORACLE databases we recommend that you run the program at a time when as few postings as possible are being carried out, otherwise it might lead to error ORA-1555. If this error occurs, you should reschedule the program. The second time it generally runs without any errors.

Analyze the data using program RARCCOA2. Start this program in dialog. It reads the dataset generated by program RARCCOA1 and presents it correspondingly. This program has a runtime of only a few seconds.

Result

A list is displayed in which the archiving objects that could archive data from CO tables are listed with the number of entries contained in these tables. The archiving objects listed represent certain object types (or object category or applications). You should not use this list to decide which archiving object to use, as the system, for example, can not decide how long data is required. First carry out data avoidance and then determine the archiving objects.