topic Re: inner join for three table in Application Development and Automation Discussions

inner join for three table

former_member659396 — Wed, 17 Sep 2008 11:15:21 GMT

dear friends

kna1- kunnr ,name1

vbak - vbeln , erdat

vbap - meins , kwmeng

on above i have given three tables and their fields in front of this

can any one tel me how to give inner join in select statement for the above tables

Re: inner join for three table

Former Member — Wed, 17 Sep 2008 11:18:41 GMT

Hi,

You can do the following mapping:

VBAK-Customer Number = KNA1-KUNNR.
VBAK_VBELN = VBAP-VBELN.

This is the link that you will have to use to write inner join to get the required fields.

Regards,

Kunjal

Re: inner join for three table

Former Member — Wed, 17 Sep 2008 11:21:50 GMT

Hi Create an appropriate internal table ITAB

Select VBAK~VBELN

VBAK~ERDAT

VBAP~POSNR

VBAP~MEINS

VBAP~kwmeng

KNA1~KUNNR

KNA1~NAME1

From VBAK

Into Table ITAB

Inner Join VBAP On VBAK_{VBELN = VBAP}VBELN

Inner Join KNA1 On VBAK~KUNNR = KNA1-KUNNR

Where VBAK~VBELN In S_VBELN.

Santhosh

Re: inner join for three table

Former Member — Wed, 17 Sep 2008 11:21:59 GMT

Hi,



select 
a~vbeln
a~erdat
b~meins 
b~kwmeng
c~kunnr
c~name1

INTO TABLE i_final FROM  ( ( vbak AS a
           INNER JOIN vbap AS b ON   a~vbeln    = b~vbeln )
           INNER JOIN kna1 AS c ON   a~kunnr  = c~kunnr )

Regards

Sandipan

Re: inner join for three table

Former Member — Wed, 17 Sep 2008 11:23:16 GMT

Hi,

Use KUNNR as common field between VBAK and KNA1 and vbeln as common field between VBAK and VBAP and have a join some thing like below

select vbak_{vbeln vbak}erdat

vbap_{vbeln vbap}meins vbap~kwmeng

kna1_{kunnr kna1}name1

from vbak inner join vbap

on vbak_{vbeln = vbap}vbeln

inner join kna1 on vbak_{kunnr = kna1}kunnr.

Thanks

Sudharshan

Re: inner join for three table

Former Member — Wed, 17 Sep 2008 11:24:46 GMT

Check the psudo code below.

select a~kunnr

b~vbeln

c~posnr

into table it_table

from kna1 as a inner join vbak as b

on a_{kunnr eq b}kunnr

inner join vbap

on b_{vbeln eq c}vbeln

where.......

Murthy.

Edited by: pr murthy on Sep 17, 2008 1:25 PM

Re: inner join for three table

former_member659396 — Fri, 16 Jan 2009 09:06:34 GMT

THANKS