IM job performance

[Former Member]

I need to delete change pointer table entries. How can I decide what are the entries that are not needed and deleting them won't create any inconsistency ? Also let me know what are the other things that should be considered before deleting entries from change pointer table. Please suggest.

[Former Member]

Hi Mike,

Change pointers are the resultant of any changes in master data or transactional data either in R/3 or APO system. Using change pointers, the changes will get updated from one system to the other.

Change pointers will function as per customisation settings of OLTP transfer of data. The change pointers can be controlled using t-code /sapapo/c5 in APO. Supposingly, if your OLTP definition is immediate transfer, any changes in system will get online updated using change pointer.

If your definition is periodic transfer, all your changes will get collected and using c5 t-code, you can publish or delete the change pointers into the other system. In c5, you can see the change pointers of various objects using selection criteria in APO order type. Based, on the apo order type selected and the output generated, you can decide whether those change pointers needs to be published or to be deleted.

But if you delete a change pointer(s),it cannot be regenerated and the changes (both master data and transactional data) cannot be updated into the other system. So, one needs to be cautious in doing this activity. You can schedule background job also to delete these entries.

Regards

R. Senthil mareeswaran.

[Former Member]

This basic stuff is available in every APO books/links. Nothing new!!

Our change pointer table has grown much bigger in size and that is causing performance issues during IM job run. RBDCPCLR run regularly still no use. So looking for some update if any can provide any real input ?

[Former Member]

Hi! Mike,

Is this your Question-?

"When you change any master data in R/3 it creates a change pointer for that master data object. which is then processed by Transactionn CFP1. After the Master data gets updated in APO, the enteries are still there in the Change pointer table with Status "Processed". And thus data in the table is increased to a larger extent and now you want to delete already transfered enteries"

if "yes"

In R/3 You can delete the enteries with a standard report RBDCPCLR is available but it will only delete processed change pointer or obsolete change pointer & be sure that it in not in the test mode.

you can add it in your process chain just after you Running CFP1

In APO you can delete it with standard report COM_SE_CPOINTER_DELETE.

If you are not satisfied with the answer pls elaborate your question. Like are you really processing change pointer???? or you run online/periodic transfer or you run Delta or Initial transfer and for which all objects you are running it.

regards

Vaibhav Sareen

[Former Member]

Solved for now.