Table Join in ABAP Query

[Former Member]

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?

[Former Member]

Check SAP F1 Help .....

Type INER JOIN in se38 and press F1 selecting that

Regards,

Prakash

[kesavadas_thekkillath]

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

[Former Member]

Hi:

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

Regards

Shashi

[Former Member]

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]

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

[Former Member]

Check SAP F1 Help .....

Type INER JOIN in se38 and press F1 selecting that

Regards,

Prakash

[Former Member]

Hi

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.