topic Re: Inner Join in Application Development and Automation Discussions

Inner Join

Former Member — Wed, 05 Sep 2007 03:17:10 GMT

Hi All,

I want to create inner join between KONV table (Condition Transaction Data) and VBAK / VBRK / VBRP (with anyone)...but there is no common field....

wat can i do.....

Thanks & Regards,

Anil Kumar

Re: Inner Join

gopi_narendra — Wed, 05 Sep 2007 03:26:30 GMT

the table VBAK has the field KNUMV - Number of the document condition

from this VBAK-KNUMV get the record from KONV table.

Join is not suggested on KONV with VBAK / VBRK tables because KONV is a cluster table. Instead you can use FOR ALL ENTRIES of IT_VBAK

Regards

Gopi

Re: Inner Join

Former Member — Wed, 05 Sep 2007 03:38:32 GMT

Hi I think you can join KNA1 and VBRP through EKONT. Goto KONV cluster table click on Graphic layout besides the CONTENTS button. It will take u to different tables connected to KONV. Check if u have any common field among these 3 tables. I found the field EKONT. It may help u ....

Re: Inner Join

Former Member — Wed, 05 Sep 2007 04:39:51 GMT

Check out this blog,

it'll surely help you out:

/people/dushyant.shetty/blog/2007/08/21/tool-for-abap-developers-easy-abap-open-sql-joins

Regards

Ravish Garg

Reward if useful

Re: Inner Join

Former Member — Wed, 05 Sep 2007 05:01:24 GMT

Hi,

Check the following link:

http://sap-img.com/abap/inner-joins.htm

Regards,

Bhaskar

Re: Inner Join

Former Member — Wed, 05 Sep 2007 05:06:27 GMT

Hi Anil,

In VBAK and VBRK u have the field KNUMV( no. of document condition). So from any of these two tables extract KNUMV field and keep it in a internal table, say ITAB1. Then use another query to select KNUMV and other fields from KONV table to ITAB2 using FOR ALL ENTRIES of ITAB1. U cannot use join in KONV table, as it is a CLUSTER table.

Reward if useful.

Message was edited by:

Sathya