CAPM/XSA Native schema access - Same Schema name from different databases

[gregorw]

I have a CAPM ( or XSA ) application . I am connecting an S4HANA on premise database ( schema - SAPABAP1 , Table DD02L ) . I created a user provided service , hdbgrants and a hdbsynonym to facilitate this. I can access the table .
My question here is : If I am conning to another database ( lets say CRM ) which has the same SAPABAP1 schema and DD02L table, how would the synonym distinguish between these ?
I see only schema name and table names mentioned in the synonym definition .

-- I am building a capm app and deploying the mtar to xsa on prem .

Sreehari

[gregorw]

Before you try further on the technical solution make sure that you actually have the usage rights to directly access the HANA Schema of S/4HANA. I would suggest you clarify this with the SAP Account Executive.

[sreehari_vpillai]

Sure. S4H & CRM ( for ABAP1) schema reference is for illustrating the problem statement .

[sreehari_vpillai]

Accessing external containers / schemas through a user provider service only supported within a tenant and you cannot access outside tenant objects.

so cross tenant / cross DB access is not supported via User Provided Service.