topic Inner Join in Application Development and Automation Discussions

Inner Join

Former Member — Wed, 05 Sep 2007 03:28:06 GMT

Hi All,

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

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

Thanks & Regards,

Anil Kumar

Re: Inner Join

gopi_narendra — Wed, 05 Sep 2007 03:31:01 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

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

Re: Inner Join

Former Member — Wed, 05 Sep 2007 03:35:05 GMT

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.

Re: Inner Join

Former Member — Wed, 05 Sep 2007 05:23:08 GMT

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

Re: Inner Join

Former Member — Tue, 25 Sep 2007 12:04:05 GMT

You Can Join KONP table with VBRP with KNUMH field to get KSCHL

reward if useful

Amit Singla.