Skip to Content
avatar image
Former Member

Contents in a SAP HANA Change Lists??

Hi Experts,

We want to know the contents(objects etc) associated with a HANA Change List.
Can you tell us the views/tables which store this information? Will be grateful if you can provide us an SQL which will provide this information.

Our target is to develop a tool/sql which can check whether the dependent objects(tables) of a HANA change exists on Prod environment or not, whether those tables included in the change list are replicated onto Prod HANA or not.

Two Parts:
1. SQL to find: What all objects are associated with a change list?
2. SQL to find: Whether the objects(tables) associated with CL are existing/replicated or not on HANA Prod environment.

Thanks in advance for your responses and inputs.

Regards,
Lakshman

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Nov 02, 2016 at 07:24 PM

    Hello Lakshman,

    then entries in table _SYS_REPO.CHANGE_ENTRIES should answer your question regarding the first sql.

    Regards,
    Florian

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 07, 2016 at 10:05 AM

    Hi Florian,

    Thanks for provided table name, with this we met the first step to know the contents of each HANA change list.

    Further, I would need help with the view which can provide the list of tables/views which are associated with each OBJECT(Calcview etc).

    Could you please help on it.

    Regards,
    Lakshman.

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 08, 2016 at 09:12 PM

    Spoken for XS Classic and active objects, the relation can be determined from table _SYS_REPO.ACTIVE_OBJECTCROSSREF.

    Add comment
    10|10000 characters needed characters exceeded