Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

HANA Views Metadata : Creation Date

Hi,

I am unable to find creation date of HANA Views. I looked at "SYS"."VIEW" as well as underlying base table "SYS"."RS_VIEWS_" but could not see a any date field. Where do I find information on when a HANA View was created and last modified? 

(In case of HANA tables, information is available in column "CREATE_TIME" in view "SYS"."M_RS_TABLES" but not for views )

Thanks.

Tags:
Former Member
replied

Hi Mayank,

Try this.

SELECT * FROM _SYS_REPO.OBJECT_HISTORY

WHERE PACKAGE_ID = 'give_your_package_name'

  AND OBJECT_NAME = 'give_your_view_name'

ORDER BY OBJECT_NAME, OBJECT_SUFFIX, VERSION_ID DESC;

Version-id 1 means newly created and the highest version id  is the last modification one.

Regards

Raj

1 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question