Merge two reports Sap bydesign

[NirMenashe]

Hello,

In order to see all the receipts in Sap business bydesign for both product and services I need to use two reports:

Goods receipt tracking

Inbound delivery detailed line item

I'd like to merge those two reports (in SQL i used to use UNION function)

how can I do it in Sap by design?

Regards

Nir

[gavan_gu]

Dear Nir,

Please view Help Portal Design Data Sources Quick Guide to understand below tasks.

• Create a Combined Data Source
• Create a Joined Data Source
• Create a Cloud Data Source

If the above tasks don't meet your needs, that means it's currently not supported by the system.

Best regards,

Gavan

SAP Business ByDesign| Product Support

[gavan_gu]

Dear Nir,

You can try to combine the data sources of both reports and then create a new report based on the new combined data source. 

1. Go to Business Analytics Work Center.
2. Navigate to Design Reports View.
3. Search for report Goods receipt tracking, you will understand the corresponding data source is Goods Receipt Item Details.
4. Search for report Inbound delivery detailed line item, you will understand that the corresponding data source is Inbound Delivery Item Details.
5. Navigate to Data Sources View.
6. Choose New- Combined Data Source button.
7. Choose Add Data Source button to add above two data sources.
8. Fulfill other fields s as you like.
9. Choose Save and Close button.
10. Back to Data Sources View.
11. Choose New Report button.
12. Search for the new custom data source you combined and select it.
13. Fulfill other fields as you like.
14. Choose Finish button.

Best regards,

Gavan

SAP Business ByDesign| Product Support

[NirMenashe]

Hi Gavan, thank you for your reply, the combined data source work as a full join, I'm looking for somthing as a UNION in SQL in order to see the product items and the service items in one column, regards Nir

[gavan_gu]

Dear Nir,

[NirMenashe]

Hi Gavan, I've only saw Dear Nir......

[NirMenashe]

Hi Gavan, any comment to my question?