Skip to Content
0

Contents in a SAP HANA Change Lists??

Nov 02, 2016 at 12:34 PM

389

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Florian Pfeffer
Nov 02, 2016 at 07:24 PM
1

Hello Lakshman,

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

Regards,
Florian

Share
10 |10000 characters needed characters left characters exceeded
Lakshman Degala Nov 07, 2016 at 10:05 AM
0

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.

Share
10 |10000 characters needed characters left characters exceeded
Florian Pfeffer
Nov 08, 2016 at 09:12 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded