Community
Application Development and Automation 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: 
Read only

Inner Join

Former Member

‎2007 Sep 05 4:28 AM

0 Likes
812

Hi All,

I want to create inner join between <b>KONV</b> table (Condition Transaction Data) and <b>VBAK / VBRK / VBRP</b> (with anyone)...but not possible becuase, <b>KONV</b> is the cluster table.....

wat can i do.....because i want to take field <b>KONV-KSCHL</b> (CONDITION TYPE) from this table, if u have any other idea or suggest me take another table, in which join will possible.....

Thanks & Regards,

<b>Anil Kumar</b>

Hi All,

I want to create inner join between <b>KONV</b> table (Condition Transaction Data) and <b>VBAK / VBRK / VBRP</b> (with anyone)...but not possible becuase, <b>KONV</b> is the cluster table.....

wat can i do.....because i want to take field <b>KONV-KSCHL</b> (CONDITION TYPE) from this table, if u have any other idea or suggest me take another table, in which join will possible.....

Thanks & Regards,

<b>Anil Kumar</b>

Reply
4 REPLIES 4
Read only

gopi_narendra
Active Contributor

‎2007 Sep 05 4:31 AM

0 Likes
730

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

from the KNUMV you can get the Condition Type KSCHL

I have answered the same in your previous post.

Kindly close this thread.

Regards

Gopi

Read only

Former Member

‎2007 Sep 05 4:35 AM

0 Likes
730

Hi Anil,

You can use FOR ALL ENTRIES..

Fetch all the Billing document numbers from VBRK and then for them fetch KSCHL..

SELECT KSCHL

FROM KONV

INTO CORRESPONDING FIELDS OF tab

FOR ALL ENTRIES IN TAB

WHERE vbeln EQ tab-vbeln.

But, for billing data i prefer to use FM:

RV_BILLING_PRINT_VIEW

RV_PRICE_PRINT_ITEM

RV_PRICE_PRINT_HEAD

Thanks and Best Regards,

Vikas Bittera.

Read only

Former Member

‎2007 Sep 05 6:23 AM

0 Likes
730

Hi,

First retrieve KNUMV from VBAK or VBRK table and keep in ITAB1. Pass this KNUMV field value to KONV table using FOR ALL ENTRIES of ITAB1 and get KSCHL and keep in ITAB2.

I have already answered this question, to ur earlier question.

Message was edited by:

Sathyaa

Read only

Former Member

‎2007 Sep 25 1:04 PM

0 Likes
730

You Can Join <b>KONP</b> table with VBRP with <b>KNUMH</b> field to get KSCHL

reward if useful

Amit Singla.