store values automatically in table

[lijisusan_mathews]

is there a way to store the time or creation, date created etc.. that is values of fields, erdat ,ertime ,ernam automatically.. if i am inserting using table maintenance generator, i can use events to store it automatically.. but if i am, inserting values using module pool, is this possible by some way??

Suzie

[Former Member]

hi

while saving data to Table you can use

Sy-datum - current date

sy-uzeit - Current time

sy-uname - current user .

[Former Member]

hi Suzie

as Avinash's post you can past those system fields to your table.

when you pass values to itab before updating db tab.

[Former Member]

Hi suzie,

You can store the above mentioned system fields in your screen fields or internal table fields.so that while inserting data into internal tables your current date, time etc will be automatically stored.

You can do this in PAI module while saving.

Regards,

Kashyap

[lijisusan_mathews]

there is a check box called "log changes" in the technical settings of a table. Can this be used to store the audit trail?? or is there any other standard way by customizing?

[amelia_li3]

This is the help on Log data change flag, it looks like it won't work on insertion.

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).

[lijisusan_mathews]

thnks for that..

So does all of this mean that the logging available in all standard tables(which shows created user , date , changed user n date) are all done by implicitly assigning values during insertion or updating??

Edited by: Suzie on Nov 28, 2008 9:18 AM