SAP HANA documentation
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
Florian Pfeffer replied
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:
This returns the XML of the calc. view.