I'd like to Combine or Join the 2 data sources
to then search for and calculate specific data, e.g. the sum of specific cost centre bookings and the sum of all goods-out postings both for the same date. To then show them side-by-side as calculated key figure, e.g. Column A: 200 EUR and Column B: 300 kg on the 3rd of May 2019.
Unfortunately the only overlapping info in both data sources are
SCMCFJU01 < > FINGLAU02
BT_DATE < > POSTING_DATE
PE_UUID < > PROFITCTR_UUID
As I have some more (2-4) selection criteria for each source I'd like to ask for a best practice how to merge these 2 data sources when these 4 characterstics are the only overlapping ones. At the moment I'm only able to combine these 2 data sources and my selections will only generate the requested data from one of the sources.