topic Re: Adding date & time to record before inserting into table in Application Development and Automation Discussions

Adding date & time to record before inserting into table

Former Member — Fri, 20 Aug 2010 11:40:53 GMT

Hi,

I created one table ZTABLE of type C and created table maintenance generator to insert records.

while inserting record into table fill date time automatically.

Example: ZTABLE has 3 fields.

BUKRS, ZDATE, ZTIME.

when user enters BUKRS and click on save in table mantenance generator, then 1 record should be inserted into table

with date and time

Waiting for your valuable suggestions

Regards,

Kiran

Moderator message: you could have found this yourself, so next time, please (re)search before asking.

Edited by: Thomas Zloch on Aug 20, 2010 3:47 PM

Re: Adding date & time to record before inserting into table

royolav_johansen — Fri, 20 Aug 2010 11:56:33 GMT

When you are in the maintain table maint....

Just go to Environment->modification->events.

Here is a step by step link how you should do it.

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

Regards

Roy

Re: Adding date & time to record before inserting into table

RaymondGiuseppi — Fri, 20 Aug 2010 12:00:12 GMT

You can use [Extended Table Maintenance Events|http://help.sap.com/saphelp_46c/helpdata/en/91/ca9f0ea9d111d1a5690000e82deaaa/frameset.htm] - [Event 01|http://help.sap.com/saphelp_46c/helpdata/en/91/ca9f0ba9d111d1a5690000e82deaaa/frameset.htm] "Before saving the data in the database" - purpose : fill hidden fields

There are samples and guides in wiki like [Extended Table Maintenance Events |http://wiki.sdn.sap.com/wiki/display/ABAP/ExtendedTableMaintenanceEvents] (and [many others|http://wiki.sdn.sap.com/wiki/dosearchsite.action?searchQuery.queryString=tablemaintenanceevent&searchQuery.spaceKey=conf_global])

Regards,

Raymond

Re: Adding date & time to record before inserting into table

kesavadas_thekkillath — Fri, 20 Aug 2010 12:05:15 GMT

Hi,

Just place table maintenance events sdn article exactly in google. The first link holds what you require.

Please search in SCN or Google before posting.