Combine two different table values in single table

[Former Member]

Hi all,

I am acessing SAP Query in VC. I have two different tables. i want to combine two different table values in single table. How can i solve it?

Thanks&regards,

Hema

[Former Member]

Hi,

In case tables have same structure, just use Union or Intersect operators (see additional operators in VC composition elements)

In case you want to merge tables with two structures, so having fields of table 1 + fields of table 2 in a table 3 this is not possible in VC, you need to create a new query or an RFC that'll make the fusion for you.

Rgds,

Karim

[Former Member]

Thanks for your reply