topic Re: Adding System Date to Database View in Application Development and Automation Discussions

Adding System Date to Database View

Former Member — Thu, 24 May 2007 22:44:17 GMT

I am trying to include the current system date into a database view. This field must always reflect the current date that the view is queried.

Is there a system table with the system date that I can include in this view.

Thank you.

Re: Adding System Date to Database View

Former Member — Thu, 24 May 2007 22:47:56 GMT

can check with datum field ?

Re: Adding System Date to Database View

Former Member — Thu, 24 May 2007 22:54:35 GMT

HI,

Use Structure : SYST

Regards

Re: Adding System Date to Database View

Former Member — Thu, 24 May 2007 23:21:45 GMT

Hi Sudeep,

You cannot create a field which has a pre defined value(current date as in your case).

You maust write logic in the program that enters the data into that table/view to default the sy-datum whenever a new record is created.

For example if you use a table maintenance generator for the view, you have to proceed this way:

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/library/abap/how%20to%20implement%20events%20in%20table%20maintenance.doc

Regards,

Ravi

Re: Adding System Date to Database View

Former Member — Thu, 24 May 2007 23:32:54 GMT

System date is a runtime value and not stored in any table. You will have to write your own logic to fill that column with system date. Use maintenance generator's events feature(SE54).