Joining C4S Virtual tables in SAP HANA

I am facing the issue while joining the C4S virtual tables , I see the error: “Error opening the cursor for the remote database.”

The join works fine when a C4S table is joined to a S4 table, but fails when both the tables are C4S tables (because both are virtual tables).

both these tables are present in the same schema. I am considering the approach to join these 2 tables in C4S before they are migrated to HANA ,if the join in HANA is not possible.

Please suggest...

Thank you.