10-13-2008 8:43 AM
HI there,
I have created a custom table with the following fields:
FIELD1
FIELD2
CREATE_USER
CREATE_DATE
CREATE_TIME
UPDATE_USER
UPDATE_DATE
UPDATE_TIME
What i require is when i add in a new entry, the CREATE* fields should be populated with the username (sy-uname) , date (sy-datum)and time of creation (sy-uzeit).
And when the same record is being updated, the UPDATE* fields is populated accordingly (leaving the CREATE fields unchanged).
I know this can be done using the Events from the Table Maintenance Generator.
Please advise on what is the Maint Event number to use and how the code should look like. Thanks!
10-13-2008 10:03 AM
Hi,
when u r saving/creating entries into the table.
Use event 05 for populating the required fields..
With Regards,
Dwaraka.S
10-13-2008 9:17 AM
hi,
yes. we cam see the entries through sm30 (if table maimtencance generator created). First create table maintenance generator by using t-codes se11 or se54. we can enter the values sm30. please give me the Points.
regards
Mohan
10-13-2008 10:03 AM
Hi,
when u r saving/creating entries into the table.
Use event 05 for populating the required fields..
With Regards,
Dwaraka.S
10-13-2008 10:06 AM
hi everyone,
i manage to solve the problem:
To populate the CREATE* fields during creation, use event 05
To populate the UPDATE* fields during updates, use event 21
Edited by: Hon Koat Pang on Oct 13, 2008 5:06 PM