05-19-2006 7:57 AM
Dear all,
I have created one ZTable where rates for different items are maintained. I have created view also for that table to maintain the rates. Now, I want that whenever anybody changes the rate or goes to that table his SAP ID should also be reflected in the view so that during the time of audit we can know who has change the rates.
Can it be done?
If possible plz guide me out how to go for that.
Waiting for ur replies.
thanx,
nishu
05-19-2006 8:07 AM
Hi !
The simplest way is to mark "Standars recording routine"
during table maintenace view generation.
If it's done so the system generates "change logs"
wich can be viewd with the report RSVTPROT.
Regards
Rainer
Points would be nice
05-19-2006 8:05 AM
Hi,
in the transaction SE11 -> Display technical settings.
You have a checkbox : Log Data changes
see the documentation of this checkbox, I think you will find how to do it.
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
Rgd
Frédéric
05-19-2006 8:07 AM
Hi !
The simplest way is to mark "Standars recording routine"
during table maintenace view generation.
If it's done so the system generates "change logs"
wich can be viewd with the report RSVTPROT.
Regards
Rainer
Points would be nice
05-19-2006 8:09 AM
Hi nishu,
1. For this probably we can use
table maintanance generator and its events.
2. For that put extra fields in the table
for user name, and date/time.
3. Using events (eg. before saving)
we can put values in to these extra fields,
and they will be saved in the table.
regards,
amit m.