BW4HANA Views catalog

[rajaveluk]

Hello,

We have been using BW4HANA last 2 years and accumulated over 600 calculated views (CVs).

One of the challenges to identify the data fields in the views. Is there any API available to read the metadata of the CVs to identify the data fields? Currently it is very challenging to identify the fields unless you use studio or some kind of reporting tools. 

Any advise related to this topic is much appreciated .

Thank you !

[patrick_winkler]

You can try to query the tables and views of schema _SYS_BIC.

[roland_szajko · Accepted solution]

I think you can use SQL statements like:

SELECT * 
FROM "_SYS_BI"."BIMC_DIMENSION_VIEW" AS t1
JOIN "SYS"."VIEW_COLUMNS" AS t2 ON t2.schema_name = '_SYS_BIC'
AND t2.view_name LIKE CONCAT(CONCAT('%',t1.cube_name),'%')
AND t2.column_name = t1.column_name
ORDER BY t1.catalog_name, t1.schema_name, t1.cube_name, "ORDER"

to get the list of fields for HANA CV-s.