topic Re: FIll Default Values into Table in Application Development and Automation Discussions

FIll Default Values into Table

Former Member — Fri, 17 May 2013 04:54:07 GMT

Hi All,

I have a Table and I have created TMG for the same.

In the Table I have 2 Fields CreateBY and CreatedAT along with some other fields.

When I create entries into table Using TMG I want those 2 fields to be filled with current user and current system time.How can i do it?

Thanks and Regards,

Pratheek

Moderator Message: Please search for the available information before posting

Message was edited by: Kesavadas Thekkillath

uppu_narayan — Fri, 17 May 2013 04:56:21 GMT

Hi Pratheek,

you can use the events of table maintenance generator....Try with the following event "creating a new entry" in TMG.

regards,

narayan

Former Member — Fri, 17 May 2013 04:58:13 GMT

This message was moderated.

Former Member — Fri, 17 May 2013 05:02:31 GMT

This message was moderated.

Former Member — Fri, 17 May 2013 05:02:32 GMT

You can use System fields :

Current time: SY-UZEIT

Curren User : SY-UNAME.

Add these fields to table and use therm.

Regards,

PRudhvi

Former Member — Fri, 17 May 2013 05:50:29 GMT

Hi Pratheek,

Before saving the records in to table along with the some values

assign the values for the work area as

wa_f1 = 'XYZ' .(Your Fields)

wa_f2 = 'ABC' .(Your Fields)

wa_createdby = SY-UNAME .(Current User Name)

wa_createdat = SY-DATUM. (Current Date)

Append wa to itab.

Note : The fields F1 & F2 are for your reference the fields whatever it may be

Thanks

G.Kranthi.