topic Re: Table Maintenance Generated screen - update table fields in Application Development and Automation Discussions

Table Maintenance Generated screen - update table fields

Former Member — Mon, 13 Oct 2008 07:43:22 GMT

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!

Re: Table Maintenance Generated screen - update table fields

Former Member — Mon, 13 Oct 2008 08:17:37 GMT

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

Re: Table Maintenance Generated screen - update table fields

Former Member — Mon, 13 Oct 2008 09:03:33 GMT

Hi,

when u r saving/creating entries into the table.

Use event 05 for populating the required fields..

With Regards,

Dwaraka.S

Re: Table Maintenance Generated screen - update table fields

Former Member — Mon, 13 Oct 2008 09:06:13 GMT

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