topic Re: Data Dictionary Problem in Application Development and Automation Discussions

Data Dictionary Problem

Former Member — Fri, 19 May 2006 06:57:48 GMT

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

Re: Data Dictionary Problem

FredericGirod — Fri, 19 May 2006 07:05:56 GMT

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

Re: Data Dictionary Problem

Former Member — Fri, 19 May 2006 07:07:56 GMT

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

Re: Data Dictionary Problem

Former Member — Fri, 19 May 2006 07:09:48 GMT

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.