Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Joining tables

Former Member

‎08-19-2005 7:06 AM

0 Kudos

Hello,

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

5 REPLIES 5

Former Member

‎08-19-2005 7:21 AM

0 Kudos

Hi George

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

Regards

Ashish Jain

jayanthi_jayaraman
Active Contributor

‎08-19-2005 7:26 AM

0 Kudos

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
Active Contributor

‎08-19-2005 7:28 AM

0 Kudos

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
In response to athavanraja

‎08-19-2005 8:40 AM

0 Kudos

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

‎08-19-2005 3:29 PM

0 Kudos

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.