Joining tables

[Former Member]

Hello,

Is there a way to have a simple join on a few tables and see the result, without writting an ABAP program ?

[Former Member]

Hi George

try making a database view on the desired tables (using SE11 -> view)

Regards

Ashish Jain

[jayanthi_jayaraman]

Hi,

Check this link.It will help you on creating views.

http://help.sap.com/saphelp_40b/helpdata/en/4f/991f82446d11d189700000e8322d00/applet.htm

Kindly reward points by clicking the star on the left of the reply,if it is useful.

[athavanraja]

SAP Query is one option.

check out the following link for details.

http://help.sap.com/saphelp_erp2004/helpdata/en/d2/cb3efb455611d189710000e8322d00/content.htm

Regards

Raja

[Former Member]

Hi,

SAP Query will solve your problem

Goto SQ02 create Infoset and assign the infoset to the user group, then goto transaction SQ01 design the query from the previous infoset which you created.

Cheers,

Sasi

[Former Member]

If it is only a temporary query , and not really a report, Quickviewer might be more appropriate. It is much easier to ceate a quickview.

transaction: SQVI

regards,

Joris.