How to delete table /BIC/B0000640000 in APO DP production system

[former_member618787]

Dear Gurus

The table /BIC/B0000640000 described as "modification log table" is related to an ODS in APO DP. This table has huge amount of data in database that need to be deleted in production system where its related ODS also have a huge amount of records. We do not have a program to delete this table. I think if we delete the content of the ODS, probably the table content will be deleted too, but I could not test it because in test system I found this table has no records in spite of its related ODS does have records.

Can you please guide me on how to delete this table in a safe way

Thanks

[rupesh_brahmankar]

Hello,

Change log is used for delta functionality enabling. When data in the change log already updated into data target and new request has arrived into the log you already don't need the old data in the log.

So, you can delete them. To do it go to PSA tree and delete the old ones.

ODS - Manage - Environment - Delete changelog

Also please refer SAP KBA, 1839146 - ODS Change Log deletion with process chain does not work

Best Regards,

R.Brahmankar