How to enable logging of database changes of Z tables into a log table.
We have 8 Z tables and we need to log the changes in these tables. Earlier Change Document process was proposed but now we know that the possible changes in the Z tables will be many and this can cause too many entries in CDHDR and CDPOS tables. Going through so many entries of Change Document tables will decrease the system performance. The other option involves enabling the Log data base changes for the Z data base tables, but this will also cause the system to slow down as per SAP F1 help on "Log data changes" checkbox.
description-"Note: Activating logging slows down accesses that change the table. First of all, a record must be written in the log table for each change. Secondly, many users access this log table in parallel. This could cause lock situations even though the users are working with different application tables."
So we came to a solution where we can create a Z table and we will log the above mentioned Z table changes in the Z Change table but I have no idea how to implement the suggested solution. Please help me on this.