topic Re: Last Changed By Date in Application Development and Automation Discussions

Last Changed By Date

Former Member — Mon, 24 Dec 2007 09:49:53 GMT

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.

Re: Last Changed By Date

Former Member — Mon, 24 Dec 2007 11:09:42 GMT

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

Re: Last Changed By Date

Former Member — Tue, 25 Dec 2007 07:45:03 GMT

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-8765287250fc

Re: Last Changed By Date

Former Member — Wed, 26 Dec 2007 09:50:57 GMT

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