How to union two tables with sapquery(SQ01、SQ02)

[Former Member]

Hi,

could you tell me how to union two tables with sapquery(SQ01、SQ02)

I intend to make it into a transaction-code

Regards

[sbongile_msane]

Hi TM

Please check this trend

https://archive.sap.com/discussions/message/6404085#64

To create customized T code you use transaction code SE93

Thanks

Sbo

[Former Member]

HI　Sbo

I check your linksite.

but I did not have ”UNION” information I wanted.

with sapquery,I would like to know how to connect two or more tables vertically like (SQL ”UNION”)

thanks.

[Sandra_Rossi]

You can do your own ABAP code, to extract the data, inside the infoset. Cf SAP Library: infoset - using an external program to read data