Skip to Content
avatar image
Former Member

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

Hi,

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

I intend to make it into a transaction-code

Regards

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    May 17, 2017 at 10:22 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 18, 2017 at 12:47 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • May 18, 2017 at 05:49 AM

    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

    Add comment
    10|10000 characters needed characters exceeded