Thanks a lot for your response!
I have created a DATE field(ZDATE) in the DB table with dataelement as SYDATUM.
My requirement is when a new entry comes into this DB table or any record is changed (for a change in few fields not all infact but for time being let us take for all fields), this DATE field should be populated with SY-DATUM.
I have created a Maint.View(ZCOST_DATE) and have written the following code in TMG-->Events.
zcost_date-zdate = SY-DATUM.
Still the date field is not getting populated.This is giving me blank in the date field.
I have taken only the DB table(COST) in the 'Table join' tabstrip because I have already the DATE field.
*Please tell me what wrong in this?