Putting outputs from 2 different sources in one table

27 Views

Hi SAP guys,

Another question for you guru's..

I am having 2 BI_SOURCES, one for tasks and the other one deals with 'principal assignments'. So we can find the actual/potential owner.

In the task source there is an entry field 'ID-DISPLAY KEY'which equals the REFERENCE-ID-DISPLAY KEYin the other source. With that 'REFERENCE-ID-DISPLAY_KEY' I am able to get the actual/potential owners where I filter to only get the actual owner.

However, now this happens via copying data from the task table into a 'form' and that then results in a table where the actual owner is displayed. (see screenshots).

What I would like to achieve is that the actual owner is displayed in the same table as the the tasks. However, I have tried via union but did not succeed to make the correct combination. In that way I would also avoid having the filter + an extra column which makes it lighter and easier for the users in the future to spot the actual owner.

Thanks in advance,

Jan

Attachments

Capture.PNG (70.3 kB)