topic Re: Table Join in ABAP Query in Application Development and Automation Discussions

Table Join in ABAP Query

Former Member — Mon, 23 Feb 2009 10:43:25 GMT

Hi,

I'm new to ABAP Query. I want to include a table and join with an existing table in abap query. how to do this?

kesavadas_thekkillath — Mon, 23 Feb 2009 10:44:22 GMT

Check for ABAP Documentation for SQL BAsics... Or search it in forums

Former Member — Mon, 23 Feb 2009 10:44:42 GMT

Hi:

[Link|http://www.thespot4sap.com/Articles/SAP_ABAP_Queries_Create_The_Query.asp]

Regards

Shashi

Former Member — Mon, 23 Feb 2009 10:45:45 GMT

Check SAP F1 Help .....

Type INER JOIN in se38 and press F1 selecting that

Regards,

Prakash

Former Member — Mon, 23 Feb 2009 10:48:15 GMT

select lips_{vbeln lips}lfimg likp~wadat

into corresponding fields of table ltab_orders

from lips join likp on ( lips_{vbeln = likp}vbeln )

join vbfa on ( lips_{vbeln = vbfa}vbelv )

where lips~matnr = matnr

and lips~vbeln in vbeln

and likp~vbeln in vbeln

and vbfa~vbelv in vbeln

and lips~werks in werks

and likp~wadat in datum

and vbfa~vbtyp_n = 'Q'

and vbfa~vbtyp_v = 'J'.

Thanks,

Neelima.

Former Member — Mon, 23 Feb 2009 12:02:17 GMT

Thanks. But Query already exists. I want to add one more table to this. which transaction do I use for that? is it SQ01 ? then how to proceed?

ThomasZloch — Mon, 23 Feb 2009 12:14:58 GMT

Did you start SQ01? How is it called, does that sound right? Did you try looking at help -> application help?

Even if you're new to it you should do a basic amount of research yourself, then what you found out will stick much better.

Thomas