inner join for three table

[former_member659396]

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

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

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

[former_member659396]

THANKS