topic Re: Joining tables in Application Development and Automation Discussions

Joining tables

Former Member — Fri, 19 Aug 2005 06:06:56 GMT

Hello,

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

Re: Joining tables

Former Member — Fri, 19 Aug 2005 06:21:49 GMT

Hi George

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

Regards

Ashish Jain

Re: Joining tables

jayanthi_jayaraman — Fri, 19 Aug 2005 06:26:56 GMT

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.

Re: Joining tables

athavanraja — Fri, 19 Aug 2005 06:28:18 GMT

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

Re: Joining tables

Former Member — Fri, 19 Aug 2005 07:40:19 GMT

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

Re: Joining tables

Former Member — Fri, 19 Aug 2005 14:29:55 GMT

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.