How to implement cross container access between 2 multitenant (mtxs) CAP SAAS applications?

[achim_vogel2]

Hello CAP and HDI experts,

we have two CAP SAAS applications MDM and TPS, where we need the TPS HANA container to have read access to the MDM HANA container. Reason is performance optimisation with stored procedures, where a stored procedure in TPS container should have read access to views in the MDM container.

When a subscriber tenant in a BTP sub-account subscribes to the two SAA applications, the containers are created by the 2 saas-registrys and the schema content is created by the 2 service-managers of the applications.

The https://help.sap.com/docs/hana-cloud-database/sap-hana-cloud-sap-hana-database-developer-guide-for-c... describes how to implement cross container access between to none multitenant HDI containers of type com.sap.xs.hdi-container. But with SAAS applications we use the 

service-manager which dynamically manages the containers of subscribing tenants behind the scene.

Can somebody provide the correct mta.yaml configuration for this scenario, if available? 

A similar request is described by https://community.sap.com/t5/technology-q-a/achieve-cross-hdi-communication-through-synonyms-using-m...

But there was no answer for this real life requirement.

Many thanks

Achim