SAP Banking- table bca_cn_link to big

[lgh0209]

Hi Guys,

One of our customer asked for the solution about their banking system table BCA_CN_LINK.

It is to big now and has about more than 300,000,000 records.

I want to know if some solutions provided to control it, such as archiving data?

Thanks.

[anna_dyachkova]

Dear Denis,

Data archiving is definitely the right way to reduce entries in table BCA_CN_LINK. But this table is a central table used by many processes. There is no way to delete entries from this table only. With more than 300,000,000 records it seems that many closed and inactive contracts are in the system.

If you want to archive data with FS_CN_ACCT, FS_CN_CARD, FS_CN_CGP or FS_CN_MC you archive entire contracts and all related data such as payments, orders, …

Archiving should be properly implemented and configured. The best way to solve the problem would be contact SAP Consulting /Sales team to address the interest in archiving.

Best regards,

Anna

[lgh0209]

Hi Anna,

Thanks for your comments, I will check with customer for the following steps.