topic Re: store values automatically in table in Application Development and Automation Discussions

store values automatically in table

lijisusan_mathews — Fri, 21 Nov 2008 08:18:56 GMT

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

Re: store values automatically in table

Former Member — Fri, 21 Nov 2008 08:21:11 GMT

while saving data to Table you can use

Sy-datum - current date

sy-uzeit - Current time

sy-uname - current user .

Re: store values automatically in table

Former Member — Fri, 21 Nov 2008 08:46:53 GMT

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.

Re: store values automatically in table

Former Member — Fri, 21 Nov 2008 08:54:38 GMT

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

Re: store values automatically in table

lijisusan_mathews — Thu, 27 Nov 2008 18:50:49 GMT

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?

Re: store values automatically in table

amelia_li3 — Thu, 27 Nov 2008 20:17:37 GMT

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

Re: store values automatically in table

lijisusan_mathews — Fri, 28 Nov 2008 02:29:27 GMT

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