Adding System Date to Database View

[Former Member]

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.

[Former Member]

can check with datum field ?

[Former Member]

HI,

Use Structure : SYST

Regards

KK

[Former Member]

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%20im...

Regards,

Ravi

[Former Member]

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).