Row Store Tables of SAP not shown when creating views in HANA Studio
Hi HANA Master's,
I have requirement to create a HANA Calculation view on SAP standard table "TBTCO", but in HANA studio i am not able to see this table because it have a storage type as "ROW STORE", i googled it but did not find any other way to use this table in my HANA views, please provide me an alternate way to use "Row Store Tables" in development of my views.
chandrakala pulaparti replied
Hana Studio will not allow you to attribute views on Row store tables. It will only allow you on column store tables.
You can create analytical and calculation views on row store tables also .
If you want to change the Row store Table to column store and then You can build Hana views on top of it.
Alter Table <Schema name>.<Table Name> COLUMN