CDHDR and CDPOS Deletion

[Former Member]

Hi,

We wanted to delete the change pointers (BDCP) and changed document entries in CDHDR and CDPOS Tables to improve the system performance.

is there any program to archive/delete these tables BDCP, CDHDR and CDPOS.

Thanks,

Venkat

[former_member376453]

I think archiving strategy need to be defined first, else ad-hoc archiving may create some inconsistency in system. There is some thing called archiving class. For change document the responsible one is "CHANGEDOCU" . Check T-CODE - SARA , if you have authorization

Kuntal

[Former Member]

using BD22 you can delete change pointers

[Former Member]

Hi Venkat,

Please refer to 'Data Management Guide' in service.sap.com/ilm. It provides very good guidance about various tables including change pointers and change documents.

Read carefully the Deletion and Archiving section for change documents, it is recommended to archive the change documents along with the parent application data from which it was generated.

Thanks,

Naveen

[Former Member]

Hi Venkat,

Please go thru below (point 4) which may help. Looks like this is the Authentic and Suggested way to achieve Change pointer deletion.

http://help.sap.com/saphelp_erp2005vp/helpdata/EN/12/83e03c19758e71e10000000a114084/content.htm

Regards

Shital

[Former Member]

This function module is used to delete entries in CDHDR and CDPOS change pointers tables .

*'TB_LIMIT_DELETE_ARCHIVED_REC2'*

BDCP, BDCP2, BDCPS can be deleted by transaction BD22.

Regards,

Aswin.

[Former Member]

Hi All,

Thanks for all for giving their valuable suggestions. I used RBDCPCLR to clear the BDCP.

We have not yet decided about archiving the change pointers we have suggested the same to business.

Thanks,

Venkat