Skip to Content
avatar image
Former Member

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    Nov 26, 2015 at 10:38 AM

    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


    OBJECT_HISTORY.jpg (172.4 kB)
    Add comment
    10|10000 characters needed characters exceeded

  • Oct 28, 2015 at 01:39 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Thanks Deepak.

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

  • avatar image
    Former Member
    Nov 02, 2015 at 11:31 AM

    Anyone?

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 27, 2015 at 05:07 PM

    Hi Raj ,

    how can I find the standard table details in hana

    Add comment
    10|10000 characters needed characters exceeded