Is it possible to get what are the objects used in a Calculation View in SAP HANA Studio???

[former_member383962]

Hi Experts,

Is it possible to get what are the objects used in a particular Calculation View from a package in SAP HANA Studio???

For Example:

Package : KABIL_PRACTICE

Calculation View name : CV_KABIL_PRACTICE, It modelled by using two table and three Calculation Views.

my requirement is to get what are the object used for creating the calculation view.

[pfefferf]

Table ACTIVE_OBJECTCROSSREF in schema _SYS_REPO should give you the required information for your XS classic development.

SELECT *
FROM "_SYS_REPO"."ACTIVE_OBJECTCROSSREF"
where  from_package_id = 'KABIL_PRACTICE'
  and from_object_name = 'CV_KABIL_PRACTICE'
  and from_object_suffix = 'calculationview'

Regards,
Florian

[former_member607745]

SELECT *FROM sys.object_dependencies where dependent_object_name ='CV_KABIL_PRACTICE'.

This will give you all the base objects used inside this calculation view