on 11-27-2008 1:50 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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.
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.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.