Output from two data services into one table view.

[Former Member]

Hi all,

In my model I have one input form that feeds two data services (CRM_SEARCH_BUSINESSACTIVITY and CRM_BUPA_BSP_RESULT_ACCOUNT). How can I combine the output from those two services into one table view? I have tried to use the union operator, but this only allows me to add a form. I need the data to be displayed in a table view.

Any help will be appreciated and rewarded with points offcourse

Thanks in advance and best regards,

Jan

[Former Member]

Hi,

Yes ,you can go With Jan Solution.

otherwise you can use Combine operator but here the Duplicates will not be removed as in Union Operator.

Thank,

Govindu

[Former Member]

Good morning,

Thanks for your replies. Yesterday evening I tried it again with the Union operator and I could connect it to an output table, but it errors with a message that I need to set at least one key field. How can I do that?

By the way: I tried to use the combine operator as well, but it only uses the first data service and ignores the second one. This is normal behaviour as I have read in the documentation. So that is not an option.

Best regards,

Jan

[Former Member]

Hi,

I have the same problem. One thing to follow seems to be :

"UNION

A UNION-statement allows you to stitch recordsets into one longer recordset. One prerequisite is that your recordset have the same number of fields. In addition, depending of where you do the UNION (VC-side or backend), you might be required that the underlying recordsets have the same field names in all recordsets.

Note: even on the backend side UNION-statements tend to be performance intensive."

extracted from https://www.sdn.sap.com/irj/scn/wiki?path=/display/vc/combining%252btwo%252btables%252c%252bbapis%25...

Fabien.

[Former Member]

You can also check http://help.sap.com/saphelp_nw70/helpdata/en/e9/9ef13c23304bf19d2e7ff22eb760d5/frameset.htm

Field :

Field whose values are unified

Key :

Checkbox for selecting the Field

The key field seems to be the field where you unify the data.

Fabien.

[Former Member]

Hi Fabien,

Somehow I am not able to configure this union operator. I can not change any property or filed when clicking it. Can you provide some help or steps? Thanks in advance!

Best regards,

Jan

[Former Member]

Hi,

your union is a good idea, do not change anything.

Except one : select a table in the right panel named "Compose", add it to your model, and join the union output to your table.

Do not forget to make your new table fields visible.

Hope this works, I'll test it.

Fabien.