Hi All,We are trying to find out a way to identify {base table} -> {views} linkages.I know we have some available in SYS.VIEWS but this does not contain everything. Does anybody knows where/how we can get this entire list.Regards,Salil
Hi all,Need guidance on how to Transport custom table created under custom schema in SAP HANA DB. I am aware of Export/Import but i need a mechanism to do it via transport or maybe how we can package it.Regards,Salil
Hi All,I would like to read the value XXXXX in the below string<String1><DbtrAcct><Id><Other><Id>XXXXX</Id><String2>Is there any string function that i can use to read. BTW, this will be multiple times.Regards,Salil
Hi all,Is there a way (Report, Function Module, Class/Method) to get list of all the underlying CDS Views and DB Tables for a given Consumption View.Regards, Salil
I used "SYS"."OBJECT_DEPENDENCIES" and passed the table to get list of Views using this table directly/indirectly. But i need a way to map the view/field to table/field mainly for Calc Views and Hierarchy Views.I used "SYS"."CS_VIEW_COLUMNS" but it d...
Also one more scenario I have is to read the below string*DA*4011051562*1391833695**01*121000358*DA*123300030000001705735542**output scenario 1 - read value between *DA* and * = 4011051562scenario 2 - read value between *DA* and ** = 1233000300000017...
Hi Michael, after further analysis i see that i can use DDL Source field in table DDDDLSRC and then as you mentioned, i have to keep doing this recursively until i get to the base tables
Hi Michael, Thanks for your response but when i checked the tables with DDDDL*, i did not see list of all the underlying views/tables for the consumption view i was looking for. Any other suggestion?