SAP HANA documentation

[Former Member]

Hi all,

I intend to create a .NET-based application for automated documentation of HANA-Views and their definition.

Does anybody have a tip for me where I can find this information in HANA? Can the definition of e.g. calculation views be read from tables or is the definition maybe stored in XML?

Thanks in advance

Torsten

[pfefferf · Accepted solution]

Hello Torsten,

the XML definition of calculation views is stored in field CDATA of table _SYS_REPO.ACTIVE_OBJECT (for active objects) or table _SYS_REPO.INACTIVE_OBJECT (for inactive objects).

But these tables can of course change in future in case SAP implements a different architecture (this will be already the case with >=SPS11 with the upcoming HANA Development Infrastructure).

I recommend to use the File API (JSDoc: Tutorial: 2. File API) available since SPS09.

If you have for example a calculation view named myView in a package /test/models, you just have to make a GET request with following URL:

<host>:<port>/sap/hana/xs/dt/base/file/test/models/myView.calculationview

This returns the XML of the calc. view.

Best Regards,

Florian