Last Changed By Date

[Former Member]

Hi Experts,

In a custom table i need to create a Last Changed by feild which need to be populated automatically when a new record is added or change the existing record.

[Former Member]

Hi Raghvendra,

Are you going to update the Z table through a table maintenance?

If yes, then you have two approaches:

1. Since its a Z table - the table maintenance will be under a Z function group and hence you can create your own PAI module in LOOP~ENDLOOP in PAI section and have the module react to ON INPUT-REQUEST - and update the last changed by field with SY-UNAME

2. Use SAP modification events BEFORE_SAVE

Kind regards,

Aditya

[Former Member]

Hi Raghavendra,

If you are updating table through SM30 (Table maintrenace generator ) then you can use events for this purpose.

Refer to this link

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/8129f164-0a01-0010-2a8e-87652872...

[Former Member]

if it is a z then u can update it by assigning the field name to sy-ucome inside ur program..........