Unable to add new tables to the existing subscribed CAP based SAS application

[sagar_chopra]

Hello,

I am unable to update DB tables structure and add new tables to the existing subscribed CAP based SAS application in BTP.

I have an existing subscribed SaaS multitenant CAP application and an existing HDI schema and artifacts generated when application was subscribed by the consumer. When I am adding new fields to existing DB tables in CDS and deploy the application to Provider account, newly added fields are not reflected in HDI schema of consumer.

@philip.mugglestone andrew.lunde

Thanks,

Sagar

[pmugglestone]

Hi Sagar,

Thanks for your question.

Have you followed the steps in this video tutorial series?

In particular this one which covers extending the data model?

You can also find more info in the CAP docs.

Thanks,

Philip

[gregorw · Accepted solution]

Did you call the endpoint /mtx/v1/model/asyncUpgrade after you did the deploy? This will do the deployment of the changed model to the tenant databases. Please check out https://cap.cloud.sap/docs/guides/multitenancy for details.