Skip to Content

Error in joining two virtual tables in SAP HANA Service on Cloud Foundry environment

Hi SAP Experts,

I have a particular scenario in mind of joining two virtual tables based on OData adapter (source is SAP S/4HANA Cloud, but could be anything really).

I'm facing the error when I try to preview data from the calculation view containing join. Please note that I can view data in both tables separately.

I have stripped down this scenario to the bare minimum and removed the complexity of HDI containers, synonyms, etc. and still have an issue. I have even created SQL JOIN statement in SQL console but still without much progress.

Please let me know what I'm doing wrong here.

Virtual tables:

SY_A_CustSalesPartnerFunc

SY_A_BusinessPartner

Statement:

Select A."Customer", A."BPCustomerNumber", B."BusinessPartnerName" from "SY_A_CustSalesPartnerFunc" as A INNER JOIN "SY_A_BusinessPartner" as B ON A."BPCustomerNumber" = B."BusinessPartner";

Error message:

Could not execute 'select A."Customer", A."BPCustomerNumber", B."BusinessPartnerName" from "SY_A_CustSalesPartnerFunc" ...' Error: (dberror) [403]: internal error: Error opening the cursor for the remote database Error parsing query: SELECT "A"."Customer", "A"."BPCustomerNumber", "B"."BusinessPartnerName" FROM ("A_CustSalesPartnerFunc" "A" INNER JOIN "A_BusinessPartner" "B" ON ("A"."BPCustomerNumber" = "B"."BusinessPartner") ) ERRORS <ERROR - No Navigation Property Name found in Table: A_CustSalesPartnerFunc for Joined Table: A_BusinessPartner;ERROR - No Navigation Property Name found in Table: A_BusinessPartner for Joined Table: A_CustSalesPartnerFunc;ERROR - No Navigation Property prefix found for Column: Busi for query "SELECT "A"."Customer", "A"."BPCustomerNumber", "B"."BusinessPartnerName" FROM ("A_CustSalesPartnerFunc" "A" INNER JOIN "A_BusinessPartner" "B" ON ("A"."BPCustomerNumber" = "B"."BusinessPartner") ) "

Add a comment
10|10000 characters needed characters exceeded

Related questions

0 Answers

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.