Join two Custom Analytical Queries in a single Query

[SAPSupport]

Hi SAP,

We need a solution to combine two Custom Analytical Queries into a single query to generate the required report for our organization.

Kind regards.

------------------------------------------------------------------------------------------------------------------------------------------------
Learn more about the SAP Support user and program here.

[SAPSupport · Accepted solution]

Dear Customer,

There is no option to add multiple data sources in the Custom Analytical Queries app. Instead, you can add multiple sources in a custom CDS view using the Custom CDS Views app. 

Therefore, the suggestion for you is to first complete your table configurations in the Custom CDS Views app and once it's good to be exposed in a Query, then you should create it in the Custom Analytical Queries app.

In your case, you have 2 Custom Analytical Queries. Therefore, you have two Custom CDS Views that are on the top of these queries. What you need to do now is to join these two Custom CDS Views to create a new one and then create a Query on the top of this new one.

Please keep in mind that both Custom CDS Views need to have unique fields that you can use to join them.  When you create a Join Condition inside a Custom CDS View, SAP has a button that says "Propose Join Condition" and the system will provide you a suggestion of elements to join both views.

Kind regards,

SAP Support.