Adding new fields( strucure) Changing SDA virtual table

[naveenreddy]

We have SDA connected to SQL DB and we replicated Virtual tables into HANA. One of the table in SQL source has been changed by adding a new column. How do we bring the structural changes into HANA using SDA? Does the structural changes replicate automatically into HANA or any manual config we need to make.

Could you please let me know if you know any another option than ALERT statement

[pfefferf]

Since HANA 2.0 there exists a ALTER VIRTUAL TABLE statement which allows you to refresh the definition. If you are on a lower HANA version than you have to drop and recreate the virtual table (as described in SAP Note 2481424). This topic was already discussed several times, e.g. here.