Creating a log from custom table

[Former Member]

Hi,

Is it possible to create log for insert, delete,update and modify data in a custom table?

If it possible, how can I rollback at the last operation?

Many thanks.

[Former Member]

You need to add your custom code for this purpose. Rollback mechanism should be deviced as per your requirements since it is very user specific requirements.

[former_member404244]

Hi,

In the technical settings of the custom table u can check the cehck box for LOG.

However not sure of the rollback mechanism.

Regards,

Nagaraj

[Former Member]

Hi,

You can log the changes that done on the custom table.

Steps:

1-Create the customs table.

2- Goto Techinical setting of the table

3- Check the Log Data Changes(in the bottom on the screen)

FYI...

Log data changes

The logging flag defines whether changes to the data records of a table should be logged. If logging is activated, every change (with UPDATE, DELETE) to an existing data record by a user or an application program is recorded in a log table in the database.

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.

Dependencies

Logging only takes place if parameter rec/client in the system profile is set correctly. Setting the flag on its own does not cause the table changes to be logged.

The existing logs can be displayed with Transaction Table history (SCU3).

With Regards,

Harinath P

[Former Member]

Dependencies
Logging only takes place if parameter rec/client in the system profile is set correctly. Setting the flag on its own does not cause the table changes to be logged.

How can I do this?