HANA Views Metadata : Creation Date

[Former Member]

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.

[rindia · Accepted solution]

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

[Former Member · Accepted solution]

Thanks Raj. Thats exactly what I was looking for.

[Former Member]

Hi Raj ,

how can I find the standard table details in hana

[rindia]

Hi Surya,

I suggest you to search the forum before posting basic question. If there is no such entry then post your question in new thread.

Regarding the answer to your question:

Standard table details can be found in HANA studio by table definition.

Go to your schema - Tables - your_table_name - right click - Open definition

If you don't know which schema your table belongs then type your table name in the search box, marked as 2 in below:

Regards

Raj

[Former Member]

Hi Raj,

My question was howto find the standard table to find more details of hana ... like you use to find the creator of hana model like that

[Former Member]

Anyone?

[j_vandersterren]

Did you find where you can find who last modified a view?

[Former Member]

Jos, you can refer to reply below from Raj.  You can look at the highest version_id value and get the activated_id who last modified it.

[DeepakVarandani]

Hi Mayank,

You can check CREATE_TIME column in "M_CE_CALCSCENARIOS_OVERVIEW" for creation date and time of Analytic and Calculation View.

Best Regards,

Deepak.

[Former Member]

Thanks Deepak.

But this view has details only about calculation and Analytical views. I was looking at all types of views.